第一次使用MyBatisPlus,总体挺好用的,不用自己单独去写SQL,虽然很喜欢自己去写。
有个小的需求是需要将结果数据分页并按照id排序倒序排列展示:
- 首先需要先配置MyBatisPlusConfig
@Configuration
public class MyBatisPlusConfig{
@Bean
public MybatisPlusInterceptor paginationInnerInterceptor(){
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor
}
}
- 数据处理类
@Override
public PageData select(PageSetting pageSetting){
QueryWrapper<LoadData> queryWrapper = new QueryWrapper();
queryWrapper.orderByDesc("id");
Page page = new Page(pageSetting.getPageNo(), pageSetting.getPageSize());
Page<LoadData> loadData = LoadDataService.selectPage(page, queryWrapper);
List<UpLoadLog> records = loadData.getRecords();
PageData pageData = new PageData();
pageData.setCount(loadData.getTotal());
pageData.setPageCount((int)loadData.getPages());
pageData.setList(records);
return pageData;
}