yamlcom.github.pagehelper pagehelper-spring-boot-starter 1.2.12
# 分页插件配置 pagehelper: helperDialect: mysql supportMethodsArguments: true使用分页插件,在查询前使用分页插件,原理:统一拦截sql,为其提供分页功能
public PagedGridResult....... PageHelper.startPage(page, pageSize); //脱敏 List分页数据封装到 PagedGridResult.java 传给前端list = itemsMapperCustom.queryItemComments(map); for (ItemCommentVO vo : list) { vo.setNickname(DesensitizationUtil.commonDisplay(vo.getNickname())); } return setterPagedGrid(list, page,pagenum);
public PagedGridResult setterPagedGrid(List> list, Integer page,Integer pagenum) {
PageInfo> pageList = new PageInfo<>(list);
PagedGridResult grid = new PagedGridResult();
grid.setPage(page);
final int size = list.size();
Integer endsize=(page)*pagenum> size ? size :(page)*pagenum;
List> objects = list.subList((page-1) * pagenum, endsize);
grid.setRows(objects);
double ceil = (double) size / (double)pagenum;
grid.setTotal(new Double(Math.ceil(ceil)).intValue());
grid.setRecords(pageList.getTotal());
return grid;
}
PagedGridResult.java
public class PagedGridResult {
private int page; // 当前页数
private int total; // 总页数
private long records; // 总记录数
private List> rows; // 每行显示的内容
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public int getTotal() {
return total;
}
public void setTotal(int total) {
this.total = total;
}
public long getRecords() {
return records;
}
public void setRecords(long records) {
this.records = records;
}
public List> getRows() {
return rows;
}
public void setRows(List> rows) {
this.rows = rows;
}
}
返回参数说明
[“page”](javascript:: 2, 当前页数[“total”](javascript:: 3, 总页数·[“records”](javascript:: 30, 总记录数



