Mybatis之Invalid bound statement (not found)问题解决

ゝ一世哀愁。 2022-06-07 09:41 101阅读 0赞

# Invalid bound statement (not found) #

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文件：

2、接口路径写错了：

1.    
2.  <mapper namespace="com.zc.beauty.dao.ICaptchaMapper">

3、方法名写错了：

1.    
2.     <insert id="savePhoneCode" parameterType="com.zc.beauty.model.PhoneCaptcha">  
3.         insert into phone\_captcha(u\_phone, c\_phonecode, c\_sendtime) values(\#\{u\_phone\}, \#\{c\_phonecode\}, \#\{c\_sendtime\})  
4.     </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>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NDcwNzMz_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NDcwNzMz_size_16_color_FFFFFF_t_70]: /images/20220607/c6186ddf804e41539024658ad3529f5a.png