springboot整合pageheler以及pageheler遇到的坑
一、springboot整合pageheler
1.pom.xml中引入依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.7</version>
</dependency>
2.application.yml文件中进行配置
pagehelper:
helper-dialect: mysql
reasonable: true
support-methods-arguments: true
params: count=countSql
3.直接在查询方法的前面调用startPage()方法即可
public PageInfo<OrderDto> findList(Integer pageNum, Integer pageSize) {
PageHelper.startPage(pageNum, pageSize);
Page<OrderMaster> orderMasterPage = orderMasterMapper.findAll();
PageInfo<OrderMaster> OrderMasterPageInfo = new PageInfo<>(orderMasterPage);
return OrderMasterPageInfo2OrderDtoPageInfo