📄 login1.asp
字号:
<%Response.Buffer=true%>
<body bgcolor="#FBF0C8">
<%LogTime=Now()%>
<%Num1=Cstr(Hour(LogTime)) & Cstr(Minute(LogTime)) & Cstr(Second(LogTime))& Cstr(Int(Rnd*10000))%>
<form method="POST" action="login1.asp">
<p> </p>
<p> <font size="6" color="#FF0000"><strong>
ASP 自由论坛</strong></font></p>
<div align="center"><center><table border="0" cellpadding="4" cellspacing="7" width="453"
height="15" bgcolor="#B9BEFB">
<tr>
<td width="57" height="1"></td>
<td width="312" height="1">用 户 名:<input type="text" name="name" size="20"></td>
<td width="59" height="1"></td>
</tr>
<tr>
<td width="57" height="11"></td>
<td width="312" height="11">用户密码:<input type="password" name="pass" size="20"></p>
<p><input type="hidden" name="No" value=<%=Num1%>></td>
<td width="59" height="11"></td>
</tr>
<tr>
<td width="57" height="6"></td>
<td width="312" height="6"> <input type="submit" value="登陆论坛"
name="B1"> <input type="reset" value="复原" name="B2"> </td>
<td width="59" height="6"></td>
</tr>
<tr>
<td width="453" height="4" colspan="3"> 未注册的用户请先 <a href="useradd1.asp">注册新用户</a>
<a href="adminlogin.asp">管理员入口</a></td>
</tr>
</table>
</center></div>
</form>
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Connstr="DBQ="+server.mappath("bbspp1.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;"
Conn.Open connstr
%>
<%
B1=Request("B1")
If B1="登陆论坛" Then
sql="SELECT * FROM 用户表 WHERE 用户名='" & Request("name") & "'"
Set Rs=conn.Execute(sql)
If Rs.Bof OR Rs.Eof Then
Response.Write "我们的数据库中没有查到您的姓名，请先注册新用户。"
Else
If Request("pass")<>Rs("密码") Then
Response.Write "口令出错，请检查是否大小写不对。<br>"
else%>
<%sql="UPDATE 用户表 SET 临时身份=" & Request("No") & " WHERE 用户名='" & Request("name") & "'"
conn.Execute sql
conn.close%>
<%Response.Redirect "vew.asp?No=" & Request("No") & " "%>
<%End If
End If
End If
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -