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. 使用分頁插件，在查詢前使用分頁插件，原理：統(tǒng)一攔截sql，為其提供分頁功能

PageHelper.startPage(pageNum,pageSIze);

4. 分頁數(shù)據(jù)封張到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;           // 當(dāng)前頁數(shù)
    private int total;          // 總頁數(shù)  
    private long records;       // 總記錄數(shù)
    private List<?> rows;       // 每行顯示的內(nèi)容

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