MyBatis批量插入
mapper
<insert id="batchInsert" parameterType="java.util.List" >
insert into t_goods (title, sub_title,original_cost,current_price,discount,is_free_delivery,category_id)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.title}, #{item.sub_title},#{item.original_cost},#{item.current_price},#{item.discount},#{item.is_free_delivery},#{item.category_id})
</foreach>
</insert>
代码
session=MyBatisUtils.openSession();
List list=new ArrayList();
for(int i=0;i<10000;i++){
Goods goods=new Goods();
goods.setTitle("测试商品");
goods.setSubTitle("测试子标题");
goods.setOriginalCost(200f);
goods.setCurrentPrice(100f);
goods.setDiscount(0.5f);
goods.setIsFreeDelivery(1);
goods.setCategoryId(43);
list.add(goods);
}
session.insert("goods.batchInsert",list);
批量插入数据的局限:
1.无法获得插入数据的id
2.批量生成的SQL太长, 可能会被服务器拒绝
MyBatis批量删除
mapper
<delete id="batchDelete" parameterType="java.util.List">
delete from t_goods where goods_id in
<foreach collection="list" item="item" index="index" open="(" close=")" separator="," >
#{item}
<foreach>
</delete>
代码
session=MyBatisUtils.openSession();
List list=new ArrayList();
list.add(1920);
list.add(1921);
list.add(1922);
session.delete("goods.batchDelete",list);
session.commit();