常見需求:發布新聞前檢查標題是否已存在。本範例展示連接資料庫、執行參數化查詢、判斷記錄集 EOF 回傳 0/1 的完整流程。注意:原始碼使用字串拼接 SQL,有注入風險,文中提供參數化改寫版本。
<%
Call per.getPermition("news", 0)
Dim title, sql, rs
title = Lib.safeRequest("/", 0) ' 自訂過濾函數
sql = "SELECT Id FROM [" & cfg.TablePrefix & "news] WHERE title = '" & title & "'"
rs = dbo.Query(sql)
If IsEmpty(rs) Or IsNull(rs) Then
Response.Write(0)
Else
Response.Write(1)
End If
Set Lib = Nothing : Set Dbo = Nothing
%>
<%
Dim conn, cmd, rs, title, exist
title = Request.QueryString("title")
If title = "" Then Response.Write "-1" : Response.End
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=.;Initial Catalog=CMS;User ID=sa;Password=pwd;"
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "SELECT Id FROM News WHERE title = ?"
cmd.CommandType = 1 ' adCmdText
cmd.Parameters.Append cmd.CreateParameter("@title", 200, 1, 200, title) ' adVarChar, adParamInput
Set rs = cmd.Execute
If rs.EOF Then exist = 0 Else exist = 1
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
Response.Write exist
%>
dbo.Query、Lib.safeRequest 為專案自訂封裝,實際部署需確認其實作細節。IsEmpty(rs) Or IsNull(rs) 判斷記錄集是否為空並不準確,應用 rs.EOF And rs.BOF 或直接 rs.EOF。