效果:
sql语句:select * from tablename limit m,n (从第m+1条数据开始,显示n条数据)
所以实现分页的sql语句可表示为:select * from tablename limit 每页显示条数*(当前页-1),每页显示的条数
MySQL数据表中的数据(部分):
实体类:
public class Person {
private Integer id;
private String name;
private String gender;
private Integer age;
private String province;
//省略其他
}
分页的类:
public class SplitPage<T> {
private int currentPage = 1;// 当前页
private int size = 10;// 每页显示多少数据
private int totalPage;// 总共多少页
private int dataCount;// 总共多少数据
private List<T> datas;// 当前页的数据
public int getCurrentPage() {
return currentPage;}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;}
public int getSize() {
return size;}
public void setSize(int size) {
this.size = size;}
public int getTotalPage() {
return totalPage;}
private void setTotalPage(int dataCount) {
int div = dataCount / this.size;
this.totalPage = dataCount % this.size == 0 ? div : div + 1;
}
public int getDataCount() {
return dataCount;}
public void setDataCount(int dataCount) {
this.dataCount = dataCount;
setTota