一个基于web的QQ程序 2(xml+asp)

用于处理xmlhttp请求的asp程序,看看时不是很简单啊!??

 1on error resume next   
 2Response.ContentType="text/xml"   
 3if Request.ServerVariables("REQUEST_METHOD")="POST" then   
 4set req=Server.CreateObject("Microsoft.XMLDOM")   
 5req.async=false   
 6req.load(Request)   
 7set conn=server.CreateObject("adodb.connection")   
 8conn.Open "odbc","uid","password"   
 9sql="select uid,id,sex from uidinfo order by id desc"   
10set rs=server.CreateObject("adodb.recordset")   
11rs.Open sql,conn   
12Response.Write "
13<?xml version=""1.0"" ?>
14"   
15Response.Write "

<mess>"
if not rs.EOF then
do while not rs.EOF
Response.Write "<id>"&amp;trim(rs("id"))&amp;"</id><uid>"&amp;trim(rs("uid"))&amp;"</uid><sex>"&amp;trim(rs
("sex"))&amp;"</sex>"
rs.MoveNext
loop
else
Response.Write "<id>k</id><uid></uid><sex></sex>"
end if
Response.Write "</mess>

1"   
2if rs.State=1 then rs.Close   
3set rs=nothing   
4conn.Close   
5set conn=nothing   
6set req=nothing   
7end if   
Published At
Categories with Web编程
Tagged with
comments powered by Disqus