jsp查询分页代码

<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>

<%
    int pageSize = 10; // 每页显示的记录数
    int currentPage = request.getParameter("page") != null ? Integer.parseInt(request.getParameter("page")) : 1;
    int offset = (currentPage - 1) * pageSize;

    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    try {
        Context initContext = new InitialContext();
        DataSource ds = (DataSource) initContext.lookup("java:/comp/env/jdbc/YourDB");
        conn = ds.getConnection();

        String sql = "SELECT * FROM your_table LIMIT ? OFFSET ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, pageSize);
        pstmt.setInt(2, offset);
        rs = pstmt.executeQuery();

        while (rs.next()) {
            // 处理每一行数据
            out.println(rs.getString("column_name") + "<br>");
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (rs != null) rs.close();
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
    }
%>

<div>
    <a href="?page=1">First</a>
    <a href="?page=<%= currentPage - 1 %>">Previous</a>
    <a href="?page=<%= currentPage + 1 %>">Next</a>
    <a href="?page=<%= totalPages %>">Last</a>
</div>

int currentPage = request.getParameter("page") != null ? Integer.parseInt(request.getParameter("page")) : 1;
if (currentPage < 1) currentPage = 1; // 防止负数页码