oracle mybtis 批量插入

64 阅读1分钟

 <!--批量插入-->
    <insert id="insertList" parameterType="java.util.List">
        INSERT INTO
        SH_YJ_XX (FPHM,FPDM,CJHM,CGSSBUUID,SBMJHHJ,FPXXCJFY,KPRQ,DZ,DH,CPXH,YJYY,FPZTBS,NSRSBH)
        <foreach item="item" index="index" collection="list" separator="union all">
            (
            SELECT
            #{item.fphm,jdbcType=VARCHAR},
            #{item.fpdm,jdbcType=VARCHAR},
            #{item.cjhm,jdbcType=VARCHAR},
            #{item.cgssbuuid,jdbcType=VARCHAR},
            #{item.sbmjhhj,jdbcType=NUMERIC},
            #{item.fpxxcjfy,jdbcType=NUMERIC},
            #{item.kprq,jdbcType=TIMESTAMP},
            #{item.dz,jdbcType=VARCHAR},
            #{item.dh,jdbcType=VARCHAR},
            #{item.cpxh,jdbcType=VARCHAR},
            #{item.yjyy,jdbcType=NUMERIC},
            #{item.fpztbz,jdbcType=VARCHAR},
            #{item.nsrsbh,jdbcType=VARCHAR}
            FROM DUAL
            )
        </foreach>

    </insert>