Mybatis使用Oracle批量插入回写id

1.方法传入List数据,再使用序列方式生成待插入数据集合，相当于序列+List=待插入的List

<!-- 批量获取待插入预算表集合包含主建ID -->
<select id="initInsertBudgetBatch" parameterType="jp.co.mitsuifudosan.financial.entity.BudgetPackageSearchDTO" resultType="jp.co.mitsuifudosan.financial.entity.BudgetPackageSearchDTO">
    select MFS_BUDGET_SEQ.nextval as bid, t.* from (
    <foreach collection="mfsBudgetList" index="index" item="mb" separator="union all">
        select
            #{mb.title} as title, #{mb.bpid} as bpid, #{mb.filler} as filler,#{mb.version} as version,'未冻结' as status,'未发布' as definestatus,#{mb.creater} as creater,
            to_date(#{mb.createtime}, 'yyyy-mm-dd hh24:mi:ss' ) as createtime, #{mb.defineactionuser} as defineactionuser,
            to_date(#{mb.createtime}, 'yyyy-mm-dd hh24:mi:ss' ) as definelastmodifytime
        from dual
    </foreach>