Java-MP-分页查询

基础实现

 @Test
    public void test1(){
        //分页查询，是对数据库进行查询，用实体类,得出结果后在封装为VO对象
        Page<LearningLesson> page = new Page<>(1,2);//第一页 2条数据  page接收返回结果
        LambdaQueryWrapper<LearningLesson> wrapper = new LambdaQueryWrapper<>();//查询条件
        wrapper.eq(LearningLesson::getUserId,"2");
        wrapper.orderByDesc(LearningLesson::getLatestLearnTime); //根据最近学习时间降序排序
        learningLessonService.page(page,wrapper);
        System.out.println("total: "+page.getTotal());
        System.out.println("pages: "+page.getPages());
        List<LearningLesson> records = page.getRecords();//当前结果集
        for (LearningLesson record : records) {
            System.out.println(record);
        }
    }

进阶实现

@Test
    public void test2(){
        //分页查询，是对数据库进行查询，用实体类,得出结果后在封装为VO对象
        Page<LearningLesson> page = new Page<>(1,2);//第一页 2条数据  page接收返回结果
        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");
//        wrapper.orderByDesc(LearningLesson::getLatestLearnTime); //根据最近学习时间降序排序
        learningLessonService.page(page,wrapper);
        System.out.println("total: "+page.getTotal());
        System.out.println("pages: "+page.getPages());
        List<LearningLesson> records = page.getRecords();//当前结果集
        for (LearningLesson record : records) {
            System.out.println(record);
        }
    }

高级实现

   @Test
    public void test3(){
        //分页查询，是对数据库进行查询，用实体类,得出结果后在封装为VO对象
        Page<LearningLesson> page = new Page<>(1,2);//第一页 2条数据  page接收返回结果
        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");
//        wrapper.orderByDesc(LearningLesson::getLatestLearnTime); //根据最近学习时间降序排序
//        learningLessonService.page(page,wrapper);

        learningLessonService.lambdaQuery().eq(LearningLesson::getUserId,"2").page(page);
        System.out.println("total: "+page.getTotal());
        System.out.println("pages: "+page.getPages());
        List<LearningLesson> records = page.getRecords();//当前结果集
        for (LearningLesson record : records) {
            System.out.println(record);
        }
    }