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

最新推荐文章于 2025-05-19 09:15:30 发布

noku_ln10

最新推荐文章于 2025-05-19 09:15:30 发布

阅读量4.4w

点赞数 1

CC 4.0 BY-SA版权

文章标签： getter class bean string mysql null

本文链接：https://blog.youkuaiyun.com/noku_ln10/article/details/7977976

本文探讨了在MySQL查询中遇到的特定问题，即如何正确设置参数以避免出现错误提示，并提供了相应的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql文如下，传入参数为‘parentCategoryId’，运行报错为：There is no getter for property named 'parentCategoryId' in 'class java.lang.String

	<select id="selectCategoryList"  parameterType="java.lang.String" resultType="MstCategoryBean">
		SELECT
			category_id				AS	categoryId,
			category_name			AS	categoryName,
			view_orderby			AS	viewOrderby
		FROM
			mst_category
		WHERE
			del_flg =0
		<if test="parentCategoryId!=null  and parentCategoryId!=''">
		and
			parent_category_id = #{parentCategoryId}
		</if>
	</select>

发现不能将参数设为bean里的名称，如果传入类型为String类型，则参数需统一修改为[_parameter],修改后的sql语句如下(不管你的参数是什么，都要改成"_parameter")

	

		SELECT
			category_id				AS	categoryId,
			category_name			AS	categoryName,
			view_orderby			AS	viewOrderby
		FROM
			mst_category
		WHERE
			del_flg =0
		
		and
			parent_category_id = #{_parameter}