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
}