Caused by: org.apache.ibatis.reflection.ReflectionException我碰到的情况，原因不唯一

来源：互联网发布：淘宝店铺主营编辑：程序博客网时间：2024/05/01 06:57

映射文件：

<select id="selectKeyByUserId" resultMap="Xxx">
       <![CDATA[
       SELECT * FROM 表名1
         where 1=1
           <if test="userId!=0">
            and ID=#{userId,jdbcType=NUMERIC})
           </if>
   </select>

dao层

public List<Xxx> selectKeyByUserId(long userId);

Caused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'userId' in 'class java.lang.Long'
   at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:380)
   at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:170)
   at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:152)
   at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:48)
   at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:116)
   at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextMap.get(DynamicContext.java:97)
   at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:116)
   at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1657)
   at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:92)
   at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
   at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)
   at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:49)
   at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
   at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)
   at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:333)
   at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:413)
   at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:395)
   at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:48)
   at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
   at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:33)
   at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
   at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:40)
   at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:278)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)

... 89 more

出现原因
这里出现的问题是在DAO方法中定义的参数与 实体中定义的属性不一致导致的。

解决方案：

dao层加@Param("userId")注解即可

public List<DictItem> selectKeyByUserId(@Param("userId") long userId);

0 0