經典入門範例:前端 confirm() 防止誤刪,後端接收 id 參數執行 DELETE SQL。注意:原始碼使用字串拼接 SQL 存在注入風險,文中提供參數化改寫版本。
<script>
function checkDelete() {
return confirm('確定要刪除這筆資料嗎?');
}
</script>
<table border="0">
<tr><td>標題</td><td>操作</td></tr>
<tr>
<td>範例資料</td>
<td><a href="?id=5" onclick="return checkDelete();">刪除</a></td>
</tr>
</table>
<%
SiteDB = "Database/mdb.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(SiteDB)
Conn.Open ConnStr
Dim sql
sql = "DELETE FROM test WHERE id = " & Request.QueryString("id")
' ⚠️ 直接拼接 SQL,極度危險!
If Conn.Execute(sql) Then
Response.Write "刪除成功"
Else
Response.Write "刪除失敗"
End If
%>
<%
Dim conn, cmd, 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("Database/mdb.mdb")
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "DELETE FROM test WHERE id = ?"
cmd.CommandType = 1
cmd.Parameters.Append cmd.CreateParameter("@id", 3, 1, , CLng(id)) ' adInteger
cmd.Execute
Response.Write "刪除成功"
conn.Close
Set conn = Nothing
%>
UPDATE SET is_deleted=1 替代物理刪除。