mybtatis 批量插入 （orcal）

<insert id="batchAddHotClass" parameterType="java.util.List"  flushCache="true" > 

insert into scs_class_hot( 

scs_ct_id, 

scs_ct_sortno,

scs_ct_name,

scs_ct_fee,

scs_ct_ctname,

scs_ct_areaid,

scs_ct_schoolid,

scs_ct_ctid,

scs_ct_ctype

)

select A.* from (

  <foreach collection="list" item="item" index="index" separator="union all">

   select 

#{item.scs_ct_id}, 

#{item.scs_ct_sortno},

#{item.scs_ct_name},

#{item.scs_ct_fee},

#{item.scs_ct_ctname},

#{item.scs_ct_areaid},

#{item.scs_ct_schoolid},

#{item.scs_ct_ctid},

#{item.scs_ct_ctype}

  from dual

</foreach>

)A

</insert>