<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>