Mybatis发生There is no getter for property named 'xxx' in 'class com.xxx.xxx.xxx'异常处理方案

最新推荐文章于 2024-08-22 18:27:21 发布

年月日朝朝暮暮

最新推荐文章于 2024-08-22 18:27:21 发布

阅读量1.3w

点赞数 3

CC 4.0 BY-SA版权

分类专栏：异常处理文章标签： mybatis异常 Java异常简单解决方法

本文链接：https://blog.youkuaiyun.com/weixin_44772799/article/details/95496227

异常处理专栏收录该内容

2 篇文章

订阅专栏

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.youkuaiyun.com/woshixuye/article/details/8820387