mybatis plus 出现 Invalid bound statement (not found)

太过爱你忘了你带给我的痛 2023-01-01 04:48 102阅读 0赞

mybatis-plus 3.5.6  按照官网的配置出现了如下错误

> org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.niu.manager.mapper.DepartmentMapper.selectList  
>     at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~\[mybatis-3.5.6.jar:3.5.6\]  
>     at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53) ~\[mybatis-3.5.6.jar:3.5.6\]  
>     at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:115) ~\[mybatis-3.5.6.jar:3.5.6\]  
>     at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) ~\[na:1.8.0\_211\]

## 解决 ##

*  检查配置

@MapperScan(basePackages = "com.xxx.mapper")

与

mybatis.mapper-locations: classpath:mapper/\*.xml

的配置路径是否正确

*  一个坑：使用mybatis-plus时不能使用自带的SqlSessionFactory，要使用MybatisSqlSessionFactory，在配置类中加入如下配置（springboot）

@Primary
        @Bean("db1SqlSessionFactory")
        public SqlSessionFactory db1SqlSessionFactory(DataSource dataSource) throws Exception {
            /**
             * 使用 mybatis plus 配置
             */
            MybatisSqlSessionFactoryBean b1 = new MybatisSqlSessionFactoryBean();
            System.out.println("dataSourceLyz"+dataSource.toString());
            b1.setDataSource(dataSource);
            b1.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*.xml"));
            return b1.getObject();
        }