MyBatis sql报错 There is no getter for property named 'XXX' in 'class java.lang.Long'

练习时报错情形

所用数据库为MySQL

<select id="getAnswerQstAverageTime" parameterType="Long" resultType="com.pdm.pre.sur.dto.SurAnswerQstDto">
		select
		count(1) as count,qst_id as qstId,round(avg(timestampdiff(SECOND,answer_start_time,answer_end_time)),1) as averageTime
		from sur_answer_qst
		<where>
			<if test="surveyId !=null and surveyId !=''">
			survey_id = #{surveyId}
			</if>
		</where>
		group by qst_id
		order by qst_id
	</select>

错误信息

There is no getter for property named 'surveyId' in 'class java.lang.Long'

解决办法

第一种：用"_parameter"代替当前参数

<select id="getAnswerQstAverageTime" parameterType="Long" resultType="com.pdm.pre.sur.dto.SurAnswerQstDto">
		select
		count(1) as count,qst_id as qstId,round(avg(timestampdiff(SECOND,answer_start_time,answer_end_time)),1) as averageTime
		from sur_answer_qst
		<where>
			<if test="_parameter !=null and _parameter !=''">
			survey_id = #{surveyId}
			</if>
		</where>
		group by qst_id
		order by qst_id
	</select>

第二种：在接口中定义方法时 添加“@Param(“参数名”)” 标记

List<SurAnswerQstDto> getAnswerQstAverageTime(@Param("surveyId") Long surveyId);

这两种方式都可以解决问题，不会再报错，感兴趣的话自己可以弄个小demo试一下。

报错原因分析

以上情况报错的直接原因是在sql语句中加入了if判断语句，并且parameterType类型是最基本的类型，在验证的时候发生了错误；如果sql不写if判断的话，直接写成下面这样是不会报错的（报错原因追究太深的话现在我也不是很清楚，我还是个菜鸟）：

<select id="getAnswerQstAverageTime" parameterType="Long" resultType="com.pdm.pre.sur.dto.SurAnswerQstDto">
		select
		count(1) as count,qst_id as qstId,round(avg(timestampdiff(SECOND,answer_start_time,answer_end_time)),1) as averageTime
		from sur_answer_qst
		<where>
			survey_id = #{surveyId}
		</where>
		group by qst_id
		order by qst_id
	</select>

实践出真知嘛，如果像我一样刚入行不久，感兴趣的话可以测试一下；以上是我自己的一点见解，哪里说的不好，还请见谅！希望能帮到大家。