There is no getter for property named 'pro' in 'class java.lang.String'

Sql语句错误示例:

<select id="getbusinessPermitTotal" resultType="integer">
	SELECT IFNULL(SUM(ISNULL(ALLOW_RECORD_NUM,0)),0)
	FROM FOODS_DWS.FACT_MANAGE_ALLOW_RECORD AS F1
	<if test="pro!=null">
		 WHERE F1.REGION_KEY IN (SELECT REGION_KEY FROM FOODS_DWS.DIM_REGION WHERE PROVINCE_NAME= #{pro})
	</if>
</select>

解决办法:
把pro换成_parameter 就可以了

<select id="getbusinessPermitTotal" resultType="integer">
	SELECT IFNULL(SUM(ISNULL(ALLOW_RECORD_NUM,0)),0)
	FROM FOODS_DWS.FACT_MANAGE_ALLOW_RECORD AS F1
	<if test="_parameter!=null">
		 WHERE F1.REGION_KEY IN (SELECT REGION_KEY FROM FOODS_DWS.DIM_REGION WHERE PROVINCE_NAME= #{_parameter })
	</if>
</select>
posted @ 2021-11-05 12:53  最终的赢家  阅读(29)  评论(0)    收藏  举报