<!-- 批量新增 -->
<insert id="insertBatch" parameterType="java.util.List">
<selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Long">
select SEQ_LABELER_ID.nextval AS id from dual
</selectKey>
insert into ${cmdb}.EPC_LABELER(ID,RESOURCE_TYPE,RESOURCE_ID,LABEL_ID)
select SEQ_LABELER_ID.nextval ID,A.* from(
<foreach collection="labelers" item="item" index="index"
separator="UNION ALL">
select
#{item.resourceType,jdbcType=VARCHAR} RESOURCE_TYPE,
#{item.resourceId,jdbcType=VARCHAR} RESOURCE_ID,
#{item.labelId,jdbcType=VARCHAR} LABEL_ID
from dual
</foreach>
)A
</insert>
mybatis-oracle批量新增,主键使用序列
最新推荐文章于 2023-10-07 11:49:43 发布