第一步 集成mybatis,上个文章的
第二步 pom添加
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.3</version>
</dependency>
第三步 Application注入
@Bean
PageHelper pageHelper(){
//分页插件
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("reasonable", "true");
properties.setProperty("supportMethodsArguments", "true");
properties.setProperty("returnPageInfo", "check");
properties.setProperty("params", "count=countSql");
pageHelper.setProperties(properties);
//添加插件
new SqlSessionFactoryBean().setPlugins(new Interceptor[]{pageHelper});
return pageHelper;
}
第四步 Controller里写一个查询 mybatis相关就不写了 查询就一个select * from 也是跟上一篇
@Autowired
private UserService userService;
//自己的mybatis 我的叫userService
@GetMapping(value = "getPage")
public List<User> GetPage(@RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum) {
PageHelper.startPage(pageNum, 单页显示数量);
//mapping接口自己定义的我的直接叫查询所有selectAll
List<User> users = userService.selectAll();
PageInfo<User> pageInfo = new PageInfo<User>(users);
return pageInfo.getList();
}
第五步 跑起来
分页成功