原理:通过拦截器的模式,自动添加limt代码
引用依赖
<!-- pagehelper 分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.12</version>
</dependency>
执行分页前代码调用:传页大小、第几页、排序字段
PageHelper.startPage(pageNum, pageSize, orderBy).setReasonable(reasonable);
查询代码调用正常写查询sql:
SELECT post_id, post_code, post_name, post_ename, post_sort, status, create_by, create_time, remark FROM sys_post
最后调用PageInfo获取页大小,分页就完成了
new PageInfo(list).getTotal()
调用例子如下:
public HttpResult getPostList(SysPost post){
this.startPage();
List<SysPost> list = postService.selectPostList(post);
TableDataInfo dataInfo = this.getDataTable(list);
return HttpResult.ok(dataInfo.getRows(),dataInfo.getTotal());
}