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

📄 search.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT"%>
<%
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<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">
  <!--DWLayoutTable-->
  <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 width="227" align="center">&nbsp;</td>
    </tr>
  <tr>
    <td width="80" height="25">&nbsp;</td>
    <td width="197"><input name="type" type="radio" value="pinpai" checked>
按照燃烧能力查询</td>
    <td align="left"><select name="pinpai" id="pinpai">
      <%  
        sql="select distinct product_burn_ability from GSCOTT.product_info_table where product_isdel='n'"
        rs.open sql,connstr,1,1
		do while not rs.eof
	  %>
	  <option value="<%=rs("product_burn_ability")%>"><%=rs("product_burn_ability")%></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">100元以下</option>
	  <option value="1">100-150</option>
      <option selected value="2">150-200</option>
      <option value="3">200-300</option>
      <option value="4">300元以上</option>
    </select></td>
    </tr>
  <tr>
    <td height="75">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="center">&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 + -