jsp的mysql数据库分页

import java.sql.*;

public class DBConnection {
    public static Connection getConnection() throws SQLException {
        String url = "jdbc:mysql://localhost:3306/your_database";
        String user = "your_username";
        String password = "your_password";
        return DriverManager.getConnection(url, user, password);
    }
}

import java.sql.*;
import java.util.*;

public class Pagination {
    private int pageSize; // 每页显示的记录数
    private int currentPage; // 当前页码
    private int totalRecords; // 总记录数
    private int totalPages; // 总页数

    public Pagination(int pageSize, int currentPage) {
        this.pageSize = pageSize;
        this.currentPage = currentPage;
    }

    public List<Map<String, Object>> getPageData(String sql) throws SQLException {
        List<Map<String, Object>> result = new ArrayList<>();
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;

        try {
            conn = DBConnection.getConnection();
            // 查询总记录数
            String countSql = "SELECT COUNT(*) FROM (" + sql + ") AS temp";
            pstmt = conn.prepareStatement(countSql);
            rs = pstmt.executeQuery();
            if (rs.next()) {
                totalRecords = rs.getInt(1);
            }
            totalPages = (int) Math.ceil((double) totalRecords / pageSize);

            // 查询当前页数据
            String pageSql = sql + " LIMIT ?, ?";
            pstmt = conn.prepareStatement(pageSql);
            pstmt.setInt(1, (currentPage - 1) * pageSize);
            pstmt.setInt(2, pageSize);
            rs = pstmt.executeQuery();

            ResultSetMetaData metaData = rs.getMetaData();
            int columnCount = metaData.getColumnCount();

            while (rs.next()) {
                Map<String, Object> row = new HashMap<>();
                for (int i = 1; i <= columnCount; i++) {
                    row.put(metaData.getColumnName(i), rs.getObject(i));
                }
                result.add(row);
            }
        } finally {
            if (rs != null) rs.close();
            if (pstmt != null) pstmt.close();
            if (conn != null) conn.close();
        }

        return result;
    }

    // Getters for totalRecords, totalPages, etc.
}

<%@ page import="java.util.*, com.example.Pagination" %>
<%
    int pageSize = 10;
    int currentPage = request.getParameter("page") != null ? Integer.parseInt(request.getParameter("page")) : 1;
    String sql = "SELECT * FROM your_table";

    Pagination pagination = new Pagination(pageSize, currentPage);
    List<Map<String, Object>> data = pagination.getPageData(sql);
%>

<table border="1">
    <tr>
        <th>Column 1</th>
        <th>Column 2</th>
        <!-- Add more columns as needed -->
    </tr>
    <% for (Map<String, Object> row : data) { %>
        <tr>
            <td><%= row.get("column1") %></td>
            <td><%= row.get("column2") %></td>
            <!-- Add more columns as needed -->
        </tr>
    <% } %>
</table>

<div>
    <% for (int i = 1; i <= pagination.getTotalPages(); i++) { %>
        <a href="?page=<%= i %>"><%= i %></a>
    <% } %>
</div>