ef 批量保存 oracle,mybatis-oracle与mysql批量添加

mybatis-oracle与mysql批量添加

1、oracle批量添加

insert into CRITERION_CODE_INSPECT (ID, CRITERION_CODE, CRITERION_NAME,

CRITERION_NAME_INSPECT, FILE_ID, FILE_NAME

)

select #{item.id,jdbcType=DECIMAL}, #{item.criterionCode,jdbcType=VARCHAR}, #{item.criterionName,jdbcType=VARCHAR},

#{item.criterionNameInspect,jdbcType=VARCHAR}, #{item.fileId,jdbcType=DECIMAL}, #{fileName,jdbcType=VARCHAR}

from dual

2、mysql批量添加

insert into inquiry_part

(part_id, insure_part_id, inquiry_id,third_inquiry_id,part_name,

part_code, part_quality, img_url,

create_time, last_time, abled,remark

) values

(#{item.partId,jdbcType=BIGINT}, #{item.insurePartId,jdbcType=BIGINT},

#{item.inquiryId,jdbcType=BIGINT},#{item.thirdInquiryId,jdbcType=BIGINT},#{item.partName,jdbcType=VARCHAR},

#{item.partCode,jdbcType=VARCHAR}, #{item.partQuality,jdbcType=VARCHAR}, #{item.imgUrl,jdbcType=VARCHAR},

#{item.createTime,jdbcType=TIMESTAMP}, #{item.lastTime,jdbcType=TIMESTAMP}, #{item.abled,jdbcType=INTEGER},

#{item.remark,jdbcType=VARCHAR}

)