之前把表A的值要赋给表B做了个方法封装,封装后做分页查询的时候发现就查了10条,如果吧每页条数设置为20就查出20条,总条数也是20
出现这种问题一般是使用自己封装的方法吧传入的pageinfo做了转换/赋值破坏了原来的属性导致到 pageInfo 的 if 里判断当前 page 为 Collection
源码如下
public PageInfo(List<T> list, int navigatePages) {
if (list instanceof Page) {
Page page = (Page) list;
this.pageNum = page.getPageNum();
this.pageSize = page.getPageSize();
this.orderBy = page.getOrderBy();
this.pages = page.getPages();
this.list = page;
this.size = page.size();
this.total = page.getTotal();
if (this.size == 0) {
this.startRow = 0;
this.endRow = 0;
} else {
this.startRow = page.getStartRow() + 1;
this.endRow = this.startRow - 1 + this.size;
}
} else if (list instanceof Collection) {//出现这个问题是走了这段if
this.pageNum = 1;
this.pageSize = list.size();
this.pages = 1;
this.list = list;
this.size = list.size();
this.total = list.size();//这里会导致总条数和每页显示条数一样所以查询的时候会出问题
this.startRow = 0;
this.endRow = list.size() > 0 ? list.size() - 1 : 0;
}
if (list instanceof Collection) {
this.navigatePages = navigatePages;
calcNavigatepageNums();
calcPage();
judgePageBoudary();
}
}
把封装方法放在查询结果后使用完美解决问题!