場景分類
- 單頁面、特定用戶:直接在頁面驗證帳密,通過顯示連結。
- 單頁面、多用戶:資料庫驗證,通過顯示內容。
- 多頁面、多用戶 (角色基礎):統一登入頁 + Session/Cookie 驗證攔截器。
方案一:Cookie 認證 (簡易、無伺服器狀態)
登入頁 (login.asp)
<%
If Request.Form("btnLogin") = "登入" Then
Dim conn, rs, sql, username, password
username = Request.Form("username")
password = Request.Form("password")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=.;Initial Catalog=MyDB;UID=sa;PWD=xxx"
sql = "SELECT UserID, RoleID FROM Users WHERE Username=? AND PasswordHash=?"
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = sql
cmd.Parameters.Append cmd.CreateParameter("@u", 200, 1, 50, username) ' adVarChar
cmd.Parameters.Append cmd.CreateParameter("@p", 200, 1, 64, password) ' 假設已雜湊
Set rs = cmd.Execute
If Not rs.EOF Then
Response.Cookies("AuthUser") = rs("UserID")
Response.Cookies("AuthRole") = rs("RoleID")
Response.Cookies("AuthUser").Expires = DateAdd("h", 2, Now()) ' 2 小時
Response.Cookies("AuthRole").Expires = DateAdd("h", 2, Now())
Response.Redirect Request.QueryString("returnUrl") ' 支援登入後回跳
Else
errMsg = "帳號或密碼錯誤"
End If
rs.Close: Set rs = Nothing
conn.Close: Set conn = Nothing
End If
%>
<form method="post" action="login.asp?returnUrl=<%=Server.URLEncode(Request.QueryString("returnUrl"))%>">
帳號: <input name="username"><br>
密碼: <input type="password" name="password"><br>
<input type="submit" name="btnLogin" value="登入">
<%If errMsg <> "" Then Response.Write "" & errMsg & ""%>
</form>
受保護頁面頂端引入 (auth_check_cookie.asp)
<%
If Request.Cookies("AuthUser") = "" Then
Response.Redirect "login.asp?returnUrl=" & Server.URLEncode(Request.ServerVariables("URL") & "?" & Request.QueryString)
Response.End
End If
' 可選:角色檢查
' If Request.Cookies("AuthRole") <> "Admin" Then Response.Write "權限不足": Response.End
%>
方案二:Session 認證 (伺服器狀態、支援登入嘗試限制)
Global.asa (Session_OnStart)
<script language="VBScript" runat="server">
Sub Session_OnStart
Session("AuthUser") = ""
Session("AuthRole") = ""
Session("LoginAttempts") = 0
Session("TargetURL") = ""
End Sub
</script>
登入頁 (login.asp) - Session 版
<%
If Request.Form("btnLogin") = "登入" Then
' ... 驗證邏輯同 Cookie 版 ...
If Not rs.EOF Then
Session("AuthUser") = rs("UserID")
Session("AuthRole") = rs("RoleID")
Session("LoginAttempts") = 0
Response.Redirect Session("TargetURL")
Else
Session("LoginAttempts") = Session("LoginAttempts") + 1
If Session("LoginAttempts") >= 3 Then
Response.Redirect "lockout.asp"
Else
errMsg = "帳號或密碼錯誤 (剩餘 " & (3 - Session("LoginAttempts")) & " 次機會)"
End If
End If
End If
%>
受保護頁面攔截 (auth_check_session.asp)
<%
If Session("AuthUser") = "" Then
Session("TargetURL") = Request.ServerVariables("URL") & "?" & Request.QueryString
Response.Redirect "login.asp"
Response.End
End If
%>
登出頁 (logout.asp)
<%
Response.Cookies("AuthUser").Expires = DateAdd("d", -1, Now())
Response.Cookies("AuthRole").Expires = DateAdd("d", -1, Now())
Session.Abandon
Response.Redirect "index.asp"
%>
最佳實務建議
- 密碼不可明文儲存,採用 BCrypt/Argon2/PBKDF2 雜湊 (ASP 可呼叫 COM 元件或 Web Service)。
- Cookie 設定
HttpOnly=True, Secure=True (HTTPS), SameSite=Strict。
- Session 逾時設定合理值 (預設 20 分鐘),
Session.Timeout = 30。
- 敏感操作 (刪除、匯出) 增加 CSRF Token 驗證。
- 記錄登入/失敗/權限拒絕日誌,定期稽核。