Mybatis 针对Oracle 的批量插入 写法

这是针对Oracle数据库的：

<insert id="insertCrmContact" parameterType="java.util.List">//封装好的listinsert into c_crm_contact_new(INTER_ID,CUSTOMER_ID,CONTACT,CONTACT_TEL,CONTACT_FAX,CONTACT_EMAIL,CREATED_BY,CREATED_DATE,REMARKS)      select SEQ_CUSTOMER_ID.nextval,A.* from (      <foreach collection="list" item="item" index="index" separator="union all">//iteam 就是bean                      select            #{item.CUSTOMER_ID},#{item.CONTACT},#{item.CONTACT_TEL},#{item.CONTACT_FAX},#{item.CONTACT_EMAIL},#{item.CREATED_BY},SYSDATE,#{item.REMARKS}from dual</foreach>) A</insert>

 如果是mysql数据库则相对比较简单了：

<insert id="insertBatch" parameterType="java.util.List">      insert intouser(id,account,password,active,status,name,gender,active_date,expiry_date,type,remark,group_id,disable,exam_number,mobile)      values      <foreach collection="list"item="obj" index="index"separator="," >         (#{obj.id},#{obj.account},#{obj.password},#{obj.active},#{obj.status},#{obj.name},#{obj.gender},#{obj.active_date},         #{obj.expiry_date},#{obj.type},#{obj.remark},#{obj.group_id},#{obj.disable},#{obj.exam_number},#{obj.mobile})      </foreach>      </insert>