⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search.asp

📁 oracle9i程序事例集
💻 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>
td {
	font-size: 13px;
}
</style>
</head>

<body>
<div align="left"><!-- #include file="pagetop.asp" --></div>
<div align="center">
<center>
<table width="95%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="30" colspan="2">&nbsp;</td>
    </tr>
  <tr>
    <td width="180" valign="top">
	    <table width="180" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><!-- #include file="userinfo.asp" --></td>
        </tr>
        <tr>
          <td><!-- #include file="companyinfo.asp" --></td>
        </tr>
        <tr>
          <td><!-- #include file="search_easy.asp" --></td>
        </tr>
      </table></td>
    <td valign="top">
	  <%
	set rs=server.createobject("adodb.recordset")

%>

<form action="search_result.asp" method="post" name="myform" id="myform">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr align="center">
    <td height="25" colspan="3"><font size="2px" color="#0000FF">请选择查询产品信息的方式:</font></td>
    </tr>
  <tr>
    <td height="25" colspan="2">&nbsp;</td>
    <td align="center">&nbsp;</td>
    </tr>
  <tr>
    <td width="16%" height="25">&nbsp;</td>
    <td width="39%"><input name="type" type="radio" value="pinpai" checked>
按照品牌查询</td>
    <td width="45%" align="left"><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>
    </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td height="25"><input name="type" type="radio" value="xinghao">
按照型号查询</td>
    <td align="left"><input name="xinghao" type="text" id="xinghao"></td>
    </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td height="25"><input name="type" type="radio" value="jiage">
按照价格查询</td>
    <td align="left"><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>
    </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td height="25"><input name="type" type="radio" value="zujian">
按照各种组件查询</td>
    <td align="center">&nbsp;    </td>
    </tr>
  <tr>
    <td height="25" colspan="3" align="center"><select name="cpu" id="select">
      <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="select2">
        <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="select3">
        <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="select4">
        <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" colspan="2">&nbsp;</td>
    <td align="right">&nbsp;</td>
    </tr>
  <tr>
    <td height="25" colspan="3" align="center"><input name="imageField2" type="image" src="../img/serarch.gif" width="34" height="20" border="0"></td>
    </tr>
  <tr>
    <td height="25" colspan="3" align="center">&nbsp;</td>
    </tr>
</table>
</form></td>
  </tr>
  <tr>
    <td height="30" colspan="2">&nbsp;</td>
    </tr>
	<% set rs=nothing %>
</table>

</center>
</div>
<!-- #include file="pagefooter.html" -->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -