<%LogTime=Now()%>
<%Num1=Cstr(Hour(LogTime)) & Cstr(Minute(LogTime)) & Cstr(Second(LogTime))& Cstr(Int(Rnd*10000))%>
<%
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 "口令出错，请检查是否大小写不对。
"
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
%>
|
