分页jsp代码

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

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

    String url = "your_database_url";
    String user = "your_username";
    String password = "your_password";

    try {
        Connection conn = DriverManager.getConnection(url, user, password);
        String sql = "SELECT * FROM your_table LIMIT ? OFFSET ?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, pageSize);
        pstmt.setInt(2, offset);
        ResultSet rs = pstmt.executeQuery();

        while (rs.next()) {
            // 输出每条记录
            out.println(rs.getString("column_name") + "<br>");
        }

        rs.close();
        pstmt.close();
        conn.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>

<!-- 分页导航 -->
<div>
    <a href="?page=<%= currentPage - 1 %>">上一页</a>
    <a href="?page=<%= currentPage + 1 %>">下一页</a>
</div>