<%if trim(request("key"))="" then
response.write "<script language='javascript'>alert('要搜索的内容不能为空。');history.go(-1);</script>"
end if
%>
<% dim key,rs,sql,r,maxpagecount,pages,rcount,page,pagestart,pageend,i,conn
if Request("action")="search" then
key=request("key")
set conn=server.createObject("ADODB.Connection")
conn.open "provider=MICROSOFT.JET.oledb.4.0;data source=" & server.mappath(数据库路径)
set rs = server.createobject("adodb.recordset")
if request("lx")="ds" then '如果选择的是查询电视
sql="select top 1000 * from 表名 where 字段 like '%"&key&"%' order by id desc"
if request("lx")="bx" then '如果选择的是查询冰箱,依此类推。
sql="select top 1000 * from 表名 where 字段 like '%"&key&"%' order by id desc"
end if
page=request.querystring("page")
if page="" or page=0 then page=1
pages = "10" '每页显示几条记录
rs.open sql,conn,1,1
if not(rs.BOF or rs.EOF) then
r=cint(rs.RecordCount)'记录总数
if r mod pages=0 then
maxpagecount= r \ pages
else
maxpagecount= r \ pages+1
end if
rs.MoveFirst
if int(page) > maxpagecount then page = maxpagecount
if int(page)<1 then page=1
rs.Move (page-1) * pages
rcount=0
do while not rs.eof and rcount <int(Pages)
%>
'列出内容
<% rs.MoveNext
rcount=rcount+1
loop
set rs=nothing
%>
<%
pagestart=page-5
pageend=page+5
if pagestart<1 then pagestart=1
if pageend>maxpagecount then pageend=maxpagecount
response.write(" [ ")
if maxpagecount > 6 then Response.Write ("<a href=?action=search&key="&key&"&page=1>1</a> ... ")
for i=pagestart to pageend
if i<>int(page) then
Response.Write (" <a href=?action=search&key="&key&"&page="&i&">" & i & "</a> ")
else
Response.Write ("<b>"&i&"</b> ")
end if
next
if maxpagecount > page +5 then Response.Write( " ... <a href=?action=search&key="&key&"&page="&maxpagecount&">"&maxpagecount&"</a>")
response.write(" ] ")
response.write(" 页次:"&page&"/"&maxpagecount&"页 每页:"&pages&" 记录数:"&r&" ")%>
<%else
response.write"查询完毕,没有找到相关资料"
end if
end if %>
<form name="search" method="post" action="search.asp?action=search" style="margin:0">
<input name="key" type="text" size="18" maxlength="10">
<input type="submit" value="ok">
搜索页:
<%if trim(request("key"))="" then
response.write "<script language='javascript'>alert('要搜索的内容不能为空。');history.go(-1);</script>"
end if
%>
<% dim key,rs,sql,r,maxpagecount,pages,rcount,page,pagestart,pageend,i
if Request("action")="search" then
key=request("key")
set rs = server.createobject("adodb.recordset")
sql="select top 1000 * from 表名 where 字段 like '%"&key&"%' order by id desc"
page=request.querystring("page")
if page="" or page=0 then page=1
pages = "10" '每页显示几条记录
rs.open sql,conn,1,1
if not(rs.BOF or rs.EOF) then
r=cint(rs.RecordCount)'记录总数
if r mod pages=0 then
maxpagecount= r \ pages
else
maxpagecount= r \ pages+1
end if
rs.MoveFirst
if int(page) > maxpagecount then page = maxpagecount
if int(page)<1 then page=1
rs.Move (page-1) * pages
rcount=0
do while not rs.eof and rcount <int(Pages)
%>
'列出内容
<% rs.MoveNext
rcount=rcount+1
loop
set rs=nothing
%>
<%
pagestart=page-5
pageend=page+5
if pagestart<1 then pagestart=1
if pageend>maxpagecount then pageend=maxpagecount
response.write(" [ ")
if maxpagecount > 6 then Response.Write ("<a href=?action=search&key="&key&"&page=1>1</a> ... ")
for i=pagestart to pageend
if i<>int(page) then
Response.Write (" <a href=?action=search&key="&key&"&page="&i&">" & i & "</a> ")
else
Response.Write ("<b>"&i&"</b> ")
end if
next
if maxpagecount > page +5 then Response.Write( " ... <a href=?action=search&key="&key&"&page="&maxpagecount&">"&maxpagecount&"</a>")
response.write(" ] ")
response.write(" 页次:"&page&"/"&maxpagecount&"页 每页:"&pages&" 记录数:"&r&" ")%>
<%else
response.write查询完毕,没有找到相关资料"
end if
end if %>