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 >
 

mybatis批量插入

原文：https://www.cnblogs.com/liyanzi/p/12200202.html