SpringBoot如何使用MyBatis Plus进行物理分页查询呢?

编写mybatis plus config类
       编写一个PaginationInterceptor bean
       即可完成mybatis plus物理分页操作

 
增加一个配置类

MybatisPlusConfig.java

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();
        page.setDialectType("mysql");
        return page;
    }

}

3.4以上版本会报方法过时 用这个

 /**
     *   mybatis-plus分页插件
     */
    @Bean
    public MybatisPlusInterceptor paginationInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();

        PaginationInnerInterceptor page=new PaginationInnerInterceptor();
        page.setDbType(DbType.MYSQL);

        interceptor.addInnerInterceptor(page);
        return interceptor;
    }