oracle 批量插入 mybatis实现
<insert id="insert" parameterType="java.util.List">
insert into DARZ_YW
(
ID,
DAID,
CZMC,
CZR,
CZRQ,
DAZT
)
<foreach collection="list" item="idem" index= "index" separator="union all">
(
SELECT
#{idem.aJRzId},
#{idem.daId},
#{idem.czmc},
#{idem.userDm},
to_date(#{idem.nowDate,jdbcType=DATE},'yyyy-mm-dd hh24:mi:ss'),#{idem.dazt}
FROM DUAL
)
</foreach>
</insert>
亲测有效,入参为list<map>