📄 usercheck.asp
字号:
<%@ Language=VBScript %>
<%option explicit%>
<% on error resume next
dim conn,rs,sql,i,connstr
connstr="dbq=" & server.MapPath("mdb/bookshop.mdb") & ";driver={microsoft access driver (*.mdb)};"
set conn=server.CreateObject("adodb.connection")
conn.Open connstr
set rs=server.CreateObject("adodb.recordset")
sql="select * from guest where nicename='" & Request.Form("user1") & "'" & " and password='" & Request.Form("user2") & "'"
'sql=" select * from guest"
set rs=conn.Execute (sql)
'Response.Write rs.RecordCount
if rs.eof then
Response.Write "查无此人!"
Response.End
else%>
<html>
<head>
<style>
<!--
.FONT {
COLOR: navy; FONT-FAMILY: "宋体"; FONT-SIZE: 12px; LINE-HEIGHT: 14px
}
.3dfont {
FILTER: glow(color=ffffff,strength=0) shadow(color=aaaaaa,direction:135); POSITION: relative; WIDTH: 100%
}
-->
</style>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>用户资料</title>
</head>
<body>
<p> </p>
<form method="POST" action="userchange.asp">
<table border="1" width="53%" align="center">
<tr>
<td width="100%" colspan="2" class="FONT"><font face="宋体">您的资料： </font></td>
</tr>
<tr>
<td width="24%" class="FONT">昵称：</td>
<td width="76%" class="FONT"><%=rs(1)%> <input type="hidden" name="nicename" size="20" value="<%=rs(1)%>"></td>
</tr>
<tr>
<td width="24%" class="FONT"><font face="宋体">姓名：</font></td>
<td width="76%" class="FONT"><input type="text" name="name" size="20" value="<%=rs("name")%>"></td>
</tr>
<tr>
<td width="24%" class="FONT"><font face="宋体">联系电话：</font></td>
<td width="76%" class="FONT"><font face="宋体"><input type="text" name="tel" size="20" value="<%=rs("tel")%>"></font></td>
</tr>
<tr>
<td width="24%" class="FONT"><font face="宋体">联系地址：</font></td>
<td width="76%" class="FONT"><font face="宋体"><input type="text" name="addr" size="20" value="<%=rs("addr")%>"></font></td>
</tr>
<tr>
<td width="24%" class="FONT"><font face="宋体">邮编：</font></td>
<td width="76%" class="FONT"><font face="宋体"><input type="text" name="zip" size="20" value="<%=rs("zip")%>"></font></td>
</tr>
<tr>
<td width="24%" class="FONT"><font face="宋体">E_mail:</font></td>
<td width="76%" class="FONT"><font face="宋体"><input type="text" name="email" size="20" value="<%=rs("email")%>"></font></td>
</tr>
<tr>
<td width="24%" class="FONT"><font face="宋体">password:</font></td>
<td width="76%" class="FONT"><input type="text" name="password" size="20" value="<%=rs("password")%>"></td>
</tr>
<tr>
<td width="100%" colspan="2">
<p class="FONT"><font face="宋体">
</font><input type="submit" value="修改" name="B1"><a href="bookright.asp"><font face="宋体">返回</font></a>
</p>
</td>
</tr>
</table>
</form>
</body>
</html>
<% end if%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -