mybatis 批量处理数据

新增批量处理数据
insert 允许 values(),(),()

 <insert id="insertSelective" parameterType="java.lang.String" >
    insert into T_Alarm_Group_Rel_Param (AlarmGroupID,AlarmID) values
      <foreach collection="array" item="person" separator=",">
        (#{alarmgroupid},#{person})
      </foreach>
  </insert>

删除批量处理数据

<where>
      AlarmGroupID=#{alarmgroupid} and AlarmID in
      <foreach collection="array" index="index" item="item" open="(" separator="," close=")">
        #{item}
      </foreach>
</where>

修改批量数据

 <foreach collection="list" item="item" index="index" open="" close="" separator=";">
               update table
               <set>
                 state=${item.state}
               </set>
               where id = ${item.id}
        </foreach>