<%
if not IsEmpty(Session("cust—id")) and Len(Session("cust—id"))>0 then
' 用戶登錄後指向主頁.
Response.Redirect("navigation/dashbrd.asp")
' 在此添入真正的主頁URL.
end if
bLogin = False
' 設置標志.
bError = False
if IsEmpty(Request("uid")) or Len(Request("uid")) = 0 or IsEmpty(Request("pwd")) or Len(Request("pwd")) = 0 then
' 檢查空字符.
bLogin = True
else
----------------------------------------------------------------------------------------------------------------
' 檢驗數據庫保存密碼表中是否有該用戶.
"select * from customer WHERE cust—id=′ " & request("uid") &"′ and ′cust—pwd=′"& request(″pwd″) &"′"
' 連接數據庫,其中request(″uid″)和request(″pwd″) 為本頁html中表單中的用戶名和密碼的text.
gbFound = False
----------------------------------------------------------------------------------------------------------------
if not rsCust.BOF and not rsCust.EOF then
gbFound = True
end if
if gbFound then
Session("cust—id") = rsCust.Fields("cust—id")
' 在session變量中記錄有用的信息.此項為數據庫中用戶名.
Session("cust—pwd") = rsCust.Fields("cust—pwd")
' 此項為數據庫中用戶密碼.
Session("power") = rsCust.Fields("power")
' 此項為數據庫中用戶權限,可選.
' rsCust.ActiveConnection.Execute ("update customer set cust—login = ′ "& Now &"′ where cust_id = "& Session("cust—id") &"")
' 更新最後登錄時間,可選.
Response.Redirect("navigation/dashbrd.asp")
' 真正主頁URL.
Else
′UID and password not found
bError = True bLogin = True
end if
rsCust.Close
' 關閉記錄.
mycn—login.Close
set mycn—login=Nothing
end if
%>
----------------------------------------------------------------------------------------------------------------
' 登錄頁面.
<form name="login" action="default.asp" method="post" target="—top">
' 在html中加入FORM,並設為自發送頁.action後面要接本頁的URL,這樣,即使用戶登錄錯誤,在本頁即可獲得提示,而無須再返回前一頁登錄.
input name="uid" size="10"maxlength="10" style="HEIGHT: 21px; WIDTH: 101px">
<input name="pwd"type="password" size="10" maxlength="10">
[1]