mybatis下执行orcl批量插入,以常用日志表为例
<insert id="insertBatch">
insert into LOG (ID,ACT ,CONTENT,CREATE_TIME )
SELECT S_LOG.NEXTVAL ID, t.*
FROM(
<foreach collection="list" item="log" index="index" separator="UNION ALL">
SELECT
#{log.act} ACT, #{log.content} CONTENT,sysdate CREATE_TIME,
FROM dual
</foreach>)t
</insert>