添加依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
配置文件中配置pagehelper信息
#pagehelper分页插件配置
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
在controller中执行
@GetMapping(value = "/getall")
@ResponseBody
public Object getUsers(){
PageHelper.startPage(2,2);
List<Student> students = studentMapperService.getall();
return students;
}
执行过程:
==> Preparing: SELECT count(0) FROM student
==> Parameters:
<== Columns: count(0)
<== Row: 15
<== Total: 1
==> Preparing: select * from student order by id LIMIT ?, ?
==> Parameters: 6(Integer), 3(Integer)
---------------------------------
其他springboot相关知识看专栏其他内容