修改記錄分三步:接收 ID 查詢 → 表單回顯 → 提交 UPDATE。本文提供標準化實現,含隱藏欄位傳遞 ID、Recordset 更新模式、錯誤處理。
<%
' 接收 ID
Dim editId : editId = Request.QueryString("id")
If Not IsNumeric(editId) Then Response.Redirect "list.asp"
' 查詢單筆記錄
Dim conn, rs, sql
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("data/guestbook.mdb")
sql = "SELECT * FROM Guestbook WHERE ID = " & editId
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 1, 3 ' Keyset + Optimistic - 可更新
If rs.EOF Then
Response.Write "記錄不存在"
Response.End
End If
%>
<html><body>
<h2>編輯留言 (ID: <%=editId%>)</h2>
<form method="post" action="update.asp">
<input type="hidden" name="id" value="<%=editId%>">
<table>
<tr><td>姓名:</td><td><input name="name" value="<%=Server.HTMLEncode(rs("Name"))%>"></td></tr>
<tr><td>電話:</td><td><input name="tel" value="<%=rs("Tel")%>"></td></tr>
<tr><td>留言:</td><td><textarea name="message" rows="4" cols="40"><%=Server.HTMLEncode(rs("Message"))%></textarea></td></tr>
</table>
<input type="submit" value="保存修改">
</form>
</body></html>
<%
rs.Close: Set rs = Nothing
conn.Close: Set conn = Nothing
%>
<%
Dim conn, rs, sql, editId
editId = Request.Form("id")
If Not IsNumeric(editId) Then Response.Redirect "list.asp"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("data/guestbook.mdb")
' 方式一:Recordset 更新 (推薦,自動處理類型)
sql = "SELECT * FROM Guestbook WHERE ID = " & editId
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 1, 3 ' Keyset, Optimistic
If Not rs.EOF Then
rs("Name") = Request.Form("name")
rs("Tel") = Request.Form("tel")
rs("Message") = Request.Form("message")
On Error Resume Next
rs.Update
If Err.Number = 0 Then
Response.Write "更新成功!<br><a href='list.asp'>返回列表</a>"
Else
Response.Write "更新失敗:" & Err.Description
End If
On Error GoTo 0
Else
Response.Write "記錄不存在"
End If
rs.Close: Set rs = Nothing
conn.Close: Set conn = Nothing
%>
<%
Dim name, tel, message
name = Replace(Request.Form("name"), "'", "''")
tel = Request.Form("tel")
message = Replace(Request.Form("message"), "'", "''")
sql = "UPDATE Guestbook SET " & _
"Name = '" & name & "', " & _
"Tel = " & tel & ", " & _
"Message = '" & message & "' " & _
"WHERE ID = " & editId
conn.Execute sql
If Err.Number = 0 Then Response.Write "成功" Else Response.Write "失敗: " & Err.Description
%>
<input type="hidden" name="id" value="<%=editId%>">
' 更新前驗證:當前登入用戶是否擁有此記錄
Dim ownerId : ownerId = Session("UserId")
Dim checkSql : checkSql = "SELECT UserId FROM Guestbook WHERE ID = " & editId
Dim checkRs : Set checkRs = conn.Execute(checkSql)
If Not checkRs.EOF Then
If checkRs("UserId") <> ownerId Then
Response.Write "無權限修改他人留言"
Response.End
End If
End If
checkRs.Close
list.asp 查看列表edit.asp?id=5update.asp 處理list.asp 驗證變更標準化「查-改-存」流程,配合權限驗證,構建安全可靠的編輯功能。