1.pom.xml添加pageHelper启动器
<!--pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
<exclusions>
<exclusion>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
</exclusion>
</exclusions>
</dependency>
2/、在application.yml中添加pageHelper配置
service层:
public List<Item> findItemByPage(int pageNum,int pageSize);
serviceImpl:(注意不能调换方法顺序!)
@Override
public List<Item> findItemByPage(int pageNum, int pageSize) {
//分页拦截;设置分页参数
PageHelper.startPage(pageNum, pageSize);
//重构后的sql语句 select * from xxx limit m,n
List<Item> list = itemMapper.selectByExample(null);
return list;
}
测试:(因为springboot已经封装了一个分页bean,所以直接调用即可)
@Test
public void testPage() {
List<Item> list = itemService.findItemByPage(2, 4);
//计算总记录,上一页,下一些,总页数
PageInfo page = new PageInfo<>(list);
System.out.println("总记录数"+page.getTotal());
System.out.println("总页数"+page.getPages());
System.out.println("上一页"+page.getPrePage());
System.out.println("下一页"+page.getNextPage());
System.out.println("当前页"+page.getPageNum());
}