[Java代码] JDBC分页工具类

1. package com.iflytek.page;

2. http://www.kmnk01.com/hxpfk/2015/myzj_1125/107.html

3. /**
4. * 分页工具类
5. *
6. * @author xudongwang 2012-1-19
7. *

   http://www.kmnk01.com/hxpfk/2015/myzj_1125/108.html

8. * Email:xdwangiflytek@gmail.com
9. */

   http://www.kmnk01.com/hxpfk/2015/myzj_1125/109.html

10. public class Page {

11. http://www.kmnk01.com/hxpfk/2015/myzj_1125/110.html

12. /**
13. * 总记录数
14. */
15. private int totalRow;

    http://www.kmnk01.com/hxpfk/2015/myzj_1125/111.html

17. /**
18. * 每页记录数
19. */

    http://www.kmnk01.com/hxpfk/2015/zlff_1125/112.html

20. private int pageSize = 10;
22. /**
23. * 当前页码
24. */
25. private int currentCount;

    http://www.kmnk01.com/hxpfk/2015/zlff_1125/113.html

27. /**
28. * 总页数
29. */
30. private int total;

31. http://www.kmnk01.com/hxpfk/2015/zlff_1125/114.html

32. /**
33. * 起始记录下标
34. */
35. private int beginIndex;

36. http://www.kmnk01.com/hxpfk/2015/zlff_1125/115.html

37. /**
38. * 截止记录下标
39. */
40. private int endIndex;
42. /**

    http://www.kmnk01.com/hxpfk/2015/zlff_1125/115.html

43. * 构造方法，使用总记录数，当前页码
44. *

    http://www.kmnk01.com/hxpfk/2015/zlff_1125/117.html

45. * @param totalRow
46. * 总记录数
47. * @param currentCount

    http://www.kmnk01.com/hxpfk/2015/zlff_1125/117.html

48. * 当前页面，从1开始
49. */
50. public Page(int totalRow, int currentCount) {

    http://www.kmnk01.com/hxpfk/2015/yydt_1125/119.html

51. this.totalRow = totalRow;
52. this.currentCount = currentCount;
53. calculate();

    http://www.kmnk01.com/hxpfk/2015/yydt_1125/120.html

54. }
56. /**

    http://www.kmnk01.com/hxpfk/2015/yydt_1125/121.html

57. * 构造方法 ，利用总记录数，当前页面
58. *
59. * @param totalRow

    http://www.kmnk01.com/hxpfk/2015/mtbd_1125/122.html

60. * 总记录数
61. * @param currentCount

    http://www.kmnk01.com/hxpfk/2015/mtbd_1125/123.html

62. * 当前页面
63. * @param pageSize
64. * 默认10条
65. */
66. public Page(int totalRow, int currentCount, int pageSize) {
67. this.totalRow = totalRow;
68. this.currentCount = currentCount;
69. this.pageSize = pageSize;

    http://www.kmnk01.com/hxpfk/2015/xjsb_1125/124.html

70. calculate();
71. }
73. private void calculate() {
74. total = totalRow / pageSize + ((totalRow % pageSize) > 0 ? 1 : 0);
76. if (currentCount > total) {
77. currentCount = total;
78. } else if (currentCount < 1) {
79. currentCount = 1;

    http://www.kmnk01.com/hxpfk/2015/xjsb_1125/125.html

80. }
82. beginIndex = (currentCount - 1) * pageSize;
83. endIndex = beginIndex + pageSize;
84. if (endIndex > totalRow) {
85. endIndex = totalRow;
86. }
87. }
89. public int getTotalRow() {
90. return totalRow;

    http://www.kmnk01.com/hxpfk/2015/xjsb_1125/126.html

91. }
93. public int getPageSize() {
94. return pageSize;
95. }
97. public int getCurrentCount() {
98. return currentCount;
99. }
101. public int getTotal() {
102. return total;
103. }
105. public int getBeginIndex() {
106. return beginIndex;
107. }
109. public int getEndIndex() {
110. return endIndex;
111. }
113. }

复制代码

继续

在后台获取前台传进来的页码 //从页面取得页码

1. int currentPage = 1;
2. try {
3. currentPage = Integer.parseInt(request.getParameter("currentPage"));
4. } catch (Exception ex) {}
6. //取得总记录数，创建Page对象
7. int totalRow = studentDao.getAllStudents();//通过select count 取得总记录数
8. Page page = new Page(totalRow, currentPage);
9. studentDao.list(page);

复制代码

数据访问层， StduentDao.java

1. public List<Stduent> getStudentsByPage(Page page) {
2. List<Stduent> students = new ArrayList<Stduent>();
3. try {
4. String sql = "SELECT id,name,email FROM tbl_stduent";
5. Connection conn = null;
6. try {
7. conn = DbUtil.getConnection();
8. Statement statement = conn.createStatement();
9. statement.setMaxRows(page.getEndIndex());//关键代码，设置最大记录数为当前页记录的截止下标
10. ResultSet resultSet = statement.executeQuery(sql);
11. if (page.getBeginIndex() > 0) {
12. resultSet.absolute(page.getBeginIndex());//关键代码，直接移动游标为当前页起始记录处
13. }
14. while (resultSet.next()) {
15. Stduent student = new Student();
16. ……
17. students.add(student);
18. }
19. resultSet.close();
20. statement.close();
21. } finally {
22. if (conn != null) {
23. conn.close();
24. }
25. }
26. } catch (SQLException e) {
27. e.printStackTrace();
28. }
29. return students;
30. }

复制代码