pageHelper进行分页查询时没有起作用，查询出来了全部的数据；
springboot使用pagehelper分页，没有起作用，查询出来了全的数据，最后发现是pom.xml中的jar没有引全
我刚开始使用的是
<!-- https
://mvnrepository
.com
/artifact
/com
.github
.pagehelper
/pagehelper
-->
<dependency>
<groupId>com
.github
.pagehelper
</groupId
>
<artifactId>pagehelper
</artifactId
>
<version>5.1.11</version
>
</dependency
>
后来添加了一个
<!-- 分页插件 https
://mvnrepository
.com
/artifact
/com
.github
.pagehelper
/pagehelper
-spring
-boot
-starter
-->
<dependency>
<groupId>com
.github
.pagehelper
</groupId
>
<artifactId>pagehelper
-spring
-boot
-starter
</artifactId
>
<version>1.2.12</version
>
</dependency
>
java代码如下
public PageInfo
<UserEntity> findByList() {
PageHelper
.startPage(1,3);
Page
<UserEntity> page
= userMapper
.findByList();
PageInfo
<UserEntity> info
= new PageInfo<>(page
);
return info
;
}
运行后的结果
{
"total": 12,
"list": [
{
"id": 1,
"username": "123",
"password": "1234567",
"nick": "7777",
"createDate": "2020-07-15 17:29:45",
"createName": "444",
"updateDate": "2020-07-28 17:29:50",
"updateName": "25252"
},
{
"id": 2,
"username": "zhangsan",
"password": "1234567",
"nick": "7777",
"createDate": "2020-07-15 17:29:45",
"createName": "444",
"updateDate": "2020-07-28 17:29:50",
"updateName": "25252"
},
{
"id": 3,
"username": "李四",
"password": "1234567",
"nick": "7777",
"createDate": "2020-07-15 17:29:45",
"createName": "444",
"updateDate": "2020-07-28 17:29:50",
"updateName": "25252"
}
],
"pageNum": 1,
"pageSize": 3,
"size": 3,
"startRow": 1,
"endRow": 3,
"pages": 4,
"prePage": 0,
"nextPage": 2,
"isFirstPage": true,
"isLastPage": false,
"hasPreviousPage": false,
"hasNextPage": true,
"navigatePages": 8,
"navigatepageNums": [
1,
2,
3,
4
],
"navigateFirstPage": 1,
"navigateLastPage": 4
}
个人学习中遇到的坑记录下来了，如果有不足或者错误请指正
