MyBatis报错There is no getter for property named 'username' in 'class java.lang.String'

最新推荐文章于 2022-03-11 09:55:52 发布

原创最新推荐文章于 2022-03-11 09:55:52 发布 · 965 阅读

0 ·

CC 4.0 BY-SA版权

MyBatis 专栏收录该内容

4 篇文章

订阅专栏

本文详细解析了一个关于MyBatis框架中动态SQL语法的常见错误：在使用字符串类型参数时，尝试通过反射获取不存在的属性'username'，导致查询失败。文章提供了错误堆栈跟踪，并指出正确的SQL语句应使用'value'作为参数占位符。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错：

### Error querying database. Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'username' in 'class java.lang.String'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'username' in 'class java.lang.String'
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
   at com.test.Test.main(Test.java:23)
Caused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'username' in 'class java.lang.String'
   at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:419)
   at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:164)
   at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:162)
   at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:49)
   at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:122)
   at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextMap.get(DynamicContext.java:94)
   at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:108)
   at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2685)
   at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:114)
   at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
   at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
   at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470)
   at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434)
   at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44)
   at org.apache.ibatis.scripting.xmltags.TextSqlNode$BindingTokenParser.handleToken(TextSqlNode.java:77)
   at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78)
   at org.apache.ibatis.scripting.xmltags.TextSqlNode.apply(TextSqlNode.java:51)
   at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33)
   at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41)
   at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
   ... 2 more
原因：sql语句写错了， select * from user where username like '%${username}%'必须写value

<select id="getUserByName" parameterType="java.lang.String" resultType="com.edu.pojos.User">
select * from user where username like '%${value}%'
</select>