高效率批量添加与批量删除

<insert id="saveExcel" parameterType="ArrayList">
INSERT INTO `t_device` (
  `device_serial`,
  `imei`,
  `model`,
  `version`,
  `locate_frequence`,
  `create_user`,
  `create_id`,
  `create_date`,
  `modify_user`,
  `modify_id`,
  `modify_date`

) 
VALUES
<foreach collection="list" item="item" index="index" separator=",">
  (
    #{item.deviceSerial},
    #{item.imei},
    #{item.model},
    #{item.version},
    #{item.locateFrequence},
    #{item.createUser},
    #{item.createId},
    #{item.createDate},
    #{item.modifyUser},
    #{item.modifyId},
    #{item.modifyDate}
    
  ) 
</foreach>

</insert>

collection为需要遍历的数据类型,index为下标,separator为每行值完了后添加逗号

<delete id="deleteBatch">
delete from t_user_bookshelf where id in
<foreach item="id" collection="array" open="(" separator=","
close=")">
#{id}
</foreach>

</delete>

open为开始加(   ,close为结束加  )