在sql语句中判断username和mail的值是否为空，为空的就不读去他，代码如下set rs=server.CreateObject("adodb.recordset") rs.Open "select * from b1 where username"" and mail"" order by id desc ",conn,1,1 Do Until rs.eof response.write.
