首页 > 代码库 > MyBatis笔记----报错：Exception in thread "main" org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)解决方法

MyBatis笔记----报错：Exception in thread "main" org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)解决方法

2024-09-12 08:15:03   216人阅读

报错

 

Exception in thread "main" org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ij34.model.UserMapper.selectarticleat org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:230)at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:48)at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)at com.sun.proxy.$Proxy0.selectarticle(Unknown Source)at com.ij34.bean.Test.main(Test.java:23)

 

 

 

解决方法

 

接口UserMapper的方法selectarticle与mybatis-config.xml里

与 下面UserMapper.xml里select id的要相同，当时写了大写

  <select id="selectArticle" parameterType="int" resultMap="resultAticleList">  select users.id,users.name,users.age,article.id aid,article.title,article.content from users,article  where users.id=article.userid and users.id=#{id}  </select>

 

MyBatis笔记----报错：Exception in thread "main" org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)解决方法


联系
我们