用ASP编写一个简单的搜索引擎程序

　2007-12-10 12:43:52　来源：WEB开发网　　　

核心提示：用ASP编写一个简单的搜索引擎程序下面是库中URLINDEX表：URL和Keywords字段分别添加了索引. URL 文本 (索引:有(无重复))Title 文本Description 文本Summary 文本Keywords 文本(索引:有(无重复))doquery.asp <HTML><

用ASP编写一个简单的搜索引擎程序

下面是库中URLINDEX表：URL和Keywords字段分别添加了索引.

URL 　　　　文本 (索引:有(无重复))
Title 　　　　　文本
Description 文本
Summary　文本
Keywords 文本(索引:有(无重复))

doquery.asp

<HTML><HEAD><TITLE>简单搜索引擎</TITLE></HEAD>
<BODY BGCOLOR=#ffffff MARGINWIDTH="0" MARGINHEIGHT="0"
LEFTMARGIN=0 TOPMARGIN=0>

<FORM METHOD="post" ACTION="doquery.asp?act=search">
Query: <INPUT TYPE="Text" NAME="QueryString"><BR>
<INPUT TYPE="Submit" VALUE="Submit">
</FORM>
</CENTER>

<%
dim act
act=request("act")
if(act="search") then
QueryString = Request.form( "QueryString" )
QueryWords = Split( QueryString )
strIndent　 = "　　　　　"

' 如果搜索为空则返回
If QueryString = "" Then
　Response.Redirect( "default.asp" )
End If

Session.timeout = 2
If IsObject(Session("sitesearch_conn")) Then
　　 Set conn = Session("sitesearch_conn")
Else
　　 Set conn = Server.CreateObject("ADODB.Connection")
　　 conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("database/SiteSearch.mdb"),"",""
　　 Set Session("sitesearch_conn") = conn
End If

' 查询语句
sql = "SELECT * FROM [URLIndex] WHERE"
　

'搜索Description字段
sql = sql & " ( [Description] LIKE '%" & QueryWords( 0 ) & "%'"　 ' First
For i = LBound( QueryWords ) + 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 = LBound( QueryWords ) + 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 = LBound( QueryWords ) + 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

' 搜索Summary字段
sql = sql & " ) OR ( [Summary] LIKE '%" & QueryWords( 0 ) & "%'"
For i = LBound( QueryWords ) + 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 [Summary] LIKE '%" & QueryWords( i ) & "%'"
　 Else
　　sql = sql & " AND [Summary] LIKE '%" & QueryWords( i ) & "%'"
　 End If
　End If
Next

sql = sql & " )"

　 '
　 Set rs = Server.CreateObject("ADODB.Recordset")
　 rs.Open sql, conn, 3, 3　　
　
　 Response.Write "<BR><B> 你搜索的是: </B> " & QueryString　
　
　 Response.Write "<BR><B> 搜索的关键字: </B> "
For i = LBound( QueryWords ) to UBound( QueryWords )
　Response.Write "<BR>" & strIndent & i & ": " & QueryWords( i )
Next

　 ' Print the SQL String
　 Response.Write "<BR><B> sql 语句 : </B> " & sql

' Print the Results
　 Response.Write "<BR><B> 结果　　: </B> <UL>"
On Error Resume Next
rs.MoveFirst
Do While Not rs.eof
　Response.Write "<BR>" & "<A HREF='OpenPage.asp?IndexURL=" & rs.Fields("URL").Value & "'>" & rs.Fields("Title") & "</A> - "
　Response.Write rs.Fields("Description") & "<BR>"
　Response.Write "　　 <FONT SIZE=2>URL: " & rs.Fields("URL") & "</FONT>"
　Response.Write "<HR SIZE=1 WIDTH=200 ALIGN=LEFT>"
　rs.MoveNext
Loop
Response.Write "</UL>"

end if　
%>