PageHeiper分页

1，pom.xml添加依赖

<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.5</version> </dependency>

在application.properties文件中配置相关属性

#pagehelper\u5206\u9875\u63D2\u4EF6\u914D\u7F6E pagehelper.helperDialect=mysql pagehelper.reasonable=true pagehelper.supportMethodsArguments=true pagehelper.params=count=countSql

2，在service层写分页查询

public PageInfo<User> getUser(){ PageHelper.startPage(1,5);//1是页数，5是每页的数量 ArrayList<User>list=userMapper.getUsers();//将查询到的值放进list PageInfo<User> pageInfo=new PageInfo<User>(list);//进行分页 return pageInfo; }

3，在controller层调用分页结果

@RequestMapping("/pageInfo") public PageInfo<User> list(){ return userService.getUser();//调用getUser }

分页结果源码：

{ "endRow":3, "firstPage":1, "hasNextPage":false, "hasPreviousPage":false, "isFirstPage":true, "isLastPage":true, "lastPage":1, "list":[ { "userAge":27, "userId":1, "userName":"张三" }, { "userAge":30, "userId":2, "userName":"李四" }, { "userAge":20, "userId":3, "userName":"王五" } ], "navigateFirstPage":1, "navigateLastPage":1, "navigatePages":8, "navigatepageNums":[1], "nextPage":0, "pageNum":1, "pageSize":5, "pages":1, "prePage":0, "size":3, "startRow":1, "total":3 }

以上....