mybatis insert into 多条记录同时返回多个ID主键方法

最新推荐文章于 2023-03-26 12:29:17 发布

weixin_34242509

最新推荐文章于 2023-03-26 12:29:17 发布

阅读量1.8k

点赞数

文章标签： java 数据库 python

原文链接：https://my.oschina.net/u/1789379/blog/1510012

版权

2019独角兽企业重金招聘Python工程师标准>>>

<insert id="insertServiceMappings" parameterType="java.util.List" useGeneratedKeys="true">
         <selectKey keyProperty="id" resultType="java.lang.Long" order="BEFORE">
                SELECT TVA_UPSELLADMIN_CHANNEL_SEQ.nextVal as id FROM DUAL
         </selectKey>    
         INSERT INTO
         tva_upselladmin_channel (id,source_id, service_id, name)
         SELECT TVA_UPSELLADMIN_CHANNEL_SEQ.nextVal, A.* from (
         <foreach collection="list" item="channel" index="index" separator="union all">
         SELECT 
           #{channel.sourceId} as source_id,
           #{channel.serviceId} as service_id,
           #{channel.name}) as name
         FROM DUAL
         </foreach> ) A
    </insert>

参考:https://stackoverflow.com/questions/31748177/mybatis-3-selectkey-inside-foreach

转载于:https://my.oschina.net/u/1789379/blog/1510012