MyBatis Oracle批量插入

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

tiegenZ

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

阅读量586

点赞数

分类专栏： MyBatis 文章标签： MyBatis Oracle批量插入

本文链接：https://blog.csdn.net/tiegenZ/article/details/69666659

版权

MyBatis 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

<insert id="insertPushData" parameterType="java.util.List">
       insert into #[use_database_name]tab_Xy_data
                   (XyDataId,
                    OrderNo,
                    NodeDesc,
                    DeliverStatus ,
                    SecondStatus,
                    City,
                    County,
                    NodeType,
                    StationCode,
                    StationName,
                    Contacter,
                    ContactPhone,
                    NextCity,
                    NextNodeType,
                    NextStationCode,
                    NextStationName,
                    create_time,
                    new_type
                    )
    SELECT #[use_database_name]seq_for_pushXinyi.nextval,A.*  /*序列前记得带表名*/
    FROM (
    <foreach item="itm" index="index" collection="list" separator="UNION ALL">
        select
        #{itm.OrderNo,jdbcType=VARCHAR} OrderNo ,
        #{itm.NodeDesc,jdbcType=VARCHAR} NodeDesc,
        #{itm.DeliverStatus,jdbcType=VARCHAR} DeliverStatus,
        #{itm.SecondStatus,jdbcType=VARCHAR} SecondStatus,
        #{itm.City,jdbcType=VARCHAR} City ,
        #{itm.County,jdbcType=VARCHAR} County,
        #{itm.NodeType,jdbcType=VARCHAR} NodeType ,
        #{itm.StationCode,jdbcType=VARCHAR} StationCode,
        #{itm.StationName,jdbcType=VARCHAR} StationName,
        #{itm.Contacter,jdbcType=VARCHAR} Contacter,
        #{itm.ContactPhone,jdbcType=VARCHAR} ContactPhone,
        #{itm.NextCity,jdbcType=VARCHAR} NextCity,
        #{itm.NextNodeType,jdbcType=VARCHAR} NextNodeType,
        #{itm.NextStationCode,jdbcType=VARCHAR} NextStationCode,
        #{itm.NextStationName,jdbcType=VARCHAR} NextStationName,
        sysdate as create_time,
        '未推送' as new_type
        FROM dual
    </foreach>
    )A
</insert>

-----------------------------------------------------------------------------------