分页简单封装

systemcookie

浏览: 3474 次

最近访客更多访客>>

dalin_shi

gogo123150

qq_anqi

chokee

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2013-07 ( 4)
更多存档...

定义分页模型：PageModel

查看源码打印?
001 package com.common.page;

002

003 import java.util.List;

004

005 /**

006 * 封装分页信息

007 * @author Administrator

008 *

009 */

010 public class PageModel<E> {

011

012     //结果集

013     private List<E> list;

014

015     //查询记录数

016     private int totalRecords;

017

018     //每页多少条数据

019     private int pageSize;

020

021     //第几页

022     private int pageNo;

023

024     /**

025      * 总页数

026      * @return

027      */

028     public int getTotalPages() {

029         return (totalRecords + pageSize - 1) / pageSize;

030     }

031

032     /**

033      * 取得首页

034      * @return

035      */

036     public int getTopPageNo() {

037         return 1;

038     }

039

040     /**

041      * 上一页

042      * @return

043      */

044     public int getPreviousPageNo() {

045         if (pageNo <= 1) {

046             return 1;

047         }

048         return pageNo - 1;

049     }

050

051     /**

052      * 下一页

053      * @return

054      */

055     public int getNextPageNo() {

056         if (pageNo >= getBottomPageNo()) {

057             return getBottomPageNo();

058         }

059         return pageNo + 1;

060     }

061

062     /**

063      * 取得尾页

064      * @return

065      */

066     public int getBottomPageNo() {

067         return getTotalPages();

068     }

069

070     public List<E> getList() {

071         return list;

072     }

073

074     public void setList(List<E> list) {

075         this.list = list;

076     }

077

078     public int getTotalRecords() {

079         return totalRecords;

080     }

081

082     public void setTotalRecords(int totalRecords) {

083         this.totalRecords = totalRecords;

084     }

085

086     public int getPageSize() {

087         return pageSize;

088     }

089

090     public void setPageSize(int pageSize) {

091         this.pageSize = pageSize;

092     }

093

094     public int getPageNo() {

095         return pageNo;

096     }

097

098     public void setPageNo(int pageNo) {

099         this.pageNo = pageNo;

100     }

101 }
2、分页测试：在MySQL中建立admin表，里面有字段id、name、password

3、简历Admin的实体bean类：

查看源码打印?
01 package com.common.page;

02

03 public class Admin {

04     private int id;

05     private String name;

06     private String password;

07     public int getId() {

08         return id;

09     }

10     public void setId(int id) {

11         this.id = id;

12     }

13     public String getName() {

14         return name;

15     }

16     public void setName(String name) {

17         this.name = name;

18     }

19     public String getPassword() {

20         return password;

21     }

22     public void setPassword(String password) {

23         this.password = password;

24     }

25

26 }

4、测试调用：
查看源码打印?
01 package com.common.page;

02

03 import java.sql.Connection;

04 import java.sql.PreparedStatement;

05 import java.sql.ResultSet;

06 import java.sql.SQLException;

07 import java.util.ArrayList;

08 import java.util.List;

09

10 import com.common.db.DbUtil;

11

12 public class Client {

13     public static PageModel findAdmins(int pageNo,int pageSize){

14         Connection conn=DbUtil.getConnection();

15         String sql="select * from admin limit ?,?";

16         PageModel pageModel=null;

17         PreparedStatement pstm=null;

18         ResultSet rs=null;

19         Admin admin=null;

20         List<Admin> list=new ArrayList<Admin>();

21         try {

22             pstm=conn.prepareStatement(sql);

23             pstm.setInt(1, (pageNo-1)*pageSize);

24             pstm.setInt(2, pageNo*pageSize);

25             rs=pstm.executeQuery();;

26             while(rs.next()){

27                 admin=new Admin();

28                 admin.setId(rs.getInt("a_id"));

29                 admin.setName(rs.getString("a_name"));

30                 admin.setPassword(rs.getString("a_pwd"));

31                 list.add(admin);

32             }

33             ResultSet rs2=pstm.executeQuery("select count(*) from admin");

34             int total=0;

35             if(rs2.next()){

36                 total=rs2.getInt(1);

37             }

38             pageModel=new PageModel();

39             pageModel.setPageNo(pageNo);

40             pageModel.setPageSize(pageSize);

41             pageModel.setTotalRecords(total);

42             pageModel.setList(list);

43         } catch (SQLException e) {

44             e.printStackTrace();

45         }finally{

46             DbUtil.close(conn);

47             DbUtil.close(pstm);

48             DbUtil.close(rs);

49         }

50         return pageModel;

51     }

52

53     public static void main(String[] args) {

54         PageModel pageModel=Client.findAdmins(2,4);

55         List<Admin> list=pageModel.getList();

56         for(Admin a:list){

57             System.out.print("ID:"+a.getId()+",用户名:"+a.getName()+",密码:"+a.getPassword());

58             System.out.println();

59         }

60         System.out.print("当前页:"+pageModel.getPageNo()+" ");

61         System.out.print("共"+pageModel.getTotalPages()+"页 ");

62         System.out.print("首页:"+pageModel.getTopPageNo()+" ");

63         System.out.print("上一页:"+pageModel.getPreviousPageNo()+" ");

64         System.out.print("下一页:"+pageModel.getNextPageNo()+" ");

65         System.out.print("尾页:"+pageModel.getBottomPageNo()+" ");

66         System.out.print("共"+pageModel.getTotalRecords()+"条记录");

67         System.out.println();

68     }

69

70 }
这样分页效果就实现了，我们要实现分页效果，只要传入相应的参数和相应的数据库执行语句即可实现，希望大家能灵活运用。

分享到：