數據庫是oracle , 妳只能先查詢然後在插入。我用的是mybatis
insert into cc_facinputtrack
(faccode,statdate,filltercom,inputstate,inputdate)
(
<foreach collection="list" item="item" index="index"
separator="union all">
select
#{item.faccode,jdbcType=VARCHAR},#{item.statdate,jdbcType=TIMESTAMP},
#{item.filltercom,jdbcType=TIMESTAMP},
#{item.inputstate,jdbcType=VARCHAR},#{item.inputdate,jdbcType=TIMESTAMP}
from dual
</foreach>
)