一、mybatis中使用PageHelper进行分页
导包pagehelper
com.github.pagehelper
pagehelper
3.7.5
配置分页
application.properties
#配置分页
pagehelper.helper-dialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=countSql
测试
(1)开启分页
(2)进行查询,得到list
(3)封装list到 PageInfo对象中自动分页
@RequestMapping("/getUser2")
public PageInfo getUser2(@RequestParam(defaultValue = "1") Integer currentPage, @RequestParam(defaultValue = "3") Integer pageSize){
//1、开启分页
PageHelper.startPage(currentPage,pageSize);
List userList = userMapper.findAll();
//2、封装list到 PageInfo对象中自动分页
PageInfo userPageInfo = new PageInfo<>(userList);
return userPageInfo;
}
二、P