oracle 批量新增

最新推荐文章于 2024-07-17 19:00:48 发布

lqz1993

最新推荐文章于 2024-07-17 19:00:48 发布

阅读量790

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/lqz1993/article/details/109783362

版权

<insert id="insertBatch" parameterType="java.util.List" useGeneratedKeys="false" >
    INSERT INTO WF_TASKTEMP_DEALSTAFF (DEAL_ID, TEMP_ID, STAFF_ID,DEAL_TYPE, STATUS)
    SELECT WF_TASKTEMP_DEALSTAFF$SEQ.NEXTVAL,a.* FROM (
    <foreach collection="list" item="item" separator="union all">
        SELECT
        #{item.tempId,jdbcType=VARCHAR},
        #{item.staffId,jdbcType=VARCHAR},
        #{item.dealType,jdbcType=VARCHAR},
        #{item.status,jdbcType=CHAR}
        FROM dual
    </foreach>
    ) a
</insert>

<!-- 使用存储过程实现 -->       
<insert id="insertBatch1" parameterType="java.util.List">
            begin
            <foreach collection="list" item="item" index="index">
                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}
                );
            </foreach>
            end;
        </insert>