【MyBatis学习笔记】10. MyBatis批量插入和批量删除

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();