分页不生效的原因都是拦截器的问题

添加拦截器有两种情况

1. 在配置类上加拦截器

@Configurationpublic class MyBatisPlusConfig {        @Bean    public MybatisPlusInterceptor mybatisPlusInterceptor() {        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();        // 向Mybatis过滤器链中添加分页拦截器        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));        return interceptor;    }}

2.当你设置了数据源需要在数据源上添加拦截器

@Bean    public SqlSessionFactory sqlSessionFactoryBean(DataSourceProxy dataSourceProxy) throws Exception {        //修改为MybatisSqlSessionFactoryBean        MybatisSqlSessionFactoryBean sqlSessionFactoryBean = new MybatisSqlSessionFactoryBean();        //插件类        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));                sqlSessionFactoryBean.setDataSource(dataSourceProxy);        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));        sqlSessionFactoryBean.setTransactionFactory(new SpringManagedTransactionFactory());        sqlSessionFactoryBean.setGlobalConfig(globalConfig);        //添加插件        sqlSessionFactoryBean.setPlugins(mybatisPlusInterceptor);        return sqlSessionFactoryBean.getObject();    }

来源地址：https://blog.csdn.net/weixin_51146698/article/details/129261467