PageHelper分页查询

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
}

以上....