1.批量插入

INSERT   INTO
 
    items(name,city,price,number,picture)

    VALUES

    ('耐克运动鞋','广州',500,1000,'003.jpg'),

    ('耐克运动鞋2','广州2',500,1000,'002.jpg');

借鉴文章

2.批量删除

DELETE FROM t_leave_info WHERE leave_info_id IN (640,634,633);

借鉴文章

3.mybatis批量操作

<insert id="addIndexCard" parameterType="java.util.List">
    insert into index_card (title, statistical,unit,card_column,index_id) values
    <foreach collection="list" open="" close="" separator="," item="item" index="index">
        (#{item.title}, #{item.statistical}, #{item.unit}, #{item.cardColumn}, #{item.indexId})
    </foreach>
</insert>

借鉴文章