?? login1.asp
字號:
<%Response.Buffer=true%>
<body bgcolor="#CCCCCC">
<%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>
<font color="#0033FF">歡迎來到本站熱門論壇</font></strong></font></p>
<div align="center"><center><table border="0" cellpadding="4" cellspacing="7" width="453"
height="15" bgcolor="#FFFFFF">
<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">
<a href="index.asp">返回本站主頁</a> </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 "我們的數(shù)據(jù)庫中沒有查到您的姓名，請先注冊新用戶。"
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
%>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -