<update id="update" parameterType="java.util.List">
UPDATE setting
SET content = CASE id
<foreach collection="list" item="setting" >
WHEN #{setting.id} THEN #{setting.content}
</foreach>
END
WHERE
id in (<foreach collection="list" item="setting" separator="," >
#{setting.id}
</foreach>
)
</update>