典型「修改資料」頁面邏輯:edit.asp?id=123 → 驗證 ID 數值 → 查詢資料庫 → 填充表單 → 使用者修改送出 → update.asp 處理更新。本文提供查詢與驗證階段完整代碼。
<%
Dim Id, Sql, Url
Id = Html_Encode(Request.QueryString("id")) ' 自訂防注入函數
' 參數驗證
If Id = "" Then
Response.Write "資料傳輸異常,伺服器拒絕操作。"
Response.End
ElseIf Not IsNumeric(Id) Then
Response.Write "資料傳輸異常,伺服器拒絕操作。"
Response.End
Else
' 可選:增加點擊數
Call Hit(Id)
Url = Request.ServerVariables("SCRIPT_NAME")
Sql = "SELECT * FROM young WHERE id = " & Id
On Error Resume Next
Call OpenDB()
Set Rs = Conn.Execute(Sql)
If Not Rs.EOF Then
Did = Rs(0)
Pid = Rs(1)
Cid = Replace(Replace(Rs(2), "Script", ""), "<", "") ' 簡易過濾
%>
<!-- HTML 表單開始 -->
<form method="POST" action="update.asp">
<input type="hidden" name="id" value="<%=Did%>">
<label>標題: <input name="title" value="<%=Cid%>"></label>
<!-- 其他欄位 -->
<input type="submit" value="更新">
</form>
<!-- HTML 表單結束 -->
<%
Else
Response.Write "找不到指定記錄 (ID=" & Id & ")"
End If
If Err.Number <> 0 Then
Response.Write "資料庫錯誤: " & Err.Description
Err.Clear
End If
End If
%>
Html_Encode 應將 <, >, &, ", ' 轉換為實體。IsNumeric 確保 ID 為純數字,防止 SQL Injection。On Error Resume Next 搭配 Err.Number 檢查。Rs.Close, Set Rs=Nothing, Conn.Close, Set Conn=Nothing (可放在 CloseDB 副程式)。<%
Id = CInt(Request.Form("id"))
title = Html_Encode(Request.Form("title"))
sql = "UPDATE young SET title = '" & title & "' WHERE id = " & Id
Call OpenDB()
Conn.Execute sql
If Err = 0 Then Response.Redirect "list.asp" Else Response.Write "更新失敗"
Call CloseDB()
%>