两者不同

1,批量插入

2,主键自增

3,分页不同

4,。。。。。。待补充

批量插入

mysql:

<insert id="batchinsertSelective" parameterType="tPortalAdjunctEntity" >
insert into t_portal_adjunct (merno, type,type_id, file_id, file_name)
values
<foreach collection ="list" item="info" index= "index" separator =",">
(#{info.merno}, #{info.type},
#{info.type_id}, #{info.file_id}, #{info.file_name})
</foreach >
</insert>

oracle:

begin
<foreach collection="list" item="info" index="index"
separator=";"> <!--分号 注意-->
insert INTO T_101_USERS(ID,USERID,USERNAME)
VALUES
(SQ_101.NEXTVAL,#{info.userID, jdbcType=VARCHAR}, #{info.name, jdbcType=VARCHAR})
</foreach>
;end;

04-25 20:22