请稍等 ...

实现搜索功能出现异常

ShareService

ShareMapper
ShareService

ShareMapper.xml

浏览器异常

2021-01-07 16:00:31.052 ERROR [content-center,] 30439 — [nio-8010-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named ‘title’ in ‘class java.lang.String’] with root cause

org.apache.ibatis.reflection.ReflectionException: There is no getter for property named ‘title’ in 'class java.lang.String’
at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:419) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:164) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:162) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:49) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:122) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.DynamicContext $C o n t e x t M a p . g e t (D y n a m i c C o n t e x t . j a v a : 94) [m y b a t i s - 3.4.6 . j a r : 3.4.6] a t o r g . a p a c h e . i b a t i s . s c r i p t i n g . x m l t a g s . D y n a m i c C o n t e x t$ ContextAccessor.getProperty(DynamicContext.java:108) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2685) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:114) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:50) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.TrimSqlNode.apply(TrimSqlNode.java:55) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41) ~[mybatis-3.4.6.jar:3.4.6]
at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292) ~[mybatis-3.4.6.jar:3.4.6]
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:82) ~[pagehelper-5.1.8.jar:na]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.4.6.jar:3.4.6]
at com.sun.proxy. $Proxy208.query(Unknown Source) ~[na:na] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar:3.4.6] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_271] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_271] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_271] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_271] at org.mybatis.spring.SqlSessionTemplate$ SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.2.jar:1.3.2]
at com.sun.proxy. $P r o x y 152 . s e l e c t L i s t (U n k n o w n S o u r c e) [n a : n a] a t o r g . m y b a t i s . s p r i n g . S q l S e s s i o n T e m p l a t e . s e l e c t L i s t (S q l S e s s i o n T e m p l a t e . j a v a : 230) [m y b a t i s - s p r i n g - 1.3.2 . j a r : 1.3.2] a t o r g . a p a c h e . i b a t i s . b i n d i n g . M a p p e r M e t h o d . e x e c u t e F o r M a n y (M a p p e r M e t h o d . j a v a : 139) [m y b a t i s - 3.4.6 . j a r : 3.4.6] a t o r g . a p a c h e . i b a t i s . b i n d i n g . M a p p e r M e t h o d . e x e c u t e (M a p p e r M e t h o d . j a v a : 76) [m y b a t i s - 3.4.6 . j a r : 3.4.6] a t o r g . a p a c h e . i b a t i s . b i n d i n g . M a p p e r P r o x y . i n v o k e (M a p p e r P r o x y . j a v a : 59) [m y b a t i s - 3.4.6 . j a r : 3.4.6] a t c o m . s u n . p r o x y .$ Proxy161.selectByParam(Unknown Source) ~[na:na]
at com.szj.contentcenter.service.content.ShareService.q(ShareService.java:161) ~[classes/:na]
at com.szj.contentcenter.service.content.ShareService $F a s t C l a s s B y S p r i n g C G L I B$ 4dcfbebc.invoke() ~[classes/:na]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
at org.springframework.aop.framework.CglibAopProxy $D y n a m i c A d v i s e d I n t e r c e p t o r . i n t e r c e p t (C g l i b A o p P r o x y . j a v a : 684) [s p r i n g - a o p - 5.1.7 . R E L E A S E . j a r : 5.1.7 . R E L E A S E] a t c o m . s z j . c o n t e n t c e n t e r . s e r v i c e . c o n t e n t . S h a r e S e r v i c e$ $E n h a n c e r B y S p r i n g C G L I B$ $6bb67b87.q() ~[classes/:na]
at com.szj.contentcenter.controller.content.ShareController.q(ShareController.java:32) ~[classes/:na]

机智的平田君 2021-01-07 16:12:36

源自：14-2 编写分享列表页

699

收起

提交取消

2回答

大目回答被采纳获得+3积分 2021-01-07 22:20:26

给力哦！

0 回复有任何疑惑可以回复我~

收起回答

提问者机智的平田君 #1
```
非常感谢！
```
回复有任何疑惑可以回复我~ 2021-01-11 14:48:42

提问者机智的平田君 2021-01-07 16:24:44

改成这样就可以了。。
<select id="selectByParam" resultType="com.szj.contentcenter.domain.entity.content.Share">
select * from share
<where>
<if test="_parameter!= null and _parameter != ''">
title like CONCAT('%', #{title}, '%')
</if>
and audit_status = 'PASS'
</where>
</select>