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>
