oracle 批量新增sql
<insert id="insertForBatch">
INSERT INTO
ATTENDANCE_OVERTIMEINFO
(ID,EHR_TENANT_ID, USERID, STATUS, ISHOLIDAY, BEGINTIME, ENDTIME,TYPE,REASON
,CREATEUSERID, CREATETIME, UPDATEUSERID, UPDATETIME,LASTUPDATETIME,HOURS,REMARK)
<foreach item="item" collection="list" separator="union all" index="index">
select #{item.id,jdbcType=VARCHAR},
#{item.ehrTenantId,jdbcType=VARCHAR},
#{item.userid,jdbcType=VARCHAR},
#{item.status,jdbcType=INTEGER},
#{item.isholiday,jdbcType=INTEGER},
#{item.begintime,jdbcType=TIMESTAMP},
#{item.endtime,jdbcType=TIMESTAMP},
#{item.type,jdbcType=VARCHAR},
#{item.reason,jdbcType=VARCHAR},
#{item.createuserid,jdbcType=VARCHAR},
#{item.createtime,jdbcType=TIMESTAMP},
#{item.updateuserid,jdbcType=VARCHAR},
#{item.updatetime,jdbcType=TIMESTAMP},
#{item.lastupdatetime,jdbcType=TIMESTAMP},
#{item.hours,jdbcType=INTEGER},
#{item.remark,jdbcType=VARCHAR}
from dual
</foreach>
</insert>