需要演示,所以临时写了一个,主要是介绍原理:
<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="driver={SQL Server};server=192.168.1.128;UID=sa;PWD=123;database=123"
conn.Open connstr
if Request("name")="" then
response.write( "<FORM METHOD=POST ACTION=''>查询名:<INPUT TYPE='text' NAME='name'><INPUT TYPE='submit' value='ok'></FORM>")
Response.End
else
name =Request("name")
sql = "select * from adm where suid='"&name&"'"
Set rs= conn.execute(sql)
response.write( "<table width='80%' border='1' align='center'><TR><TH>id</TH><TH>name</TH><TH>password</TH><TH>level</TH></TR>")
While Not rs.eof
%>
<TR>
<TD align='center'><% =rs("sid")%></TD>
<TD align='center'><% =rs("suid")%></TD>
<TD align='center'><% =rs("spwd")%></TD>
<TD align='center'><% =rs("slevel")%></TD>
</TR>
<%
rs.movenext
wend
end if
%>
</TABLE>