mybatis 批量删除

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>