<script>
function CheckAll(form) {
// 遍歷表單所有元素
for (var i = 0; i < form.elements.length; i++) {
var el = form.elements[i];
// 排除「全選」核取方塊本身
if (el.name !== 'chkall') {
el.checked = form.chkall.checked;
}
}
}
</script>
<form id="form1" name="form1" method="post" action="delete.asp">
<table width="200" cellspacing="1" cellpadding="0">
<tr>
<td width="26">全選</td>
<td width="169"><input name="chkall" type="checkbox" id="chkall" value="all" onclick="CheckAll(this.form)" /></td>
</tr>
<tr><td><input name="id" type="checkbox" value="1" /></td><td>1 標題1</td></tr>
<tr><td><input name="id" type="checkbox" value="2" /></td><td>2 標題2</td></tr>
<tr><td><input name="id" type="checkbox" value="3" /></td><td>3 標題3</td></tr>
<tr><td><input name="id" type="checkbox" value="4" /></td><td>4 標題4</td></tr>
<tr><td><input name="id" type="checkbox" value="5" /></td><td>5 標題5</td></tr>
<tr><td><input name="id" type="checkbox" value="6" /></td><td>6 標題6</td></tr>
<tr><td><input name="id" type="checkbox" value="7" /></td><td>7 標題7</td></tr>
<tr><td><input name="id" type="checkbox" value="8" /></td><td>8 標題8</td></tr>
<tr><td><input name="id" type="checkbox" value="9" /></td><td>9 標題9</td></tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="刪除" /></td>
</tr>
</table>
</form>
<!--#include file="inc/conn.asp"-->
<%
' 檢查是否有勾選
Dim num, ids, sqlStr
num = Request.Form("id").Count
If num = 0 Then
Response.Write "請選擇要刪除的項目"
Response.End
End If
' Request.Form("id") 直接回傳逗號分隔字串 "1,3,5"
ids = Request.Form("id")
' 防 SQL Injection: 確保每個值都是數字
Dim arr, safeIds, i
arr = Split(ids, ",")
safeIds = ""
For i = 0 To UBound(arr)
If IsNumeric(arr(i)) Then
If safeIds <> "" Then safeIds = safeIds & ","
safeIds = safeIds & CLng(arr(i))
End If
Next
If safeIds = "" Then
Response.Write "無效的 ID"
Response.End
End If
sqlStr = "DELETE FROM IndexAd WHERE Id IN (" & safeIds & ")"
conn.Execute sqlStr
Response.Redirect Request.ServerVariables("HTTP_REFERER")
Response.End
%>
<%
Dim num, i, rs, sql
num = Request.Form("id").Count
If num = 0 Then
Response.Write "請選擇要刪除的新聞"
Response.End
End If
For i = 1 To num
Dim delId
delId = CLng(Request.Form("id")(i)) ' 索引從 1 開始
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM News WHERE NewsId = " & delId
rs.Open sql, conn, 1, 1
If Not rs.EOF Then
' 刪除主表
conn.Execute "DELETE FROM News WHERE NewsId = " & delId
' 級聯刪除相關表 (評論、附件、Log...)
conn.Execute "DELETE FROM Review WHERE NewsId = " & delId
' 記錄操作日誌
' conn.Execute "INSERT INTO AdminLog (Action, TargetId, AdminId, LogTime) VALUES ('DELETE_NEWS', " & delId & ", " & Session("AdminId") & ", NOW())"
Else
Response.Write "ID " & delId & " 不存在,跳過
"
End If
rs.Close
Set rs = Nothing
Next
Response.Write "成功刪除選定新聞"
Response.End
%>
| 維度 | 寫法一:IN 子句 | 寫法二:逐筆迴圈 |
|---|---|---|
| SQL 執行次數 | 1 次 | N 次 (N = 勾選數) |
| 效能 | 極快 | 較慢 (網路來回) |
| 交易控制 | 單一交易 (全成功/全失敗) | 需手動 `BeginTrans`/`CommitTrans` |
| 級聯/觸發器 | 依賴 DB 外鍵 CASCADE | 可在程式碼明確控制順序、寫 Log |
| 適用場景 | 大量刪除、單純主表 | 需複雜業務邏輯、跨表操作、稽核 |
<!-- 前端 -->
<button onclick="deleteSelected()">刪除選取</button>
<script>
function deleteSelected() {
var ids = [];
document.querySelectorAll('input[name="id"]:checked').forEach(function(cb) {
ids.push(cb.value);
});
if (!ids.length) return alert("請先選擇");
if (!confirm("確定刪除 " + ids.length + " 筆資料?")) return;
fetch('delete_ajax.asp', {
method: 'POST',
headers: {'Content-Type': 'application/x-www-form-urlencoded'},
body: 'ids=' + encodeURIComponent(ids.join(','))
}).then(r => r.text()).then(msg => {
alert(msg);
location.reload();
});
}
</script>
前端 `CheckAll` 控制全選狀態,後端提供 **IN 子句批次刪除** (高效) 與 **逐筆迴圈刪除** (彈性) 兩種模式。生產環境務必加上權限驗證、CSRF Token、ID 白名單、軟刪除與操作日誌。現代專案建議改用 AJAX + RESTful API (`DELETE /api/items?ids=1,2,3`) 替代傳統表單提交。