chkpwd.asp:共用驗證邏輯,所有受保護頁面 `` 引入。erp.asp:受保護業務頁面範例。logout.asp:清除 Session 並導回首頁。<%
'=== 登入驗證共用模組 ===
Option Explicit
Response.Buffer = True
' 初始化 Session 狀態
If IsEmpty(Session("Passed")) Then Session("Passed") = False
If Not Session("Passed") Then
Dim username, pwd, conn, rs, sql, errMsg
username = Trim(Request.Form("UserName"))
pwd = Trim(Request.Form("UserPwd"))
If username = "" Then
errMsg = "請輸入帳號與密碼"
Else
'--- 參數化查詢防注入 ---
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Driver={SQL Server};Server=192.168.1.3;UID=sa;PWD=;Database=zcmrs"
conn.Open
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText = "SELECT username, password FROM erpuser WHERE username = ?"
cmd.Parameters.Append cmd.CreateParameter("@user", 200, 1, 50, username) ' adVarChar, adParamInput
rs.Open cmd
If rs.EOF Then
errMsg = "帳號不存在或密碼錯誤"
ElseIf pwd <> rs("password") Then ' 實務應比對雜湊值
errMsg = "密碼錯誤"
Else
' 登入成功
Session("Passed") = True
Session("UserName") = rs("username")
' Session("UserID") = rs("UserID") ' 權限標識
errMsg = ""
End If
rs.Close: Set rs = Nothing
conn.Close: Set conn = Nothing
End If
' 顯示登入表單
If Not Session("Passed") Then
%>
<!DOCTYPE html>
<html><head><title>ERP 系統登入</title>
<style>body{font:12px sans-serif;background:#f0f0f0}.box{width:360px;margin:80px auto;padding:20px;background:#fff;border:1px solid #ddd}.err{color:#c00}.btn{width:100px}</style>
</head><body>
<div class="box">
<h3 style="text-align:center;margin-top:0">ERP 系統登入</h3>
<form method="post" action="<%=Request.ServerVariables("PATH_INFO")%>">
<p>帳號:<input name="UserName" size="20" maxlength="20" required /></p>
<p>密碼:<input name="UserPwd" type="password" size="20" maxlength="20" required /></p>
<p class="err"><%=errMsg%></p>
<p><button class="btn" type="submit">登入</button> <button class="btn" type="button" onclick="location='register.asp'">註冊</button></p>
</form>
</div>
</body></html>
<%
Response.End ' 阻止繼續執行後續頁面
End If
End If
%>
<!--#include file="chkpwd.asp"-->
<!DOCTYPE html>
<html><head><title>ERP 查詢系統</title></head><body>
<div style="padding:10px;border:1px solid #001;background:#FFCCFF;font-weight:bold">
歡迎使用 ERP 查詢系統,目前登入用戶:<%=Session("UserName")%>
<a href="logout.asp" style="margin-left:20px">登出系統</a>
</div>
<!-- 業務內容 -->
</body></html>
<%
Session("Passed") = False
Session("UserName") = ""
Session.Abandon() ' 徹底銷毀 Session
Response.Redirect "index.asp"
%>
Classic ASP 登入機制建議遷移至 **ASP.NET Core Identity** 或 **IdentityServer4**,獲得 OpenID Connect/OAuth2 標準支援、多因子驗證、Token 管理等企業級功能。