适用类型:oracle数据库(MySQL数据库不适用),且插入数据是一个list集合。
mapper.xml文件格式:
<insert id="方法名" parameterType="实体类对象相对路径" >
insert into 表名(
id,
name1,
name2,
name3,
name4,
name5,
DELETE_FLAG
)(
<foreach collection="集合名称" item="index" index= "index" separator ="UNION ALL">
select
#{index.id} as id,
#{index.name1} as name1,
#{index.name2} as name2,
#{index.name3} as name3,
#{index.name4} as name4,
#{index.name5} as name5,
#{index.deleteFlag} as deleteFlag
from dual
</foreach>
)
</insert>