mybatis批量插入
<!-- 座位的批量插入 -->
<insert id ="insertSeats" parameterType="java.util.List" >
insert into pf_seat
(id, cla_code, row_num, col_num, only_code, seat_num, is_there)
values
<foreach collection ="list" item="item" index= "index" separator =",">
(
#{item.id},
#{item.claCode},
#{item.rowNum},
#{item.colNum},
#{item.onlyCode},
#{item.seatNum},
#{item.isThere}
)
</foreach>
</insert >