Mybatis 批量插入多条数据,使用场景:导入多条数据

Mybatis 批量插入多条数据,使用场景:导入多条数据

接口代码:

void batchInsertCapacity(@Param("list")List<Map<String, Object>> metadbmaplist);

SQL:

<insert id="batchInsertCapacity">
        insert into index_prodcut
        (
        ID,
        ORG_ID,
        TEXT1,
        TEXT2,
        TEXT3,
        PLAN_NUM,
        ACTUAL_NUM,
        RATIO,
        SDATE_START,
        SDATE,
        REMARKS,
        CUSER_ID,
        CDATE,
        INDEX_TYPE,
        DEL_FLAG,
        STATUS
        )
        <foreach collection="list" item="item" index="index"
                 separator="UNION ALL">
            (SELECT
            #{item.id,jdbcType=VARCHAR},
            #{item.org_id,jdbcType=VARCHAR},
            #{item.text1,jdbcType=VARCHAR},
            #{item.text2,jdbcType=VARCHAR},
            #{item.text3,jdbcType=VARCHAR},
            #{item.plan_num,jdbcType=VARCHAR},
            #{item.actual_num,jdbcType=VARCHAR},
            #{item.ratio,jdbcType=VARCHAR},
            #{item.sdate_start},
            #{item.sdate},
            #{item.remarks,jdbcType=VARCHAR},
            #{item.cuser_id,jdbcType=VARCHAR},
            #{item.cdate},
            #{item.index_type,jdbcType=VARCHAR},
            ‘0‘,
            ‘0‘
            FROM
            dual)
        </foreach>
    </insert>

相关推荐