1、背景介绍(jdbc的批量操作)
http://blog.163.com/gaoguang@126/blog/static/22157222007126946348/
2、MyBatis批量新增
<!-- 批量 ,传入一个长度为1000的list -->
<insert id="insertBatch" >
insert into student ( <include refid="Base_Column_List" /> )
values
<foreach collection="list" item="item" index="index" separator=",">
(null,#{item.name},#{item.sex},#{item.address},#{item.telephone},#{item.tId})
</foreach>
</insert>
http://aijuans.iteye.com/blog/1537066
3、MyBatis批量更新
<foreach collection="attendingUsrList" item="model" separator=";">
UPDATE parties SET attending_user_count = #{model.attending_count}
WHERE fb_party_id = #{model.eid}
</foreach>
http://stackoverflow.com/questions/23486547/mybatis-batch-insert-update-for-oracle
备注:该方法在sql总长度超过一定限制时,仍会有性能问题。可以考虑分多次拼装的方式提高性能(500条拼一次)