org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.example.mqttmqtt.mapper.EnergyMapper.selectCarId
遇到这个问题,首先做以下检查:
- Mapper.java 和Mapper.xml是否一一对应
- Bean 是否正确对应数据库字段
- package是否填写正确
检查确认无误后运行还是一样的错误。
这时候查看target文件夹,发现没有同步更新xml文件。
解决办法:
pom.xml中设置:
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.*</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
</build>
之前我缺少图中resources标签及其内容,加上后,问题解决。