这是针对Oracle数据库的：
<insert id="insertCrmContact" parameterType="java.util.List">//封装好的list
insert 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>
| 
转播
