1、oracle建索引 就不说了 2、mapper.xml <insert id="saveRemarks" parameterType="java.util.List"> insert into BZ_MDCH_ITEM_DISTANCE_REMARK(ID, PARENT_ID, REMARK_ORDER, LIMIT_CONDITION, TAXIWAY_CODE, RUNWAY_NUM, ENTER_MOVEIN_DISTANCE, ENTER_MOVEIN_DISTANCE_UNIT) select SEQ_MDCH_ITEM_DISTANCE_REMARK.NEXTVAL id,r.* from ( <foreach collection="list" item="remark" index="index" separator="union all"> select #{remark.parentId, jdbcType=DECIMAL}, #{remark.remarkOrder, jdbcType=DECIMAL}, #{remark.limitCondition, jdbcType=VARCHAR}, #{remark.taxiwayCode, jdbcType=VARCHAR}, #{remark.runwayNum, jdbcType=VARCHAR}, #{remark.enterMoveinDistance, jdbcType=VARCHAR}, #{remark.enterMoveinDistanceUnit, jdbcType=VARCHAR} from DUAL </foreach> ) r </insert>
mybatis + oracle + 自增id 批量插入
最新推荐文章于 2023-04-14 11:00:26 发布