mybatis 批量删除
<!--批量删除集团-->
<delete id="batchDelete" parameterType="java.util.List">
delete sgc from s_group_company sgc
where sgc.id in
<foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
<if test="item.id!=null">
#{item.id,jdbcType=BIGINT}
</if>
</foreach>
</delete>