MyBatisPlus分页插件,避免逻辑分页,实现物理分页.

paginationInterceptor类本质就是Mybatis的拦截器,不配置会导致Mybatis的分页插件不能的正常使用.

package com.test.boot.demo.config;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class MybatisPlusConfig {

    // MyBatis Plus 分页插件  实现物理分页 避免逻辑分页  提高分页效率
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor page = new PaginationInterceptor();
        return page;
    }

}

    @Override
    public List<ExaminationQuestions> getList() {
        // 分页对象
        IPage<ExaminationQuestions> page = new Page<>(0,13);
        // 条件包装器
        QueryWrapper<ExaminationQuestions> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("title_name", "智慧");
        // 分页查询
        IPage<ExaminationQuestions> examinationQuestionsIPage = examinationQuestionsMapper.selectPage(page, queryWrapper);
        System.out.println(examinationQuestionsIPage);
        System.out.println("记录:" + examinationQuestionsIPage.getRecords());
        System.out.println("总数" + examinationQuestionsIPage.getTotal());
        return examinationQuestionsIPage.getRecords();
    }