Java优学网MySQL分页查询教程：轻松掌握高效数据分页技巧

SELECT * FROM table_name LIMIT offset, row_count;

public List getUsersByPage(int pageNum, int pageSize) {

List<User> users = new ArrayList<>();
String sql = "SELECT * FROM users ORDER BY id LIMIT ? OFFSET ?";

try (Connection conn = dataSource.getConnection();
     PreparedStatement pstmt = conn.prepareStatement(sql)) {
    
    int offset = (pageNum - 1) * pageSize;
    pstmt.setInt(1, pageSize);
    pstmt.setInt(2, offset);
    
    ResultSet rs = pstmt.executeQuery();
    while (rs.next()) {
        User user = new User();
        user.setId(rs.getInt("id"));
        user.setName(rs.getString("name"));
        // 其他字段赋值...
        users.add(user);
    }
} catch (SQLException e) {
    e.printStackTrace();
}
return users;

}