<insert id="batchInsert" parameterType="java.util.List">
begin
<foreach collection="list" item="item" index="index">
insert into
CIM_DOMAIN_DICTIONARY (DOMAIN_ID,DOMAIN_NAME,CREATE_USER,CREATE_DATE,
LAST_UPDATE_USER,LAST_UPDATE_DATE,EXT1, EXT2,
EXT3)
values(
#{item.domainId,jdbcType=VARCHAR},
#{item.domainName,jdbcType=VARCHAR},
#{item.createUser,jdbcType=VARCHAR},
SYSDATE,
#{item.lastUpdateUser,jdbcType=VARCHAR},
SYSDATE,
#{item.ext1,jdbcType=VARCHAR},
#{item.ext2,jdbcType=VARCHAR},
#{item.ext3,jdbcType=VARCHAR});
</foreach>
end;
</insert>
<insert id="batchInsert" parameterType="java.util.List">
INSERT INTO CIM_DOMAIN_DICTIONARY
(DOMAIN_ID,DOMAIN_NAME,CREATE_USER,CREATE_DATE,
LAST_UPDATE_USER,LAST_UPDATE_DATE,EXT1, EXT2, EXT3) (
<foreach collection="list" item="item" separator="union all"> select
#{item.domainId,jdbcType=VARCHAR},
#{item.domainName,jdbcType=VARCHAR},
#{item.createUser,jdbcType=VARCHAR},
SYSDATE,
#{item.lastUpdateUser,jdbcType=VARCHAR}, SYSDATE,
#{item.ext1,jdbcType=VARCHAR},
#{item.ext2,jdbcType=VARCHAR},
#{item.ext3,jdbcType=VARCHAR} from dual
</foreach>
)
</insert>