Mybatis的批量添加(Oracle、MySQL)
说下今天的感触,网上的真的是参差不齐,报错还多,折腾了一天,自己总结一下,给大家参考一下,都是自己写的,并且测试过的代码!!!!!
话不多说,直接上源码!!!!!
一、Oracle的批量添加
<!-- 批量导入用户 -->
<insert id="insertUsers" parameterType="list" >
insert into olts_users(STU_NO,ID_CARD_NO,USER_NAME,PASS_WORD,MOBILE,QQ,MARJOR,GRADUATE_SCHOOL)
<foreach collection="list" item="item" index="index" open="(" separator=" union all " close=")">
(select
#{item.stu_no},
#{item.id_card_no},
#{item.user_name},
#{item.pass_word},
#{item.mobile},
#{item.qq},
#{item.marjor},
#{item.graduate_School}
from dual)
</foreach>
</insert>
二、MySQL的批量添加
<!-- 批量导入用户 -->
<insert id="insertusers" parameterType="java.util.List" >
insert into sysuser (uname,upass,college,utype,tname,sex,tel,email) values
<foreach collection="list" item="item" index="index" separator="," >
(
#{item.uname},
#{item.upass},
#{item.college},
#{item.utype},
#{item.tname},
#{item.sex},
#{item.tel},
#{item.email}
)
</foreach>
</insert>
注意:MySQL连接数据库的时候加个参数,allowMultiQueries=true,这个设置为可以进行批量操作!!!