Mybatis-Plus,在spring boot中的分页实现

1.需要一个配置类,官网可以找到

package com.demo2.demo.config;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@Configuration
@MapperScan("com.demo2.demo.demo1.*.mapper*")
public class MybatisPlusConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 设置请求的页面大于最大页后操作， true调回到首页，false 继续请求  默认false
        // paginationInterceptor.setOverflow(false);
        // 设置最大单页限制数量，默认 500 条，-1 不受限制
        // paginationInterceptor.setLimit(500);
        // 开启 count 的 join 优化,只针对部分 left join
        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
        return paginationInterceptor;
    }
}

2.在测试类中写如下代码

package com.demo2.demo;


import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.demo2.demo.demo1.entity.CustomTable;
import com.demo2.demo.demo1.mapper.CustomTableMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class DemoApplicationTests {
    @Autowired
    private CustomTableMapper customTableMapper;

    @Test
    void contextLoads() {
        IPage<CustomTable> customTableIPage=new Page<>(2,3);
        customTableIPage=customTableMapper.selectPage(customTableIPage,null);
        List<CustomTable> customTableList=customTableIPage.getRecords();
        for(CustomTable customTable:customTableList){
            System.out.println(customTable);
        }
    }

}

其中new Page<>(2,3)中的2为当前页数，3为每页的size
注意他这个页数是从1开始的，不是0