Mybatis版本:mybatis-3.4.0.jar
一 、发现问题异常如下:
严重: Servlet.service() for servlet [spring] 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 'dto' in 'class com.mes.dto.SearchOrderDto'] with root cause
org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'dto' in 'class com.mes.dto.SearchOrderDto'
at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:409)
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)
(以下省略一些字)
二 、解决方法1:在.xml之中使用的时候把参数名改成"_parameter"
原代码:
<sql id="queryConditions">
<where>
<if test="dto.search_status != null">
AND order_status = #{dto.search_status}
</if>
<if test="dto.keyword != null and dto.keyword != ''">
AND ((order_id like #{dto.keyword}) or (order_clientname like #{dto.keyword}) or
(order_productname like #{dto.keyword}) or (order_contractid like
#{dto.keyword})or (order_materialname like #{dto.keyword})or (order_materialsource like
#{dto.keyword}) or (order_imgid like #{dto.keyword}))
</if>
<if test="dto.fromTime != null and dto.toTime != null">
AND order_committime BETWEEN #{dto.fromTime} AND #{dto.toTime}
</if>
</where>
</sql>
修改之后的代码:
<sql id="queryConditions">
<where>
<if test="_parameter != null">
AND order_status = #{_parameter}
</if>
<if test="dto.keyword != null and dto.keyword != ''">
AND ((order_id like #{_parameter}) or (order_clientname like #{_parameter}) or
(order_productname like #{_parameter}) or (order_contractid like
#{_parameter})or (order_materialname like #{_parameter})or (order_materialsource like
#{_parameter}) or (order_imgid like #{_parameter}))
</if>
<if test="_parameter != null and _parameter != null">
AND order_committime BETWEEN #{_parameter} AND #{_parameter}
</if>
</where>
</sql>
三 、解决方案二:在这个.xml的接口中提前定义(个人推荐使用)
原代码:
public interface OrderCustomerMapper {
Long getOrderCount();
int countBySearchDto(SearchOrderDto dto);
List<MesOrder> getPageListBySearchDto(SearchOrderDto dto, PageQuery page);
}
修改之后的代码:
public interface MesOrderCustomerMapper {
Long getOrderCount();
int countBySearchDto(@Param("dto")SearchOrderDto dto);
List<MesOrder> getPageListBySearchDto(@Param("dto")SearchOrderDto dto, @Param("page")PageQuery page);
}
四、异常原因分析
在 Mybatis之中默认采用OGNL解析参数,然后自动采用对象树的形式取 string.xxx 值,如果没在在方法中定义,则会抛异常报错。
参考博客:
https://blog.csdn.net/woshixuye/article/details/8820387