分页配置
MyBatis Plus要想使用分页,需要添加如下配置:
@Configuration
@ConditionalOnClass(value = {PaginationInterceptor.class})
public class MybatisPlusConfig {
/**
* 分页插件
* @return
*/
@Bean
public PaginationInterceptor paginationInterceptor() {
PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
return paginationInterceptor; //返回分布拦截器
}
}
指定排序规则:
方法一
public PageBean listPage(int pageNum, int pageSize) {
IPage page = new Page<>(pageNum,pageSize);
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.eq("state",1)
.orderByDesc("level");
IPage categoryIPage = categoryMapper.selectPage(page, queryWrapper);
return PageBean.init(categ