<update id="updateBatch" parameterType="java.util.ArrayList">
UPDATE USER
<trim prefix="set" suffixOverrides=",">
<trim prefix="USER_NAME =case" suffix="end,">
<foreach collection="userList" item="user" index="index">
when userId=#{user.userId} then #{user.userName}
</foreach>
</trim>
<trim prefix="USER_AGE =case" suffix="end,">
<foreach collection="userList" item="user" index="index">
when userId=#{user.userId} then #{user.userAge}
</foreach>
</trim>
</trim>
WHERE userId in
<foreach collection="userList" index="index" item="user" separator="," open="(" close=")">
#{user.userId}
</foreach>
</update>
