springboot 中 Invalid bound statement (not found):错误

最新推荐文章于 2025-11-14 15:07:53 发布

原创最新推荐文章于 2025-11-14 15:07:53 发布 · 1w 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

# Invalid bound statement

springboot 专栏收录该内容

8 篇文章

订阅专栏

本文解析了在使用MyBatis框架时遇到的binding exception错误，详细检查了EmployeeMapper接口和XML映射文件中方法ID的一致性问题，并提供了正确的配置示例。

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.zpjeck.mapper.EmployeeMapper.insertEmp
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:49) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58) ~[mybatis-3.4.6.jar:3.4.6]
	at com.sun.proxy.$Proxy61.insertEmp(Unknown Source) ~[na:na]
	at com.zpjeck.contraller.EmpContraller.insertEmp(EmpContraller.java:31) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.__invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:45009) ~[na:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:45012) ~[na:1.8.0_121]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) ~[spring-web-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) ~[spring-web-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.1.2.RELEASE.jar:5.1.2.RELEASE]

遇到这种错误，首先先排查一下错误，EmployeeMapper.java文件中的方法是不是与EmployeeMapper.xml 的操作数据的语句中的id保持一致？？

//EmployeeMapper.java文件

package com.zpjeck.mapper;
import com.zpjeck.bean.Employee;
public interface EmployeeMapper {
    public Employee selectById(Integer id);
    public int insertEmp(Employee employee);

}

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.zpjeck.mapper.EmployeeMapper">
    <select id="selectById" resultType="com.zpjeck.bean.Employee">
        select * from employee where id=#{id}
    </select>

    <insert id="insertEmp">
        insert into employee(lastName,email,gender,d_id) values (#{lastName},#{email},#{gender},#{d_id})
    </insert>

</mapper>

第二个容易出错的地方：

写对正确的配置，就能运行。