在xml中使用for循环即可
<insert id="insertBatch">
INSERT INTO t_user
(id, name, age)
VALUES
<foreach collection ="list" item="user" separator =",">
(#{user.id}, #{user.name}, #{user.age})
</foreach >
</insert>
在xml中使用for循环即可
<insert id="insertBatch">
INSERT INTO t_user
(id, name, age)
VALUES
<foreach collection ="list" item="user" separator =",">
(#{user.id}, #{user.name}, #{user.age})
</foreach >
</insert>