一、我们在工作很多时候需要使用手动分页,这里写出SQL_CALC_FOUND_ROWS 和 FOUND_ROWS 在工作具体使用场景,做一个参考
(1)定义一个pageInfo
public class PageInfo<T> {
private Collection<T> data;
private int pageSize;
private int totalNum;
private int totalPageNum;
private int currentPage;
public PageInfo() {
}
public PageInfo(int pageSize) {
this.pageSize = pageSize;
this.totalNum = 0;
this.totalPageNum = 0;
this.currentPage = 0;
}
public PageInfo(Collection<T> data, int totalNum) {
this.data = data;
this.totalNum = totalNum;
}
public PageInfo(Collection<T> data, int pageSize, int totalNum, int totalPageNum, int currentPage) {
this.data = data;
this.pageSize = pageSize;
this.totalNum = totalNum;
this.totalPageNum = totalPageNum;
this.currentPage = currentPage;
}
public P