疯狂报错:
Error creating bean with name ‘caiGouDinDanController’: Unsatisfied dependency expressed through field ‘iSysCaiGouDinDanService’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘sysCaiGouDinDanServiceImpl’: Unsatisfied dependency expressed through field ‘sysCaiGouDinDanMapper’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘sysCaiGouDinDanMapper’ defined in file [D:\JAVA\wms-warehouse-management\ruoyi-system\target\classes\com\ruoyi\system\mapper\SysCaiGouDinDanMapper.class]: Unsatisfied dependency expressed through bean property ‘sqlSessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘sqlSessionFactory’ defined in class path resource [com/ruoyi/framework/config/MyBatisConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method ‘sqlSessionFactory’ threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: ‘file [D:\JAVA\wms-warehouse-management\ruoyi-system\target\classes\mapper\ruku\RukuCaigougoodsMapper.xml]’; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is ‘file [D:\JAVA\wms-warehouse-management\ruoyi-system\target\classes\mapper\ruku\RukuCaigougoodsMapper.xml]’. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.ruoyi.system.mapper.RukuCaigougoodsMapper.add. please check file [D:\JAVA\wms-warehouse-management\ruoyi-system\target\classes\mapper\ruku\RukuCaigougoodsMapper.xml] and file [D:\JAVA\wms-warehouse-management\ruoyi-system\target\classes\mapper\ruku\RukuCaigougoodsMapper.xml]
按理说这就是简单的忘记加注解的问题,但经过两小时的排查依旧没找出毛病,最后发现竟然是Mapper.xml文件里的sql语句有问题,写了个【下面图片】这玩意,首先是两个sql的id写重复了,其次上面的sql里面没有语句,真是个憨憨。。。。
解决:删掉多余的sql