现在的写法A:
<update id="update" parameterType="ruleItem.Bean">
update t_rule_item<!-- set id=#{id} -->
<set>
<if test="ruleId!=null and ruleId != ''">ruleId=#{ruleId},</if>
<if test="fieldName!=null and fieldName != ''">fieldName=#{fieldName},</if>
<if test="comment!=null and comment != ''">comment=#{comment},</if>
</set>
where id=#{id}
</update>
以前的写法B:
<update id="update" parameterType="ruleItem.Bean">
update t_rule_item
set id=#{id}
<if test="ruleId!=null and ruleId != ''">,ruleId=#{ruleId}</if>
<if test="fieldName!=null and fieldName != ''">,fieldName=#{fieldName}</if>
<if test="comment!=null and comment != ''">,comment=#{comment}</if>
where id=#{id}
</update>
区别:(B)的第三行,以及“,”(逗号的位置)。