oracle的批量插入mybatis配置文件如下:
<insert id="batchAdd" parameterType="java.util.ArrayList">
INSERT INTO TB_TRAINS_ROLE_MENU_FUNC(RID,MID,FID)
<foreach collection="list" item="roleMenuFun" separator="union all">
select #{roleMenuFun.roleId},#{roleMenuFun.menuId},#{roleMenuFun.funId} from dual
</foreach>
</insert>
mysql的批量插入mybatis配置文件如下:
<insert id="batchAdd" parameterType="java.util.ArrayList">
INSERT INTO TB_V_MANAGE_ROLE_MENU_FUNC(RID,MID,FID)
VALUES
<foreach collection="list" item="roleMenuFun" separator=",">
(#{roleMenuFun.roleId},#{roleMenuFun.menuId},#{roleMenuFun.funId})
</foreach>
</insert>