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=countSql2,在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 }以上....