oracle 批量插入数据的两种方式 ,第一种方式通过代码块,第二种是借助临时表
<insert id="addStudent2">
begin
<foreach collection="list" item="stu">
insert into student(sno,sname,sage,ssex)
values(
#{stu.sno,jdbcType=NUMERIC},
#{stu.sname,jdbcType=VARCHAR},
#{stu.sage,jdbcType=NUMERIC},
#{stu.ssex,jdbcType=VARCHAR}
);
</foreach>
end;
</insert>
<insert id="addStudent3">
insert into student(sno,sname,sage,ssex) values
<foreach collection="list" item="stu" open="(" close=")" separator="union" >
select #{stu.sno,jdbcType=NUMERIC},#{stu.sname,jdbcType=VARCHAR},#{stu.sage,jdbcType=NUMERIC},# {stu.ssex},jdbcType=VARCHAR) from dual
</foreach>
</insert>
mysql 中 批量插入数据
<insert id="addStudent2">
insert into student(sno,sname,sage,ssex) values(
<foreach collection="list" item="stu">
(#{stu.sno,jdbcType=NUMERIC},
#{stu.sname,jdbcType=VARCHAR},
#{stu.sage,jdbcType=NUMERIC},
#{stu.ssex,jdbcType=VARCHAR})
</foreach>
</insert>