1、加载依赖包
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.12</version>
</dependency>
2、application.yml文件配置
pagehelper:
helper-dialect: oracle
offset-as-page-num: true
row-bounds-with-count: true
reasonable: false
3、使用实例
@Override
public PageInfo getAllHotelAnnounce(String announceType, int pageNum, int pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<Map<String, Object>> announceLists = new ArrayList<>();
if ("agreementHotel".equals(announceType)) {
announceLists = announceMapper.getAllHotelAnnounce();
}
return new PageInfo<>(announceLists);
}