insert语句 foreach 、虚表的使用 mybatis_insert语句使用《foreach》

<insert id="saveEoceonfirmDetail" parameterType="java.util.List">
INSERT INTO OMS_OD_STOCKIN_ITEMS
  (ID,
   ORDER_ID,
   ORDER_CODE,
   GOODS_CODE,
   GOODS_NAME,
   ACCEPTABLE_QTY,
   STOCKIN_DATE,
   CREATED_BY,
   CREATED_TIME,
   VERSION,
   IS_INACTIVE,
   DEFECTIVE_QTY)
   <foreach collection="list" item="item" index="index" open="(" close=")" separator="UNION ALL">   //传入的参数是List<Map<String, Object>>
(SELECT
   #{item.id},
   #{item.entry_order_id},
   #{item.entry_order_code},
   #{item.goods_code},
   #{item.goods_name},
   #{item.acceptable_qty},
   <if test="item.stockin_date !=null and item.stockin_date !=''">
TO_TIMESTAMP( #{item.stockin_date},'YYYY-MM-DD HH24:MI:SS') ,
   </if>
   <if test="item.stockin_date ==null or item.stockin_date ==''">
sysdate,
   </if> 
   'oms',
   sysdate,
   0,
   0,
   #{item.defective_qty}
FROM dual)  //虚表
</foreach>

</insert>