mybatis plus 3.4以上分页无效问题,limit一直加不上,MybatisPlusInterceptor无效

发布时间 2023-08-29 14:31:06作者: 韦邦杠

解决方案

1、已注册

 @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
        paginationInnerInterceptor.setOverflow(true); //合理化
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }

2、原因是MybatisSqlSessionFactoryBean没有添加插件

 

    @Bean
    public MybatisSqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource,MybatisPlusInterceptor mybatisPlusInterceptor) throws IOException {
        MybatisSqlSessionFactoryBean factoryBean = new MybatisSqlSessionFactoryBean();
        factoryBean.setDataSource(dataSource);
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        Resource[] resources = resolver.getResources("classpath:mapper/*.xml");
        factoryBean.setMapperLocations(resources);
        /*在加载MybatisSqlSessionFactoryBean时,把相应的插件加载进去*/
        factoryBean.setPlugins(mybatisPlusInterceptor);
        return factoryBean;
    }