批量操作数据

1.批量插入

 <insert id="batchinsertPatinetGroupRel" parameterType="java.util.List">
 insert into patient_group_rel(
        group_id,
        patient_id,
        id
    )values
     <foreach collection="list" item="item" index="index" separator=",">
    (
        #{item.group_id},
        #{item.patient_id},
        #{item.id}
    )
    </foreach>
 </insert>

2.批量删除

<delete id="batchDeleteGroupPatients" parameterType="java.util.List">
    delete 
    from
    patient_group_rel
    <foreach collection="list" item="item" index="index" >
    where 
    group_id=#{item.group_id} 
    and 
    patient_id=#{item.patient_id}
    </foreach> 
 </delete>