編輯頁面核心邏輯:依 URL 參數 id 查詢資料庫 → 將欄位值填入 input value → 使用者修改送出。本文提供 Access 版本完整代碼,含參數驗證與錯誤處理。
<%
Dim conn, rs, sql, id
id = Request.QueryString("id")
If Not IsNumeric(id) Then Response.Write "參數錯誤" : Response.End
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT uid, pwd FROM test WHERE id = " & id
rs.Open sql, conn, 1, 1
If rs.EOF Then
Response.Write "找不到指定記錄"
Response.End
End If
%>
<form method="POST" action="update.asp">
<input type="hidden" name="id" value="<%=id%>">
<label>用戶名: <input name="uid" type="text" value="<%=Server.HTMLEncode(rs("uid"))%>"></label><br>
<label>密碼: <input name="pwd" type="password" value="<%=Server.HTMLEncode(rs("pwd"))%>"></label><br>
<input type="submit" value="更新">
</form>
<%
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>
value="<%=Server.HTMLEncode(rs("uid"))%>":防止欄位值含雙引號導致 HTML 屬性截斷,同時防 XSS。type="password" 瀏覽器不會自動填入 value,若需顯示請改 type="text" 或前端 JS 處理。<%
id = CInt(Request.Form("id"))
uid = Request.Form("uid")
pwd = Request.Form("pwd")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db.mdb")
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "UPDATE test SET uid=?, pwd=? WHERE id=?"
cmd.Parameters.Append cmd.CreateParameter("@uid", 200, 1, 50, uid)
cmd.Parameters.Append cmd.CreateParameter("@pwd", 200, 1, 50, pwd)
cmd.Parameters.Append cmd.CreateParameter("@id", 3, 1, , id)
cmd.Execute
Response.Write "更新成功"
conn.Close
%>