Error creating bean with name ‘caiGouDinDanController’: Unsatisfied dependency expressed through fie

疯狂报错：
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