关于 mybatis 传参

基本数据类型：包含int,String,Date等。基本数据类型作为传参，只能传入一个。通过[color=red]#{参数名} [/color]即可获取传入的值
复杂数据类型：包含JAVA实体类、Map。通过#{属性名}或#{map的KeyName}即可获取传入的值
parameterType="java.lang.String"
parameterType="Map"
parameterType="类名"
resultMap="BaseResultMap"
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>

<SELECT id=selectCategoryList resulttype="MstCategoryBean" parametertype="java.lang.String">
SELECT category_id AS categoryId,
category_name AS categoryName,
view_orderby AS viewOrderby
FROM mst_category WHERE del_flg =0
<IF test="_parameter!=null and _parameter!=''">
and parent_category_id = #{_parameter}
</SELECT>

[color=red]<if test="parentCategoryId!=null and parentCategoryId!=''"> 是去掉这个判断就可以了 #{}中名字随便取都能获取值，如果不去掉判断 必须改为_parameter，已测试[/color]