| 欄位名 | 型別 | 索引 | 說明 |
|---|---|---|---|
| URL | Text (255) | Yes (No Duplicates) | 網頁網址 |
| Title | Text (255) | No | 標題 |
| Description | Memo | No | 描述 |
| Summary | Memo | No | 摘要 |
| Keywords | Text (255) | Yes (No Duplicates) | 關鍵字 |
<%@ Language=VBScript CodePage=65001 %>
<% Option Explicit %>
<html><head><meta charset="utf-8"><title>站內搜尋</title></head><body>
<form method="post" action="doquery.asp?act=search">
關鍵字:<input type="text" name="QueryString" size="40">
<input type="submit" value="搜尋">
</form>
<%
Dim act, conn, rs, sql, QueryString, QueryWords, i
act = Request("act")
If act = "search" Then
QueryString = Trim(Request.Form("QueryString"))
If QueryString = "" Then Response.Redirect("default.asp")
' 簡易分詞:以空白分隔,支援 AND/OR 邏輯關鍵字
QueryWords = Split(QueryString)
' 資料庫連接 (存入 Session 重用)
If IsObject(Session("search_conn")) Then
Set conn = Session("search_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("database/SiteSearch.mdb")
Set Session("search_conn") = conn
End If
' 動態建構 SQL:Description + Keywords + Title 三欄位 OR 關係
' 每欄位內部:第一個詞必須符合,後續詞依 AND/OR 邏輯組合
sql = "SELECT * FROM [URLIndex] WHERE "
' --- Description 欄位 ---
sql = sql & " ( [Description] LIKE '%" & QueryWords(0) & "%' "
For i = 1 To UBound(QueryWords)
If QueryWords(i) <> "" And UCase(QueryWords(i)) <> "OR" And UCase(QueryWords(i)) <> "AND" Then
If UCase(QueryWords(i-1)) = "OR" Then
sql = sql & " OR [Description] LIKE '%" & QueryWords(i) & "%' "
Else
sql = sql & " AND [Description] LIKE '%" & QueryWords(i) & "%' "
End If
End If
Next
' --- Keywords 欄位 ---
sql = sql & " ) OR ( [Keywords] LIKE '%" & QueryWords(0) & "%' "
For i = 1 To UBound(QueryWords)
If QueryWords(i) <> "" And UCase(QueryWords(i)) <> "OR" And UCase(QueryWords(i)) <> "AND" Then
If UCase(QueryWords(i-1)) = "OR" Then
sql = sql & " OR [Keywords] LIKE '%" & QueryWords(i) & "%' "
Else
sql = sql & " AND [Keywords] LIKE '%" & QueryWords(i) & "%' "
End If
End If
Next
' --- Title 欄位 ---
sql = sql & " ) OR ( [Title] LIKE '%" & QueryWords(0) & "%' "
For i = 1 To UBound(QueryWords)
If QueryWords(i) <> "" And UCase(QueryWords(i)) <> "OR" And UCase(QueryWords(i)) <> "AND" Then
If UCase(QueryWords(i-1)) = "OR" Then
sql = sql & " OR [Title] LIKE '%" & QueryWords(i) & "%' "
Else
sql = sql & " AND [Title] LIKE '%" & QueryWords(i) & "%' "
End If
End If
Next
sql = sql & " ) ORDER BY ID DESC"
' 執行查詢
Set rs = conn.Execute(sql)
' 顯示結果
If rs.EOF Then
Response.Write "<p>找不到符合條件的資料</p>"
Else
Response.Write "<p>共找到 " & rs.RecordCount & " 筆結果</p>"
Do While Not rs.EOF
Response.Write "<div style='margin-bottom:15px;padding:10px;border:1px solid #ddd'>"
Response.Write "<h3><a href='" & rs("URL") & "' target='_blank'>" & rs("Title") & "</a></h3>"
Response.Write "<p>" & Left(rs("Description"), 200) & "...</p>"
Response.Write "<small>關鍵字:" & rs("Keywords") & "</small>"
Response.Write "</div>"
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
End If
%>
</body></html>
Split(QueryString) 預設以空白分隔,支援中文詞彙需整合斷詞庫 (如 Jieba、SCWS) 或資料庫全文檢索。AND/OR (不區分大小寫) 作為布林運算子,預設為 AND。OR 串聯,任一欄位符合即納入結果。Replace(str, "'", "''"))。LIKE '%keyword%' 無法使用索引,資料量大時需改用全文檢索 (SQL Server Full-Text Search、Elasticsearch、Lucene.NET)。Replace 將關鍵字包裹 <mark> 標籤。AbsolutePage、PageSize 實作分頁。此範例展示經典 ASP 實作簡易搜尋引擎的核心邏輯:分詞 → 動態 SQL 組裝 → 多欄位模糊查詢 → 結果渲染。雖功能基礎,但涵蓋資料庫設計、連接管理、SQL 動態生成、結果呈現等完整流程,是理解搜尋系統運作原理的良好起點。實務專案建議導入專業全文檢索引擎。