<insert id="insertBatch" parameterType="java.util.List"> INSERT INTO T_ZZ_RS_EDU( RS_EID, NAME_, IDCARD, CI_RS_ID, START_DATE, END_DATE, WORK_UNIT, WORK_DUTY, REGION_CODE, STATUS_, CREATOR, CREATE_TIME, UPDATER, UPDATED, RESUME_TYPE ) select SEQ_RS_EID.NEXTVAL,A.* from( <foreach collection="list" item="item" index="index" close=")" open="(" separator="union"> select #{item.personName,jdbcType=VARCHAR}, #{item.idCard,jdbcType=VARCHAR}, #{item.populationId,jdbcType=DECIMAL}, #{item.startDate,jdbcType=TIMESTAMP}, #{item.endDate,jdbcType=TIMESTAMP}, #{item.workUnit,jdbcType=VARCHAR}, #{item.workDuty,jdbcType=VARCHAR}, #{item.regionCode,jdbcType=VARCHAR}, '1', #{item.creatorId,jdbcType=DECIMAL}, #{item.createTime,jdbcType=TIMESTAMP}, #{item.updaterId,jdbcType=DECIMAL}, #{item.updateTime,jdbcType=TIMESTAMP}, #{item.resumeType,jdbcType=VARCHAR} from dual </foreach> ) A </insert>
mybatis,oracle批量插入带序列
最新推荐文章于 2024-01-26 13:54:33 发布