Invalid bound statement (not found)

最新推荐文章于 2024-07-25 16:15:36 发布

_時_

最新推荐文章于 2024-07-25 16:15:36 发布

阅读量1.1w

点赞数 6

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/PurpleGalaxy/article/details/47836177

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

mybatis报如下错误：

org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcherServlet] in context with path [/zc-beauty2] 
threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
 com.zc.beauty.dao.ICaptchaMapper.savePhoneCode] with root cause
 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.zc.beauty.dao.ICaptchaMapper.savePhoneCode

错误之处可能有以下几个：

1、没有加载mapper文件：

<mappers>
        <mapper resource="mappers/CaptchaMapper.xml" />
</mappers>

2、接口路径写错了：

<!-- 这里namespace必须是接口的路径，不然要运行的时候要报错 “is not known to the MapperRegistry”-->
<mapper namespace="com.zc.beauty.dao.ICaptchaMapper">

3、方法名写错了：

 <!-- 这里的id必须和接口中的方法名相同，不然运行的时候也要报错 -->
    <insert id="savePhoneCode" parameterType="com.zc.beauty.model.PhoneCaptcha">
        insert into phone_captcha(u_phone, c_phonecode, c_sendtime) values(#{u_phone}, #{c_phonecode}, #{c_sendtime})
    </insert>

4、没有

 <bean id="CaptchaMapper" class="org.mybatis.spring.mapper.MapperFactoryBean" >
        <property name="sqlSessionFactory" ref="SqlSessionFactory" />
        <property name="mapperInterface" value="com.zc.beauty.dao.ICaptchaMapper" />
    </bean>

大概就以上问题。