org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)

背景信息：

谷粒商城项目中自建mapper方法，手写sql语句时报错

运行时报错：

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.atguigu.gulimall.product.dao.AttrAttrgroupRelationDao.deleteRelations
    at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.2.jar:3.5.2]
    at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:49) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedMapperMethod$0(MybatisMapperProxy.java:65) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
    at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) ~[na:1.8.0_341]
    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedMapperMethod(MybatisMapperProxy.java:65) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:60) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
    at com.sun.proxy.$Proxy81.deleteRelations(Unknown Source) ~[na:na]
    at com.atguigu.gulimall.product.service.impl.AttrServiceImpl.deleteRelation(AttrServiceImpl.java:320) ~[classes/:na]
    at com.atguigu.gulimall.product.service.impl.AttrServiceImpl$$FastClassBySpringCGLIB$$b5438598.invoke(<generated>) ~[classes/:na]
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) ~[spring-aop-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at com.atguigu.gulimall.product.service.impl.AttrServiceImpl$$EnhancerBySpringCGLIB$$248fa62d.deleteRelation(<generated>) ~[classes/:na]
    at com.atguigu.gulimall.product.controller.AttrGroupController.deleteRelation(AttrGroupController.java:73) ~[classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_341]
 

报错原因：

mybatisp的application.properties信息配置信息错误

路径信息：resource包下

mapper/product/AttrAttrgroupRelationDao.xml

原本配置

mybatis-plus:
  mapper-locations: classpath*:mapper/*.xml,classpath*:mapper/**/*Mapper.xml

正确配置信息

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

总结

• mybatisplus不够熟练

• mapper-locations: classpath的配置要看具体项目