<trim prefix="" suffix="" suffixOverrides="" prefixOverrides=""></trim>
prefix:在trim标签内sql语句加上前缀。
suffix:在trim标签内sql语句加上后缀。
prefixOverrides:指定去除多余的前缀内容
suffixOverrides:指定去除多余的后缀内容,如:suffixOverrides=",",去除trim标签内sql语句多余的后缀","。
demo
批量更新:
<update id="updateGradeByList">
update student_class_relation
<trim prefix="set" suffixOverrides=",">
<trim prefix="grade_id=case" suffix="end,">
<foreach collection="studentClassRelationList" item="item">
<if test="null!=item.gradeId">
when id=#{item.id} then #{item.gradeId}
</if>
</foreach>
</trim>
</trim>
where id in
<foreach collection="studentClassRelationList" item="item" open="(" separator="," close=")">
#{item.id}
</foreach>
</update>