1、批量插入,使用INSERT ALL进行批量插入,如
<insert id="batchInsert" parameterType="java.util.List">
insert all
<foreach collection="list" item="item" index="index" separator="">
into purchase_order_item (<include refid="orderItemFileds" />)
values( #{item.elsAccount,jdbcType=VARCHAR} , #{item.toElsAccount,jdbcType=VARCHAR}
</foreach>
SELECT 1 FROM DUAL
<insert id="batchInsert" parameterType="java.util.List">
insert all
<foreach collection="list" item="item" index="index" separator="">
into purchase_order_item (<include refid="orderItemFileds" />)
values( #{item.elsAccount,jdbcType=VARCHAR} , #{item.toElsAccount,jdbcType=VARCHAR}
</foreach>
SELECT 1 FROM DUAL
</insert>
2、分页
mysql使用的分页是limit m,n,而oracle则使用的是rownum