PageHelper的使用方式
Step 1 => 添加依赖
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.13</version> <exclusions> <exclusion> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> </exclusion> <exclusion> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> </exclusion> </exclusions> </dependency>
Step 2 => 创建翻页实体类(req)
public class PageReq { private int page=1; private int size=10; public int getPage() { return page; } public void setPage(int page) { this.page = page; } public int getSize() { return size; } public void setSize(int size) { this.size = size; } }
Step 3 => 在需要带翻页功能的实体类上做关系继承
public class CitiaoReq extends PageReq{}
Step 4 => service层代码
Page page = PageHelper.startPage(req.getPage(),req.getSize()); citiaoExample.setOrderByClause("rand()"); //随机排序 List<Citiao> list = citiaoMapper.selectByExample(citiaoExample); LOG.info("总行数:{}", page.getTotal()); LOG.info("总页数:{}", page.getPages());