分页代码

1、TableDataInfo.getDataTable(list)
2、private void startPage1(String exportFlag) {
PageDomain pageDomain = TableSupport.buildPageRequest();
Integer pageNum = pageDomain.getPageNo() != null?pageDomain.getPageNo():pageDomain.getPageNum();
Integer pageSize = pageDomain.getPageSize();
String orderBy = SqlUtil.escapeOrderBySql(pageDomain.getOrderBy());
if (StrUtil.isEmpty(orderBy)) {
orderBy = "a.id asc";
} else {
/if (orderBy.contains("dept_name")) {
orderBy = orderBy.replaceAll("dept_name","CONVERT ( dept_name USING GBK )");
}/
orderBy += ", a.id asc";
}
Boolean reasonable = pageDomain.getReasonable();
if ("1".equals(exportFlag)) {//不分页导出
PageHelper.orderBy(orderBy);
} else {
PageHelper.startPage(pageNum, pageSize, orderBy).setReasonable(reasonable);
}
}

PageHelper.startPage(pageReqVO.getPageNo(),pageReqVO.getPageSize());
Page pageResult = (Page) indexPoolMapper.selectPage(pageReqVO, deptIds);

PageResult result = new PageResult<>();
result.setList(pageResult);
result.setTotal(pageResult.getTotal());