mybatis批量查询

<foreach collection="list" item="item" open="(" separator="," close=")">
			#{item}
		</foreach>

　　批量删除

<delete id="delByIds" parameterType="java.lang.String">
        DELETE FROM trust_ip_segment
        WHERE
            id in
            <foreach collection="array" item="item" index="index" separator="," open="(" close=")">
                #{item}
            </foreach>

    </delete>