解决：Invalid bound statement (not found): com.XXX

2023-05-17 18:15:58.364 ERROR 9476 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.xxx.xxx.mapper.FixMapper.findFixByRoomNumber] with root cause

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.xxx.xxx

报错可能原因:

1、resources下mapper文件夹里面的XXXMapper.xml文件的命名空间没有和src/main/java下的XXXMapper.java对应起来

解决：将XXXMapper.java的类全名复制到namespace

namespace="com.xxx.xxx.courseMapper"

2、XXXMapper.xml执行的sql语句中的id没有和XXXMapper.java的方法名对应

解决：将XXXMapper.java的方法名复制到sql语句的id中

<select id="findRoom" resultType="com.example.entity.Fix"> SELECT * FROM fix </select>

3、XXXMapper.xml执行的sql语句中的返回值类型resultType没有和实体类的类全名对应

解决：将调用的实体类的类全名复制到resultType

<select id="findRoom" resultType="com.example.entity.Fix"> SELECT * FROM fix </select>