Sql字符串参数批量操作--- foreach

批量删除tenantId数组

String[] tenantIds = ids.split(",");
tenantService.deleteTenant(tenantIds);


<delete id="deleteTenant" parameterType="java.lang.String">
    delete from tenant WHERE tenantId in
      <foreach collection="tenantIds" index="index" item="tenantId" open="(" separator="," close=")">
         #{tenantId}
      </foreach>
</delete>