mybatis-pagehelper

1. 引入分页插件

        <!--pagehelper -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.12</version>
        </dependency>

2. 配置yml

# 分页插件配置
pagehelper:
  helperDialect: mysql
  supportMethodsArguments: true

3. 使用分页插件，在查询前使用分页插件，原理：统一拦截sql，为其提供分页功能

PageHelper.startPage(pageNum,pageSIze);

4. 分页数据封张到PagedGridresult.java传给前端

PageInfo<?> pageList = new PageInfo(list);
PagedGridresult grid = new PagedGridResult();
grid.setPage(page);
grid.setRows(list);
grid.setTotal(pageList.getPages());
grid.setRecords(pageList.getTotal());

PagedGridResult类

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;
    }
}