<select id="" resultType ="">
SELECT *
FROM sys_user
WHERE id in
<foreach collectioin="list" open="(" close=")" separator="," item="id" index="i">
#{id}
</foreach>
</select>
INSERT INTO tablename (column-a,column-b,column-c....)
VALUES
<foreach collection = "list" item="user" separator =",">
(
#{user.a},#{user.b},#{user.c})
</foreach>
<update id ="">
UPDATE sys_user
SET
<foreach collection="_parameter" item="val" index="key" separator = ",">
${key} = #{val}
</foreach>
WHERE id = #{id}
</update>
原文:https://www.cnblogs.com/XtsLife/p/12575709.html