刚写的应用于某软件的全文检索程序

答案：<p> <!--#include file=function/conn.asp-->

<br>

<%

keyWord=trim(request("oKey"))

sType=trim(request("oType"))

if keyWord="" or keyWord="关键字…" then

Response.Write "请输入关键字！"

Response.End()

end if

if sType="" then

Response.Write "请选择查询信息类别"

Response.End()

end if

dim ftsTable '要查询信息的储存表名

dim ftsFolder '要查询信息的储存文件夹　

if sType="1" then

ftsTable="tb_bzxx"

ftsFolder=fjroot

elseif sType="2" then

ftsTable="tb_other"

ftsFolder=fjroot_other

elseif sType="3" then

ftsTable="tb_info"

ftsFolder=fjroot_info

else

Response.Write "出错了！"

Response.End

end if

sql=""

if sType="1" then

sql="select bz_xuhao as xuhao,bz_name as bname,bz_code as bcode,bz_htm as htm from " & ftsTable

elseif sType="2" then

sql="select p_xuhao as xuhao,p_name as bname,p_code as bcode,p_htm as htm from " & ftsTable

elseif sType="3" then

sql="select info_id as xuhao,info_htm,info_type as htm from " & ftsTable

else

Response.Write "出错了！"

Response.End

end if

Call OPenConn() ' 打开数据库连接

set fso=server.CreateObject("scripting.filesystemobject")

set rs=server.createobject("adodb.recordset")

dim oPattern

oPattern="<p>|<p(.*)>|</p>"

'如果是查询第三种信息（其他信息），则先将所有的信息类别取出来，放到数组中。

dim infoType()

if sType="3" then

rs.Open "select type_id,type_name from tb_info_type order by type_id desc",adocon,3,1

if rs.RecordCount<=0 then

CloseRs rs

Call CloseConn

Response.Write "出错了！"

Response.End()

end if

redim infoType(clng(rs(0)))

do while not rs.EOF

infoType(clng(rs(0)))=rs(1)

rs.MoveNext

loop

rs.Close()

end if

%>

<h4 ALIGN= "CENTER" STYLE= "COLOR:#000080" > 标准信息系统全文检索结果

&nbsp;关键字： <span style= "color:#ff0000" > <%=KEYWORD%>

</span><br>

</h4>

<hr>

<table width= "600" >

<tr>

<td style= "font-size:12;color:000000;line-height:1.8" > <%

'进行检索

rs.Open sql,adocon,3,1

if rs.RecordCount>0 then

sCount=0

do while not rs.EOF

findPos=0

htm=rs("htm")

if htm<>"" then

vpath=ftsFolder & "/" & rs("xuhao") & "/" & htm

filePath=Server.MapPath(vpath)

if fso.FileExists(filepath) then

set oFile=fso.GetFile(filepath)

set oFilestream=oFile.openastextstream(1)

oFileInfo=""

if not oFilestream.atendofstream then

oFileInfo=FilterHTML(FilterBr(trim(oFilestream.readall)))

if oFileInfo<>"" then

findPos=instr(1,oFileInfo,keyWord,1)

'查到了数据，需要显示

if findPos>0 then

Response.Write "<a href=>
if sType="1" or sType="2" then

Response.Write "<span style='font-weight:bold;font-size:13;color:0000ff'>" & rs("bname") & " ( " & rs("bcode") & " )　　</span></a><br>"

else

Response.Write "<span style='font-weight:bold;font-size:13;color:0000ff''>" & infotype(clng(rs("info_Type"))) & "　　</span></a><br>"

end if

if findPos>50 then

Response.Write "…" & replace(mid(oFileInfo,findPos-50,200),keyWord,"<span style='color:ff0000'>" & keyWord & "</span>",1,-1,1) & "…"

else

Response.Write replace(mid(oFileInfo,1,200),keyWord,"<span style='color:ff0000'>" & keyWord & "</span>",1,-1,1)& "…"

end if

Response.Write "<br><br>"

sCount=sCount+1

end if

end if

end if

end if

end if

rs.MoveNext

loop

end if

Response.Write "　　　　　<SPAN STYLE='COLOR:#000080'>共搜索到 " & sCount & " 条信息!</SPAN>"

'过滤掉文本中的html标记和空格

Function FilterHTML(str)

Dim re

Set re=new RegExp

re.IgnoreCase =True

re.Global=True

re.Pattern="<(.[^>]*)>|&nbsp;"

str=re.Replace(str,"")

set re=Nothing

FilterHTML=str

End Function

function FilterBr(str)

FilterBr=replace(str,vbcrlf,"　")

FilterBr=replace(str,"<br>","　")

end function

%>

</td>

</tr>

</table>

</body>

</html>

上一个：ASP编程入门进阶（十三）：Ad & Content Rot
下一个：一个ASP（JScript）简单SQL语句构建“类”，同时支持客户端和服务器端执行的