欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【ASP进阶：用asp做的简单搜索引擎代码】，下面是详细的分享！
ASP进阶：用asp做的简单搜索引擎代码
<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
%>
</BODY>
</HTML>
以上所分享的是关于ASP进阶：用asp做的简单搜索引擎代码，下面是编辑为你推荐的有价值的用户互动：
相关问题：用ASP实现搜索功能的代码
答：简单的搜索其实就是在sql里用like语句实现 例如：select * from news where title like'%问问%' 这句的意思是，从news 表中查询 title字段中含有 “问问” 两个字的所有记录 %是模糊匹配，左%表示匹配 "问问" 左边的任何字符，右%就匹配右边的 _ ... >>详细
相关问题：搜索关键字的ASP代码,简单的搜索功能
答：如果就一个文本框的搜索的话。。sql="select * from XXX where ZZZZ like '%"&request("keyword")&"%' "...XXX表明，ZZZZ 查询字段。。keyword获取的文本框，这个最基本了 >>详细
相关问题：求站内搜索源代码 asp 最简单的 最简单的
答：建立access的数据库news,还有表news,表的字段(id,title),id唯一,输入数据保存,用下面代码可查询,可分页 -----------------------下面保存为search.asp-------------------------- 文件 function btn_ck_bh_Click() { var cx = document.form1.cx... >>详细
- 评论列表（网友评论仅供网友表达个人看法，并不表明本站同意其观点或证实其描述）
-