萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP 程式設計

ASP 會員註冊功能完整實作:表單驗證、密碼確認、資料庫寫入

資料庫準備

建立 SQL Server / Access 資料表 Users:

CREATE TABLE Users (
  UserID      AUTOINCREMENT PRIMARY KEY,
  Username    VARCHAR(50)  NOT NULL UNIQUE,
  Password    VARCHAR(100) NOT NULL,  -- 實務應存雜湊值
  Email       VARCHAR(100) NOT NULL,
  Homepage    VARCHAR(200),
  Note        MEMO,
  RegDate     DATETIME DEFAULT NOW(),
  LastLogin   DATETIME,
  IsActive    BIT DEFAULT 1
)

註冊頁面 (register.asp) - 前端表單

<%@ LANGUAGE="VBScript" CODEPAGE="65001" %>
<% Response.AddHeader "Content-Type", "text/html; charset=utf-8" %>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>會員註冊</title>
  <style>
    .form-group { margin-bottom: 1rem; }
    label { display: block; margin-bottom: 0.3rem; font-weight: bold; }
    input[type=text], input[type=password], input[type=email] { width: 100%; max-width: 300px; padding: 0.5rem; }
    .error { color: red; margin-top: 0.5rem; }
    .success { color: green; }
  </style>
</head>
<body>
  <h1>會員註冊</h1>
  
  <% If Request("msg") <> "" Then %>
    <div class="<%=IIf(Request("status")="ok","success","error")%>"><%=Request("msg")%></div>
  <% End If %>
  
  <form method="post" action="register_process.asp">
    <div class="form-group">
      <label>帳號 (Username)</label>
      <input type="text" name="username" required maxlength="50">
    </div>
    
    <div class="form-group">
      <label>密碼</label>
      <input type="password" name="password" required minlength="6" maxlength="20">
    </div>
    
    <div class="form-group">
      <label>確認密碼</label>
      <input type="password" name="confirm_password" required>
    </div>
    
    <div class="form-group">
      <label>Email</label>
      <input type="email" name="email" required maxlength="100">
    </div>
    
    <div class="form-group">
      <label>個人網頁 (選填)</label>
      <input type="url" name="homepage" maxlength="200" placeholder="https://">
    </div>
    
    <div class="form-group">
      <label>備註 (選填)</label>
      <textarea name="note" rows="4" cols="50"></textarea>
    </div>
    
    <button type="submit">送出註冊</button>
    <a href="login.asp">已有帳號?去登入</a>
  </form>
</body>
</html>

處理頁面 (register_process.asp) - 後端邏輯

<%
Response.AddHeader "Content-Type", "text/html; charset=utf-8"

Dim username, password, confirmPwd, email, homepage, note, conn, rs, sql, msg, status

' 1. 取得並清理輸入
username = Trim(Request.Form("username"))
password = Trim(Request.Form("password"))
confirmPwd = Trim(Request.Form("confirm_password"))
email = Trim(Request.Form("email"))
homepage = Trim(Request.Form("homepage"))
note = Trim(Request.Form("note"))

' 2. 伺服器端驗證
If username = "" Or password = "" Or confirmPwd = "" Or email = "" Then
  msg = "帳號、密碼、確認密碼、Email 均為必填。"
  status = "err"
ElseIf password <> confirmPwd Then
  msg = "兩次輸入的密碼不一致。"
  status = "err"
ElseIf Len(password) < 6 Then
  msg = "密碼長度至少 6 碼。"
  status = "err"
ElseIf InStr(email, "@") = 0 Or InStr(email, ".") = 0 Then
  msg = "Email 格式不正確。"
  status = "err"
Else
  ' 3. 連接資料庫檢查帳號是否存在
  Set conn = Server.CreateObject("ADODB.Connection")
  conn.Open "Provider=SQLOLEDB;Data Source=.;Initial Catalog=MyDB;User ID=web;Password=secret"
  
  Set rs = Server.CreateObject("ADODB.Recordset")
  sql = "SELECT UserID FROM Users WHERE Username = ?"
  Set cmd = Server.CreateObject("ADODB.Command")
  cmd.ActiveConnection = conn
  cmd.CommandText = sql
  cmd.Parameters.Append cmd.CreateParameter("@u", 200, 1, 50, username) ' adVarChar
  Set rs = cmd.Execute
  
  If Not rs.EOF Then
    msg = "此帳號已被註冊,請換一個。"
    status = "err"
  Else
    ' 4. 寫入新會員 (實務請存密碼雜湊 SHA-256 + Salt)
    Dim hashedPwd
    hashedPwd = SHA256(password & "固定鹽值或隨機鹽") ' 需自行實作或引用元件
    
    sql = "INSERT INTO Users (Username, Password, Email, Homepage, Note, RegDate) VALUES (?,?,?,?,?,GETDATE())"
    Set cmd = Server.CreateObject("ADODB.Command")
    cmd.ActiveConnection = conn
    cmd.CommandText = sql
    cmd.Parameters.Append cmd.CreateParameter("@un", 200, 1, 50, username)
    cmd.Parameters.Append cmd.CreateParameter("@pw", 200, 1, 100, hashedPwd)
    cmd.Parameters.Append cmd.CreateParameter("@em", 200, 1, 100, email)
    cmd.Parameters.Append cmd.CreateParameter("@hp", 200, 1, 200, homepage)
    cmd.Parameters.Append cmd.CreateParameter("@nt", 201, 1, , note) ' adLongVarChar
    cmd.Execute
    
    msg = "註冊成功!請 登入。"
    status = "ok"
  End If
  
  rs.Close: Set rs = Nothing
  conn.Close: Set conn = Nothing
End If

' 5. 導回註冊頁顯示訊息
Response.Redirect "register.asp?msg=" & Server.URLEncode(msg) & "&status=" & status
%>

安全性強化清單

  • 密碼雜湊:絕不可存明文。使用 SHA-256 + 隨機 Salt,或 bcrypt/Argon2(需元件)。
  • 參數化查詢:全程使用 Command.Parameters,防 SQL 注入。
  • CSRF 保護:表單加入 <input type="hidden" name="csrf_token" value="<%=Session("csrf")%>">,處理頁驗證。
  • 限制註冊頻率:Session/IP 記錄最近註冊時間,防機器人批量註冊。
  • Email 驗證:發送驗證信,帳號啟用前不可登入。
  • HTTPS:全站強制 HTTPS,保護傳輸中密碼。

輔助函數:SHA-256 (需 CAPICOM 或自行實作)

Function SHA256(str)
  ' 此處需引用 CAPICOM 或純 VBScript 實作 (極長)
  ' 建議改用 ASP.NET Core 內建 BCrypt/PBKDF2
  SHA256 = "IMPLEMENT_WITH_CAPICOM_OR_COMPONENT"
End Function
copyright © 萬盛學電腦網 all rights reserved