📄 search_pro_result.asp
字号:
<%@LANGUAGE="VBSCRIPT" %>
<!-- #include file="../common/conn.asp" -->
<!-- #include file="../common/status.html" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>搜寻商品信息结果</title>
<style type="text/css">
<!--
.style2 {font-size: x-small}
-->
</style>
<% if session("admin_id")="" then %>
您还没有登录或者您的权限不够，五秒钟后自动返回登录，如果您的浏览器没有自动返回，请<a href="../admin/login.html">点击登录</a>。
<meta http-equiv="refresh" content="5;url=login.html">
<% else %>
</head>
<body background="../img/searchBG.gif">
<%
Const MaxPerPage=5
dim totalPut
dim CurrentPage
dim TotalPages
dim j
dim sql,rs,stype,sstype,cpu,memory,harddisk,monitor
stype=request.Form("type")
set rs=server.CreateObject("adodb.recordset")
if stype<>"" then
SELECT CASE stype
CASE "pinpai"
sstype=request.Form("pinpai")
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from scott.product_info where product_isdel='n' and product_brand='"&sstype&"'"&" order by product_id"
CASE "xinghao"
sstype=request.Form("xinghao")
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from scott.product_info where product_isdel='n' and product_num='"&sstype&"'"&" order by product_id"
CASE "jiage"
sstype=request.Form("jiage")
SELECT CASE sstype
CASE "0"
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from SCOTT.PRODUCT_INFO where product_isdel='n' and product_price<=5000"
CASE "1"
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from SCOTT.PRODUCT_INFO where product_isdel='n' and product_price between 5000 and 10000"
CASE "2"
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from SCOTT.PRODUCT_INFO where product_isdel='n' and product_price between 10000 and 15000"
CASE "3"
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from SCOTT.PRODUCT_INFO where product_isdel='n' and product_price between 15000 and 20000"
CASE "4"
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from scott.product_info where product_isdel='n' and product_price>=20000"
END SELECT
CASE "zujian"
cpu=request.Form("cpu")
if cpu="0" then
cpu=""
else
cpu=" and product_cpu='"&cpu&"'"
end if
monitor=request.Form("monitor")
if monitor="0" then
monitor=""
else
monitor=" and product_monitor='"&monitor&"'"
end if
memory=request.Form("memory")
if memory="0" then
memory=""
else
memory=" and product_memory='"&memory&"'"
end if
harddisk=request.Form("harddisk")
if harddisk="0" then
harddisk=""
else
harddisk=" and product_harddisk='"+harddisk&"'"
end if
sql="select product_id, product_num, product_brand, product_cpu, product_mainboard, product_price from scott.product_info where product_isdel='n'"&cpu+monitor+memory+harddisk&" order by product_id"
END SELECT
else
sql=replace(request.QueryString("sql"),"-"," ")
end if
sql1=replace(sql," ","-")
if Not isempty(request("page")) then
currentPage=Cint(request("page"))
else
currentPage=1
end if
rs.open sql,connstr,1,1
if err.number<>0 then
response.write "<p>数据库中暂时无数据</p>"
end if
if rs.eof And rs.bof then
%>
对不起，您搜索的商品不存在，请缩小查询范围或者输入正确信息。<a href="javascript:history.go(-1)">返回上一页</a>。
<% else %>
<div align="center"><center>
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" colspan="4">浏览上架商品信息：</td>
</tr>
<tr align="center">
<td width="16%" height="30">产品型号</td>
<td width="16%">产品品牌</td>
<td width="16%">CPU</td>
<td width="16%">主板</td>
<td width="16%">价格</td>
<td width="20%"> </td>
</tr>
<%
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage totalput,MaxPerPage,"search_pro_result.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage totalput,MaxPerPage,"search_pro_result.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"search_pro_result.asp"
end if
end if
end if
sub showContent
dim i
i=0
do while not rs.eof
%>
<tr align="center">
<td height="30"><%=rs("product_num") %></td>
<td><%=rs("product_brand") %></td>
<td><%=rs("product_cpu") %></td>
<td><%=rs("product_mainboard") %></td>
<td><%=rs("product_price") %></td>
<td><a href="sj_detail.asp?id=<%=rs("product_id")%>" target="_blank">浏览详细信息</a></td>
</tr>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.MoveNext
loop
rs.Close
set rs=nothing
%>
</table>
<%
end sub
Function showpage(totalnumber,maxperpage,filename)
Dim n
If totalnumber Mod maxperpage=0 Then
n= totalnumber \ maxperpage
Else
n= totalnumber \ maxperpage+1
End If %>
<form method="Post" action="<%=filename%>?sql=<%=sql1%>">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<% If CurrentPage<2 Then %>
<td width="8%" height="25"><span class="style2">首页</span></td>
<td width="8%"><span class="style2">上一页</span></td>
<% Else %>
<td width="8%"><a href=<%=filename%>?page=1&sql=<%=sql1%> class="style2">首页</a></td>
<td width="8%"><a href=<%=filename%>?page=<%=CurrentPage-1%>&sql=<%=sql1%> class="style2">上一页</a></td>
<% end if %>
<% If n-currentpage<1 Then %>
<td width="8%"><span class="style2">下一页</span></td>
<td width="8%"><span class="style2">末页</span></td>
<% Else %>
<td width="8%"><a href=<%=filename%>?page=<%=(CurrentPage+1)%>&sql=<%=sql1%>><span class="style2">下一页</span></a></td>
<td width="8%"><a href=<%=filename%>?page=<%=n%>&sql=<%=sql1%> class="style2">末页</a></td>
<% end if %>
<td width="8%"><span class="style2">第<%=CurrentPage%>页</span></td>
<td width="8%" class="style2">共<%=n%>页</td>
<td width="16%" height="25" colspan="2" align="center" class="style2">共<%=totalnumber%>条记录</td>
<td width="16%" colspan="2" align="center" class="style2">每页<%=maxperpage%>条记录</td>
<td colspan="2" align="center" width="20%"><span class="style2">转到第
<input type="text" name="page" size="2" maxlength="10" value="<%=currentpage%>">
页</span> <input type="submit" value="跳转" name="cndok"></td>
</tr>
<tr><td height="20" colspan="13" align="right"><a href="javascript:history.go(-1)" class="style2">返回上一页</a> <a href="index.asp" class="style2">返回主页</a></td>
</table>
</form>
<%
End Function
%>
</center>
</div>
</body>
<% end if %>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -