Invalid bound statement (not found) 原因和解决方法

以你之姓@ 2023-09-23 21:18 233阅读 0赞

## 一.复现 ##

在我springboot项目，启动的时候，报了**Invalid bound statement (not found) ：绑定语句无效（未找到）**

## 二.原因 ##

**mapper接口和mapper.xml文件没有映射起来**

## 三.解决 ##

### 1.查看mapper.xml中的namespace和接口mapper文件一致吗 ###

![在这里插入图片描述][bc45d6aaa8f54d47af43f80e82ff0c32.png]

### 2.看一下 target 里面有没有编译的mapper.xml文件 ###

![在这里插入图片描述][f07158a62f034bbf9d7b8055c50134de.png]

**没有的话，打开maven点击clean一下，重新运行就ok了。**  
![在这里插入图片描述][f4105a09afa14cfdba6b5f0304142fff.png]

### 3.检查pom.xml文件中是否配置resource，不然mapper.xml文件不会被编译到 target。 ###

<resources>
             <resource>
                 <directory>src/main/java</directory>
                 <includes>
                     <include>**/*.properties</include>
                     <include>**/*.xml</include>
                 </includes>
                 <filtering>false</filtering>
             </resource>
             <resource>
                 <directory>src/main/resources</directory>
                 <includes>
                     <include>**/*.properties</include>
                     <include>**/*.xml</include>
                 </includes>
                 <filtering>false</filtering>
             </resource>
         </resources>

[bc45d6aaa8f54d47af43f80e82ff0c32.png]: https://img-blog.csdnimg.cn/bc45d6aaa8f54d47af43f80e82ff0c32.png
[f07158a62f034bbf9d7b8055c50134de.png]: https://img-blog.csdnimg.cn/f07158a62f034bbf9d7b8055c50134de.png
[f4105a09afa14cfdba6b5f0304142fff.png]: https://img-blog.csdnimg.cn/f4105a09afa14cfdba6b5f0304142fff.png