getcustomer.asp

来自「ajax实例大全ajax实例大全ajax实例大全」· ASP 代码 · 共 21 行

<%
sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="
sql=sql & request.querystring("q")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("ajaxjiaocheng.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open sql, conn
Response.CharSet = "GB2312"
if not rs.EOF then
response.write "<li>编号："&rs(0)&"</li>"
response.write "<li>姓名："&rs(1)&"</li>"
response.write "<li>点击："&rs(2)&"</li>"
response.write "<li>介绍："&rs(3)&"</li>"
end if
rs.close
set rs = nothing
conn.close
set conn = nothing
%>