oracle批量插入并且返回自增主键_oracle 自增主键实现批量更新和增加sql

增加：

方案1

INSERT INTO WF_TASKTEMP_DEALSTAFF (DEAL_ID, TEMP_ID, STAFF_ID,DEAL_TYPE, STATUS)

SELECT WF_TASKTEMP_DEALSTAFF$SEQ.NEXTVAL,a.* FROM (

SELECT

#{item.tempId,jdbcType=VARCHAR},

#{item.staffId,jdbcType=VARCHAR},

#{item.dealType,jdbcType=VARCHAR},

#{item.status,jdbcType=CHAR}

FROM dual

) a

方案二

begin

insert into WF_TASKTEMP_DEALSTAFF

(

DEAL_ID, TEMP_ID, STAFF_ID,DEAL_TYPE, STATUS

)

values(WF_TASKTEMP_DEALSTAFF$SEQ.nextval,

#{item.tempId,jdbcType=VARCHAR},

#{item.staffId,jdbcType=VARCHAR},

#{item.dealType,jdbcType=VARCHAR},

#{item.status,jdbcType=CHAR}

);

end;

修改

oracle

UPDATE ZC_TR_MULTI_ORDER_CURRENCY

SYS_CORDER_CODE = #{item.sysCorderCode,jdbcType=VARCHAR},

SYS_PORDER_CODE = #{item.sysPorderCode,jdbcType=VARCHAR},

BIZ_PORDER_CODE = #{item.bizPorderCode,jdbcType=VARCHAR},

ORIGINAL_ORDER_CODE = #{item.originalOrderCode,jdbcType=VARCHAR},

SPLIT_USER_ID = #{item.splitUserId,jdbcType=VARCHAR},

CREATE_DATE = #{item.createDate},

UPDATE_DATE = #{item.updateDate},

where id = #{item.id,jdbcType=VARCHAR}

java接口

int batchUpdateSplitSinglePickCurrency(@Param(value = "list") List list) throws Exception;

附赠mysql

UPDATE ZC_TR_MULTI_ORDER_CURRENCY

SYS_CORDER_CODE = #{item.sysCorderCode,jdbcType=VARCHAR},

SYS_PORDER_CODE = #{item.sysPorderCode,jdbcType=VARCHAR},

BIZ_PORDER_CODE = #{item.bizPorderCode,jdbcType=VARCHAR},

ORIGINAL_ORDER_CODE = #{item.originalOrderCode,jdbcType=VARCHAR},

SPLIT_USER_ID = #{item.splitUserId,jdbcType=VARCHAR},

CREATE_DATE = #{item.createDate},

UPDATE_DATE = #{item.updateDate},

where id = #{item.id,jdbcType=VARCHAR}

java接口

void updateMatchs(@Param(value = "matchs")List matchs);