Mybatis Plus自带的LambdaQueryWrapper实现数据排序
orderByDesc() 核心代码
LambdaQueryWrapper<Users> queryWrapper=new LambdaQueryWrapper<>();
queryWrapper.orderByDesc(Users::getId);// 替换为你要逆序排列的数据
需要在config中配置拦截器
@Configuration
public class MPConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor(){
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
return interceptor;
}
}
案例:实现带分页查询的数据逆序排列
public IPage<Users> getPage(int currentPage, int pageSize, Users users) {
IPage page = new Page(currentPage,pageSize);
// 通过LambdaQueryWrapper逆序排列
LambdaQueryWrapper<Users> queryWrapper=new LambdaQueryWrapper<>();
queryWrapper.orderByDesc(Users::getId);
usersDao.selectPage(page,queryWrapper);
return page;
}
数据库内的原始数据
postman中按照ID逆序分页查询出来的数据