建立 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
)
<%@ 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>
<%
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 注入。<input type="hidden" name="csrf_token" value="<%=Session("csrf")%>">,處理頁驗證。Function SHA256(str)
' 此處需引用 CAPICOM 或純 VBScript 實作 (極長)
' 建議改用 ASP.NET Core 內建 BCrypt/PBKDF2
SHA256 = "IMPLEMENT_WITH_CAPICOM_OR_COMPONENT"
End Function