快捷導(dǎo)航

springBoot使用mybatis-plus插件實現(xiàn)分頁過程

更新時間：2026年04月26日 10:58:37 作者：千反田真的打不過我

本文介紹了MyBatisPlus的集成步驟,包括項目結(jié)構(gòu)調(diào)整、pom.xml依賴添加、MyBatisPlusConfig配置文件創(chuàng)建與配置、具體代碼實現(xiàn)（controller、service、dao、xml）、SQL結(jié)果打印、自定義分頁等環(huán)節(jié),此經(jīng)驗總結(jié)供讀者參考學(xué)習(xí)

一、項目結(jié)構(gòu)

二、pom.xml 依賴添加

（這里我是加在krystal_dao的pom.xml里面，單個項目，直接加在pom.xml，多模塊根據(jù)自己項目情況添加）

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus</artifactId>
    <version>3.0-beta</version>
</dependency>

三、新建MyBatisPlusConfig.java

(這里我用專門一個模塊添加一些功能代碼，里面依賴自己根據(jù)報錯添加進去即可)

package com.dm.krystal.core.config;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @author krystal
 */
@Configuration
/*@MapperScan("com.dm.krystal")*/ /*  KrystalApiApplication在啟動文件上寫了，這里不加*/
public class MyBatisPlusConfig {
    /**
     * mybatis-plus分頁插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        return paginationInterceptor;
    }
}

四、具體代碼實現(xiàn)

1.controller

IPage<ExaminationPaperRelevancePO>  pageData = examinationPaperRelevanceService.getExaminationPaperPageByQueryVO(page,examinationPaperQueryVO);

2.service

IPage<ExaminationPaperRelevancePO> getExaminationPaperPageByQueryVO(Page page, ExaminationPaperQueryVO examinationPaperQueryVO);

3.serviceImp

@Override
public IPage<ExaminationPaperRelevancePO> getExaminationPaperPageByQueryVO(Page page, ExaminationPaperQueryVO examinationPaperQueryVO) {

    return this.baseMapper.getExaminationPaperPageByQueryVO(page,examinationPaperQueryVO);
}

4.dao

IPage<ExaminationPaperRelevancePO> getExaminationPaperPageByQueryVO(Page page, @Param("examinationPaperQueryVO")ExaminationPaperQueryVO examinationPaperQueryVO);

5. .xml

 <select id="getExaminationPaperPageByQueryVO" resultType="com.eebbk.core.pojo.vo.ExaminationPaperCatalogVO">
        select
        a.id,a.paper_id,a.publisher_id,
        a.publisher_name,a.grade_id,a.grade_name,
        a.semester_id,a.semester_name,
        a.subject_id,a.section_id,a.source_type,
        a.province_id,a.province_name,a.city_id,
        a.city_name,a.`order`,a.staged_type as stageTypeId,a.school_type
        from t_examination_paper_relevance  a
    </select>

五、sql 打印

結(jié)果

六、自定義分頁（已有100條數(shù)據(jù)，每次截取十條）

IPage<ExaminationPaperPO> pageData = PageUtil.listToPage(paperList,page.getCurrent(),page.getSize());

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import lombok.extern.slf4j.Slf4j;

import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.atomic.LongAccumulator;

@Slf4j
public class PageUtil {


    public static <T> IPage<T> listToPage(List<T> list, long pageNum, long pageSize){
        IPage<T> iPage = new Page<>(pageNum,pageSize);
        iPage.setTotal(list.size());
        int startIndex = (int)((pageNum - 1) * pageSize);
        if(null == list || list.isEmpty() || startIndex > list.size()){
            iPage.setRecords(new ArrayList<>());
        }
        else {
            int toIndex = (int)(pageNum * pageSize);
            iPage.setRecords(list.subList(startIndex,toIndex > list.size() ? list.size() : toIndex));
        }
        return iPage;
    }
}