📄 search_pro.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>
<% 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">
<div align="center">
<center>
<%
dim rs,sql
set rs=server.createobject("adodb.recordset")
%>
<form action="search_pro_result.asp" method="post" name="myform" id="myform">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" colspan="4">请选择查询产品信息的方式：</td>
</tr>
<tr>
<td height="25" width="20%"> </td>
<td width="25%"><input name="type" type="radio" value="pinpai" checked>
按照品牌查询</td>
<td width="30%" align="center"><select name="pinpai" id="pinpai">
<%
sql="select distinct product_brand from scott.product_info where product_isdel='n'"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("product_brand")%>"><%=rs("product_brand")%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td width="25%"> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="xinghao">
按照型号查询</td>
<td align="center"><input name="xinghao" type="text" id="xinghao"></td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="jiage">
按照价格查询</td>
<td align="center"><select name="jiage" id="jiage">
<option value="0">5000元以下</option>
<option value="1">5000-10000</option>
<option selected value="2">10000-15000</option>
<option value="3">15000-20000</option>
<option value="4">20000元以上</option>
</select></td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="zujian"> 按照各种组件查询</td>
<td colspan="2" align="left"> <select name="cpu" id="cpu">
<option value="0">CPU</option>
<%
sql="select distinct product_cpu from scott.product_info where product_isdel='n'"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("product_cpu")%>"><%=rs("product_cpu")%></option>
<%
rs.movenext
loop
rs.close
%>
</select>
<select name="monitor" id="monitor">
<option value="0">显示器</option>
<%
sql="select distinct product_monitor from scott.product_info where product_isdel='n'"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("product_monitor")%>"><%=rs("product_monitor")%></option>
<%
rs.movenext
loop
rs.close
%>
</select>
<select name="memory" id="memory">
<option value="0">内存</option>
<%
sql="select distinct product_memory from scott.product_info where product_isdel='n'"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("product_memory")%>"><%=rs("product_memory")%></option>
<%
rs.movenext
loop
rs.close
%>
</select>
<select name="harddisk" id="harddisk">
<option value="0">硬盘</option>
<%
sql="select distinct product_harddisk from scott.product_info where product_isdel='n'"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("product_harddisk")%>"><%=rs("product_harddisk")%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
</tr>
<tr>
<td height="25"> </td>
<td> </td>
<td align="center"> </td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td> </td>
<td align="center"> </td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td colspan="2" align="center"><input type="submit" name="Submit" value="搜索"></td>
<td align="right"> </td>
</tr>
<tr>
<td height="25"> </td>
<td colspan="2" align="center"> </td>
<td align="right"><a href="javascript:history.go(-1)">返回上一页</a></td>
</tr>
</table>
</form>
</center>
</div>
<% set rs=nothing %>
</body>
<% end if %>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -