1.pom.xml文件导com.github.pagehelper两个包
<dependency><!--分页插件1-->
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.4</version>
</dependency>
<dependency><!--分页插件2-->
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
2.controller层
3. serviceImpl层
如果查询结果将作为"下拉列表"展示数据,
一般第5行改为:
params.setPageSize(1000); //如果不分页查,默认查1000个
4.返回给前端json格式(这是拿的别处的分页代码的返回结果)样例
{
"msg": "success",
"code": 0,
"data": {
"total": 6,
"list": [
{
"ruleTypeId": 1,
"brandId": "KFC",
"name": "使用次数描述错误",
"orderIndex": 1,
"createTime": "2021-05-19 14:59:25",
"createUser": "admin",
"lastUpdateTime": "2021-07-05 16:08:49",
"lastUpdateUser": "admin",
"isDel": 0
},
{
"ruleTypeId": 2,
"brandId": "KFC",
"name": "互斥描述错误",
"orderIndex": 2,
"createTime": "2021-05-19 14:59:25",
"createUser": "admin",
"lastUpdateTime": "2021-07-05 16:09:19",
"lastUpdateUser": "admin",
"isDel": 0
},
{
"ruleTypeId": 197,
"brandId": "KFC",
"name": "单人限领配置错误",
"orderIndex": 3,
"createTime": "2021-07-05 16:09:30",
"createUser": "admin",
"lastUpdateTime": null,
"lastUpdateUser": null,
"isDel": 0
},
{
"ruleTypeId": 199,
"brandId": "KFC",
"name": "发放对应效期配置错误",
"orderIndex": 4,
"createTime": "2021-07-05 16:09:44",
"createUser": "admin",
"lastUpdateTime": null,
"lastUpdateUser": null,
"isDel": 0
},
{
"ruleTypeId": 200,
"brandId": "KFC",
"name": "任消描述错误",
"orderIndex": 6,
"createTime": "2021-07-05 16:09:55",
"createUser": "admin",
"lastUpdateTime": null,
"lastUpdateUser": null,
"isDel": 0
},
{
"ruleTypeId": 201,
"brandId": "KFC",
"name": "秒杀场景检查",
"orderIndex": 7,
"createTime": "2021-07-05 16:15:25",
"createUser": "admin",
"lastUpdateTime": null,
"lastUpdateUser": null,
"isDel": 0
}
],
"pageNum": 1,
"pageSize": 10,
"size": 6,
"startRow": 1,
"endRow": 6,
"pages": 1,
"prePage": 0,
"nextPage": 0,
"isFirstPage": true,
"isLastPage": true,
"hasPreviousPage": false,
"hasNextPage": false,
"navigatePages": 8,
"navigatepageNums": [
1
],
"navigateFirstPage": 1,
"navigateLastPage": 1,
"firstPage": 1,
"lastPage": 1
}
}
5.注意: 使用此分页插件mybatis.xml中的sql不能多层嵌套如select * from (select * from ),否则会把外层的select *变为select count(0)。