一句SQL语句就可以解决。delete * from room where roomID='A'放到ASP代码里用Connection对象执行。con.Exection("delete * from room where roomID='A'")