java简单分页工具类

 1 import java.util.List;
 2 
 3 /**
 4  *  分页工具
 5  * @author Administrator
 6  *
 7  */
 8 public class PageBean<T> {
 9 
10     private int pageNo = 1;  //当前页
11     private int pageSize = 4; //每页个数
12     private int totalCount;  //总记录数
13     private int totalPages;  //总页数--只读
14     private List<T> pageList;  //每页对应的集合泛型
15     public int getPageNo() {
16         return pageNo;
17     }
18     //当前页码不能小于1不能大于总页数
19     public void setPageNo(int pageNo) { 20 if(pageNo<1) 21 this.pageNo = 1; 22 else if(pageNo > totalPages) 23 this.pageNo = totalPages; 24 else 25 this.pageNo = pageNo; 26  } 27 public int getPageSize() { 28 return pageSize; 29  } 30 public void setPageSize(int pageSize) { 31 this.pageSize = pageSize; 32  } 33 //总记录数决定总页数 34 public void setTotalCount(int totalCount) { 35 this.totalCount = totalCount; 36 this.totalPages = (this.totalCount%this.pageSize==0)?this.totalCount/this.pageSize:this.totalCount/this.pageSize+1; 37  } 38 public int getTotalCount() { 39 return totalCount; 40  } 41 42 //只读 43 public int getTotalPages() { 44 return totalPages; 45  } 46 47 48 public List<T> getPageList() { 49 return pageList; 50  } 51 public void setPageList(List<T> pageList) { 52 this.pageList = pageList; 53  } 54 public PageBean(int pageNo, int pageSize, int totalCount, int totalPages, 55 List<T> pageList) { 56 super(); 57 this.pageNo = pageNo; 58 this.pageSize = pageSize; 59 this.totalCount = totalCount; 60 this.totalPages = totalPages; 61 this.pageList = pageList; 62  } 63 public PageBean() { 64 super(); 65 // TODO Auto-generated constructor stub 66  } 67 68 }

mysql分页：select * from 表 limit (pageNo-1)*pageSize,pageSize; 

oracle分页：select a.* (select 表.*,rowum rn from 表) a where rn>(pageNo-1)*pageSize and rn <=pageNo*pageSize;

这是一个最简单分页工具类，顺便附上mysql以及oracle分页语句，大佬勿喷，仅供参考。

转载于:https://www.cnblogs.com/sy-zl/p/6865787.html