关于mybatisplus分页查询失败查出全部的问题

1. 首先检查pom有没有问题

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.2</version>
        </dependency>
        
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!-- 配置拦截器所需依赖 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>3.5.2</version>
        </dependency>

2. 配置拦截器(官方文档)

@Configuration
@MapperScan("scan.your.mapper.package")
public class MybatisPlusConfig {

    /**
     * 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor = false 避免缓存出现问题(该属性会在旧插件移除后一同移除)
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        //这里的H2是你所用的数据库，数据库错误也不生效
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2/*数据库名称*/));
        return interceptor;
    }

    @Bean
    public ConfigurationCustomizer configurationCustomizer() {
    	//可笑，这个setUseDeprecatedExecutor也过时了
        return configuration -> configuration.setUseDeprecatedExecutor(false);
    }
}