mybatis实现oracle批量插入，带序列（记录一下）

转载地址：http://blog.csdn.net/xiaosimm/article/details/47775705

[java]  view plain  copy

1. <insert id="addCheckDetail" parameterType="java.util.List">  
2.         INSERT INTO CHECK_DETAIL(  
3.             CHECK_id,CHECK_DATE,CHECK_WEEK,EMP_CODE,CHECK_TIME,CHECK_LATE,CHECK_LEAVE_EARLY,  
4.             CHECK_EXCEPTION,CHECK_WORK_OVERTIME,EMP_NAME,DEPT_NAME,CHECK_LATE_TIME,DESCRIPTION  
5.           )  
6.           select CHECK_DETAIL_SEQ.NEXTVAL,cd.* from(  
7.           <foreach collection="list" item="item" index="index" separator="union all">  
8.               select  
9.                 #{item.checkDate,jdbcType=VARCHAR},  
10.                 #{item.checkWeek,jdbcType=VARCHAR},  
11.                 #{item.empCode,jdbcType=VARCHAR},  
12.                 #{item.checkTime,jdbcType=VARCHAR},  
13.                 #{item.checkLate,jdbcType=VARCHAR},  
14.                 #{item.checkLeaveEarly,jdbcType=VARCHAR},  
15.                 #{item.checkException,jdbcType=VARCHAR},  
16.                 #{item.checkWorkOverTime,jdbcType=VARCHAR},  
17.                 #{item.empName,jdbcType=VARCHAR},  
18.                 #{item.deptName,jdbcType=VARCHAR},  
19.                 #{item.checkLateTime,jdbcType=VARCHAR},  
20.                 #{item.description,jdbcType=VARCHAR}  
21.                 from dual  
22.             </foreach>  
23.             ) cd  
24.     </insert>