一、批量插入数据到Oracle
<insert id="saveBatch" parameterType="java.util.List">
insert into USER(USER_GUID, USER_NAME)
<foreach collection="users" item="user" separator="union all">
select #{user.userGuid, jdbcType=VARCHAR}, #{user.userName, jdbcType=VARCHAR} from dual
</foreach>
</insert>
二、批量插入数据到Mysql
<insert id="saveBatch" parameterType="List">
insert into USER(USER_GUID, USER_NAME)
<foreach collection="users" item="user" separator=",">
(select #{user.userGuid, jdbcType=VARCHAR}, #{user.userName, jdbcType=VARCHAR})
</foreach>
</insert>