mybatis 批量插入 oracle

最新推荐文章于 2024-03-08 14:05:57 发布

不是码农的农民

最新推荐文章于 2024-03-08 14:05:57 发布

阅读量171

点赞数

本文链接：https://blog.csdn.net/zengqingshanzheng/article/details/102799085

版权

<insert id="insertList" parameterType="java.util.List" useGeneratedKeys="false">
    insert into KM_ANBOT_MARKQUESTION_EVENT
    (ID,
    ANBOT_MARKQUESTION_ID,
    MARK_EVENT,
    MARK_STATUS,
    EVENT_DESC,
    CREATE_UM,
    CREATE_TIME)
    select item.* from (
    <foreach collection="list" index="index" item="item" separator="UNION ALL" >
        select
        sys_guid(),
        #{item.anbotMarkquestionId,jdbcType=VARCHAR},
        #{item.markEvent,jdbcType=DECIMAL},
        #{item.markStatus,jdbcType=DECIMAL},
        #{item.eventDesc,jdbcType=VARCHAR},
        #{item.createUm,jdbcType=VARCHAR},
        #{item.createTime,jdbcType=TIMESTAMP}
        from dual
    </foreach>
    )item
</insert>