<!-- 批量更新 单个字段-->
<update id="updateBatchOne" parameterType="java.util.List">
<if test="list!=null">
update user
<trim prefix="set" suffixOverrides=",">
<trim prefix="user_name = case" suffix="end,">
<foreach collection="list" item="item" index="index">
<if test="item.userName != null">
when id=#{item.id} then #{item.userName}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="item" index="index" >
id=#{item.id}
</foreach>
</if>
</update>
<!-- 批量更新 多个字段-->
<update id="updateBatch" parameterType="java.util.List">
<if test="list!=null">
update user
<trim prefix="set" suffixOverrides=",">
<trim prefix="user_name = case" suffix="end">
<foreach collection="list" item="item" index="index">
<if test="item.userName != null">
when id=#{item.id} then #{item.userName}
</if>
</foreach>
</trim>
<trim prefix=",description = case" suffix="end">
<foreach collection="list" item="item" index="index">
<if test="item.description != null">
when id=#{item.id} then #{item.description}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="item" index="index" >
id=#{item.id}
</foreach>
</if>
</update>