java jsp mysql分页（原代码）

package dao; import java.util.*; import java.sql.*; import bean.User; public class PaginationUtil { GetConn getConn = new GetConn(); Connection conn = getConn.getConn(); // 根据分页 public List findGrade(int page, int pagesize) { String strSql = "select * from urlrequestpojo order by id limit " + (page - 1) * pagesize + "," + pagesize + ""; // 定义SQL查询语句 Statement pstmt = null; ResultSet rs = null; // 定义查询结果集对象 List<User> lstList = new ArrayList(); // 定义集合对象 try { pstmt = conn.createStatement(); rs = pstmt.executeQuery(strSql); // 执行查询语句 while (rs.next()) { // 循环遍历查询结果集 User user = new User(); // 创建user user.setId(rs.getInt("id")); user.setUrl(rs.getString("url")); user.setIpaddress(rs.getString("ipaddress")); user.setRequesttime(rs.getString("requesttime")); user.setChannel(rs.getString("channel")); lstList.add(user); // 向集合中添加对象 } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) { rs.close(); pstmt.close(); } } catch (Exception e) { e.printStackTrace(); } } return lstList; // 返回查询集合对象 } /** * * @param page 第几页 * @param pagesize 每页显示记录数 * @return 返回结果集 */ public ResultSet findOrder(int page, int pagesize) { String strSql = "select * from urlrequestpojo order by id limit " + (page - 1) * pagesize + "," + pagesize + ""; // 定义SQL查询语句 Statement pstmt = null; ResultSet rs = null; // 定义查询结果集对象 try { pstmt = conn.createStatement(); rs = pstmt.executeQuery(strSql); // 执行查询语句 } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) { rs.close(); pstmt.close(); } } catch (Exception e) { e.printStackTrace(); } } return rs; // 返回结果集 } public int allPage(int pagesize) { int allp = 0; try { Statement pstmt = conn.createStatement(); pstmt.execute("select count(*) from urlrequestpojo"); ResultSet rs = pstmt.getResultSet(); // System.out.print("00"); rs.next(); int all = rs.getInt(1); // System.out.print(all); allp = (all - 1) / pagesize + 1; // System.out.println(allp); } catch (SQLException e) { e.printStackTrace(); } return allp; } public static void main(String[] args) { // PaginationUtil pageinationUtil = new PaginationUtil(); // List list = pageinationUtil.findGrade(2, 6); // for (int i = 0; i < list.size(); i++) { // User user = (User) list.get(i); // System.out.println(user.getId()); // } } }