分页查询基本方式
@SpringBootTest(classes = LearningApplication.class)
public class MPTest {@AutowiredILearningLessonService lessonService;@Testpublic void test(){Page<LearningLesson> page = new Page<>(1, 2);LambdaQueryWrapper<LearningLesson> wrapper = new LambdaQueryWrapper<>();wrapper.eq(LearningLesson::getUserId, 2);lessonService.page(page, wrapper);}
按照某一字段升序或者降序排序
@Testpublic void test1(){Page<LearningLesson> page = new Page<>(1, 2);List<OrderItem> itemList = new ArrayList<>();OrderItem item = new OrderItem();item.setColumn("latest_learn_time");item.setAsc(false);itemList.add(item);page.addOrder(itemList);LambdaQueryWrapper<LearningLesson> wrapper = new LambdaQueryWrapper<>();wrapper.eq(LearningLesson::getUserId, 2);lessonService.page(page, wrapper);}
简化写法
@Testpublic void test2(){Page<LearningLesson> page = new Page<>(1, 2);List<OrderItem> itemList = new ArrayList<>();OrderItem item = new OrderItem();item.setColumn("latest_learn_time");item.setAsc(false);itemList.add(item);page.addOrder(itemList);lessonService.lambdaQuery().eq(LearningLesson::getUserId,2).page(page);}