MyBatis Note----error: Exception in thread ' main ' org.apache.ibatis.binding.BindingException:Invalid bound statement (not Found) workaround

Error

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:+) at Org.apache.ibatis.binding.MapperProxy.invoke (Mapperproxy.java:+) at Com.sun.proxy. $Proxy 0.selectarticle (Unknown Source) at Com.ij34.bean.Test.main (Test.java:23)

Workaround

Method of interface Usermapper Selectarticle and Mybatis-config.xml

The same as the select ID in the usermapper.xml below, which was written in uppercase

  <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 Note----error: Exception in thread ' main ' org.apache.ibatis.binding.BindingException:Invalid bound statement (not Found) workaround