springboot 配置mybatis报错[Request processing failed; nested exception is org.apache.ibatis.binding.Bind

一般情况下报下面这种错的几种原因

[Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):

1.对于maven项目pom.xml文件中没有把sql配置文件作为资源文件引入，导致找不到sql，解决办法，在pom.xml文件的build节点下添加如下配置

<resources>
    <resource>
        <directory>${basedir}/src/main/resources</directory>
        <includes>
            <include>**/*.yml</include>
        </includes>
    </resource>
     <resource> 
        <directory>${basedir}/src/main/resources</directory> 
         <includes> 
            <include>**/*.properties</include> 
         </includes> 
    </resource>
    <resource>
        <directory>${basedir}/src/main/resources</directory>
        <includes>
            <include>**/*.xml</include>
        </includes>
    </resource>
    <resource>
        <directory>${basedir}/src/main/java</directory>
        <includes>
            <include>**/*.xml</include>
        </includes>
    </resource>
</resources>

以上的 resources节点是build的直接子节点，位置不要错了

 

2.sql mapper.xml中配置的sql语句 id与接口 mapper中的方法名不一样，特别是大小写错误，单词拼写错误等，要保证一个sql在xml中配置的id属性与接口文件中的一个方法名是相同的，这样才能匹配找到。