刪除操作風險最高,必須嚴格驗證身分、參數合法性、記錄存在性。本文提供完整流程:登入檢查 → ID 參數驗證 → SQL 刪除 → 交易結果回饋 → 導向列表頁,並附帶防注入 Html_Encode 函數。
<%
' 1. 引用資料庫連線模組
<!-- #include file="db.asp" -->
' 2. 登入檢查
If Session("username") = "" And Session("userpwd") = "" Then
Response.Redirect "login.html"
Response.End
End If
Dim sql, id
id = Html_Encode(Request.QueryString("id"))
' 3. 參數驗證
If id = "" Or Not IsNumeric(id) Then
Response.Write "非法操作:ID 參數錯誤"
Response.End
End If
' 4. 執行刪除
sql = "DELETE FROM news WHERE id = " & id
Call OpenDB()
Conn.Execute sql
' 5. 結果回饋
If Err = 0 Then
Response.Write ""
Else
Response.Write ""
Err.Clear
End If
Call CloseDB()
%>
Function Html_Encode(str)
If IsNull(str) Then Html_Encode = "" : Exit Function
str = Replace(str, "'", "''") ' SQL 單引號轉義 (Access/SQL Server)
str = Replace(str, "<", "<")
str = Replace(str, ">", ">")
str = Replace(str, """", """)
Html_Encode = str
End Function
⚠️ 生產環境請改用 **參數化查詢** (ADO Command Parameters),勿依賴字串替換。
<a href="del.asp?id=<%=rs("id")%>" onclick="return confirm('確定刪除?')">刪除</a>
sql = "UPDATE news SET is_deleted = 1, deleted_at = GETDATE() WHERE id = " & id
優點:資料可還原、保留關聯完整性、符合稽核需求。缺點:查詢需額外 WHERE is_deleted=0。
<!-- 列表頁 -->
<form method="POST" action="batch_del.asp">
<% Do While Not rs.EOF %>
<input type="checkbox" name="chkId" value="<%=rs("id")%>"> <%=rs("title")%><br>
<% rs.MoveNext: Loop %>
<input type="submit" value="批次刪除" onclick="return confirm('確定批次刪除?')">
</form>
<!-- batch_del.asp -->
ids = Request.Form("chkId")
If ids <> "" Then
idArr = Split(ids, ",")
For Each id In idArr
If IsNumeric(id) Then
Conn.Execute "DELETE FROM news WHERE id = " & id
End If
Next
End If