新增批量处理数据
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>