<dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.3</version>
</dependency>

<select id="selectForPage" resultMap="BaseResultMap">
    select * from tb_user
    <where>
        1 = 1
    </where>
    limit #{offset}, #{pageSize}
</select>

mybatis-plus:
  configuration:
    # 分頁(yè)插件，一般不用修改
    page-params: pageNum=1;pageSize=10;count=countSql

public class CustomPaginationInterceptor extends PaginationInterceptor {

    @Override
    public Page SqlParserInterceptor(MappedStatement ms, Page page) {
        // 獲取前端傳入的分頁(yè)參數(shù)
        Integer pageNum = (Integer) page.get("pageNo");
        Integer pageSize = (Integer) page.get("pageSize");
        // 處理分頁(yè)邏輯
        int offset = (pageNum - 1) * pageSize;
        return super.SqlParserInterceptor(ms, new Page(offset, pageSize));
    }
}

// 分頁(yè)查詢(xún)方法
IPage<Test> pageTest = new Page<>(pageNo, pageSize);
// 設(shè)置總記錄數(shù)
pageTest .setRecordsTotal(testMapper.selectCount(null));
// 查詢(xún)
IPage<Test> pageResult = testMapper.selectPage(pageTest , null);

    /** Mybatis plus 分頁(yè)插件 **/
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 設(shè)置請(qǐng)求的頁(yè)面大于最大頁(yè)后操作， true調(diào)回到首頁(yè)，false 繼續(xù)請(qǐng)求  默認(rèn)false
        // paginationInterceptor.setOverflow(false);
        // 設(shè)置最大單頁(yè)限制數(shù)量，默認(rèn) 500 條，-1 不受限制
         paginationInterceptor.setLimit(-1);
        return paginationInterceptor;
    }

package com.cafeteria.reservation.admin.config;

import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class MyBatisConfig {
    @Bean
    public MybatisPlusInterceptor paginationInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
//這是分頁(yè)攔截器
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();

        paginationInnerInterceptor.setOverflow(false);
        paginationInnerInterceptor.setMaxLimit(500L);
        mybatisPlusInterceptor.addInnerInterceptor(paginationInnerInterceptor);
//設(shè)置請(qǐng)求的頁(yè)面大于最大頁(yè)后操作，true調(diào)回到首頁(yè)，false繼續(xù)請(qǐng)求默認(rèn)false
// paginationInterceptor.setOverflow(false);//設(shè)置最大單頁(yè)限制數(shù)量，默認(rèn)500條，-1不受限制
//paginationInterceptor.setLimit(500);
//開(kāi)啟 count 的 join 優(yōu)化,只針對(duì)部分 left join
        return mybatisPlusInterceptor;
    }
}