MySQL分页(select * from student limit 页数*页面大小,页面大小)
分页实现5个(属性):
(1) 数据总数: 查数据库,select count(*)..
(2) 页面大小(每页显示的数据条数):用户自定义
(3) 总页数:程序自动计算。
总页数 = 数据总数%页面大小==0? 数据总数/页面大小:数据总数/页面大小+1;
(4) 当前页(页码):用户自定义
(5) 当前页的对象集合(实体类集合):每页所显示的所有数据,查数据库,分页sql
PageBean
package entity;
import java.util.List;
public class PageBean<T>{
private int totalCount; //总记录数
private int totalPage; //总页码
private int currentPage; //当前页面
private int rows; //每页展示d额条数
private List<T> list; //每页显示数据的list集合
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
this.totalCount = totalCount;
}
public int getTotalPage() {
return totalPage;
}
public void setTotalPage(int totalPage) {
this.totalPage = totalPage;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public int getRows() {
return rows;
}
public void setRows(int rows) {
this.rows = rows;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
@Override
public String toString() {
return "PageBean{" +
"totalCount=" + totalCount +
", totalPage=" + totalPage +
", currentPage=" + currentPage +
", rows=" + rows +
", list=" + list +
'}';
}
}