jsp分页模板

int pageSize = 10; // 每页显示条数
int currentPage = Integer.parseInt(request.getParameter("page")); // 当前页码
int offset = (currentPage - 1) * pageSize;

String sql = "SELECT * FROM table_name LIMIT ? OFFSET ?";
try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
    pstmt.setInt(1, pageSize);
    pstmt.setInt(2, offset);
    ResultSet rs = pstmt.executeQuery();
    // 处理结果集并传递给JSP页面
} catch (SQLException e) {
    e.printStackTrace();
}

<%@ page import="java.util.List" %>
<%@ page import="com.example.Item" %>

<%
    List<Item> items = (List<Item>) request.getAttribute("items");
    int currentPage = Integer.parseInt(request.getParameter("page"));
    int totalPages = (int) request.getAttribute("totalPages");
%>

<table>
    <tr>
        <th>ID</th>
        <th>Name</th>
    </tr>
    <% for (Item item : items) { %>
        <tr>
            <td><%= item.getId() %></td>
            <td><%= item.getName() %></td>
        </tr>
    <% } %>
</table>

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