<insert id="addCheckDetail" parameterType="java.util.List">
INSERT INTO CHECK_DETAIL(
CHECK_id,CHECK_DATE,CHECK_WEEK,EMP_CODE,CHECK_TIME,CHECK_LATE,CHECK_LEAVE_EARLY,
CHECK_EXCEPTION,CHECK_WORK_OVERTIME,EMP_NAME,DEPT_NAME,CHECK_LATE_TIME,DESCRIPTION
)
select CHECK_DETAIL_SEQ.NEXTVAL,cd.* from(
<foreach collection="list" item="item" index="index" separator="union all">
select
#{item.checkDate,jdbcType=VARCHAR},
#{item.checkWeek,jdbcType=VARCHAR},
#{item.empCode,jdbcType=VARCHAR},
#{item.checkTime,jdbcType=VARCHAR},
#{item.checkLate,jdbcType=VARCHAR},
#{item.checkLeaveEarly,jdbcType=VARCHAR},
#{item.checkException,jdbcType=VARCHAR},
#{item.checkWorkOverTime,jdbcType=VARCHAR},
#{item.empName,jdbcType=VARCHAR},
#{item.deptName,jdbcType=VARCHAR},
#{item.checkLateTime,jdbcType=VARCHAR},
#{item.description,jdbcType=VARCHAR}
from dual
</foreach>
) cd
</insert>
mybatis实现oracle批量插入,带序列(记录一下)
最新推荐文章于 2024-06-05 20:55:01 发布