两者不同
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;