ASP站内搜索

来源:互联网 发布:河南郑州淘宝软件诈骗 编辑:程序博客网 时间:2024/05/21 21:46

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {font-size: 12}
body {
 margin-top: 0px;
 margin-bottom: 0px;
 background-color: #66FFCC;
}
.STYLE3 {font-size: 12px}
.t {
 border-right-width: 1px;
 border-bottom-width: 1px;
 border-left-width: 1px;
 border-right-style: solid;
 border-bottom-style: solid;
 border-left-style: solid;
 border-right-color: #0099FF;
 border-bottom-color: #0099FF;
 border-left-color: #0099FF;
 border-top-width: 1px;
 border-top-style: solid;
 border-top-color: #FFFFFF;
}
.t1 {
 border-right-width: 1px;
 border-right-style: solid;
 border-right-color: #339933;
}
.t2 { border: 1px solid #0099FF;
}
a:link {
 text-decoration: none;
}
a:visited {
 text-decoration: none;
}
a:hover {
 text-decoration: none;
}
a:active {
 text-decoration: none;
}
-->
</style>
</head>
<body>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="t2">
  <form id="form1" name="form1" method="post" action="select.asp">
    <tr>
      <td width="531"><div align="right"><span class="STYLE3">搜索: </span></div></td>
      <td width="162"><input name="sousuo" type="text" id="sousuo" size="20" /></td>
      <td width="63"><span class="STYLE2">
        <select name="select1" id="select1">
          <option value="品牌">品牌</option>
          <option value="型号">型号</option>
          <option value="价格" selected="selected">价格</option>
          <option value="厂家">厂家</option>
        </select>
      </span></td>
      <td width="44"><input name="Submit2" type="submit" value="搜索" /></td>
    </tr>
  </form>
</table>
</body>
</html>

 

 

 

处理程序

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--'#Include file="conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {font-size: 12}
.STYLE3 {font-size: 12px; }
a:link {
 text-decoration: none;
}
a:visited {
 text-decoration: none;
}
a:hover {
 text-decoration: none;
}
a:active {
 text-decoration: none;
}
body {
 background-color: #66FFCC;
}
-->
</style>
</head>
<body>
<%
if request("sousuo")<>"" and request("select1")<>"" then
dim ss,s,str,rs
ss=request("sousuo")
s=request("select1")
session("sousuo")=ss
session("select1")=s
select case s
 case "品牌"
str="select * from car where car_pinpai like '"&"%"&ss&"%"&"' order by car_id desc"
set rs=db.execute(str)
%>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr bgcolor="#999999">
    <td><div align="center" class="STYLE2">编号</div></td>
    <td><div align="center" class="STYLE2">汽车名称</div></td>
 <td width="17%"><div align="center" class="STYLE2">型号</div></td>
 <td width="17%"><div align="center" class="STYLE2">样式</div></td>
 <td width="17%"><div align="center" class="STYLE2">厂家</div></td>
    <td><div align="center" class="STYLE2">汽车品牌</div></td>
 <td><div align="center" class="STYLE3">价格</div></td>
    <td><div align="center" class="STYLE2">提交日期</div></td>
  </tr>
  <%
  do while not rs.eof
  %>
  <tr>
    <td><center class="STYLE2"><%=rs("car_id")%></center></td>
    <td><center class="STYLE2"><%=rs("name")%></center></td>
 <td><center class="STYLE2"><%=rs("car_typenumber")%></center></td>
    <td><center class="STYLE2"><%=rs("car_type")%></center></td>
 <td><center class="STYLE2"><%=rs("car_changjia")%></center></td>
    <td><center class="STYLE2"><%=rs("car_pinpai")%></center></td>
 <td><center class="STYLE3"><%=rs("car_jiage")%></center></td>
    <td><center class="STYLE2"><%=rs("submit_date")%></center></td>
  </tr>
  <%
  rs.movenext
  loop
  %>
</table>
<%
 case "型号"
str="select * from car where car_typenumber like '"&"%"&ss&"%"&"' order by car_id desc"
set rs=db.execute(str)
%>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr bgcolor="#999999">
    <td><div align="center" class="STYLE2">编号</div></td>
    <td><div align="center" class="STYLE2">汽车名称</div></td>
 <td width="17%"><div align="center" class="STYLE2">型号</div></td>
 <td width="17%"><div align="center" class="STYLE2">样式</div></td>
 <td width="17%"><div align="center" class="STYLE2">厂家</div></td>
    <td><div align="center" class="STYLE2">汽车品牌</div></td>
 <td><div align="center" class="STYLE3">价格</div></td>
    <td><div align="center" class="STYLE2">提交日期</div></td>
  </tr>
  <%
  do while not rs.eof
  %>
  <tr>
    <td><center class="STYLE2"><%=rs("car_id")%></center></td>
    <td><center class="STYLE2"><%=rs("name")%></center></td>
 <td><center class="STYLE2"><%=rs("car_typenumber")%></center></td>
    <td><center class="STYLE2"><%=rs("car_type")%></center></td>
 <td><center class="STYLE2"><%=rs("car_changjia")%></center></td>
    <td><center class="STYLE2"><%=rs("car_pinpai")%></center></td>
 <td><center class="STYLE3"><%=rs("car_jiage")%></center></td>
    <td><center class="STYLE2"><%=rs("submit_date")%></center></td>
  </tr>
  <%
  rs.movenext
  loop
  %>
</table>
<%
case "价格"
str="select * from car where car_jiage like '"&"%"&ss&"%"&"' order by car_id desc"
set rs=db.execute(str)
%>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr bgcolor="#999999">
    <td><div align="center" class="STYLE2">编号</div></td>
    <td><div align="center" class="STYLE2">汽车名称</div></td>
 <td width="17%"><div align="center" class="STYLE2">型号</div></td>
 <td width="17%"><div align="center" class="STYLE2">样式</div></td>
 <td width="17%"><div align="center" class="STYLE2">厂家</div></td>
    <td><div align="center" class="STYLE2">汽车品牌</div></td>
 <td><div align="center" class="STYLE3">价格</div></td>
    <td><div align="center" class="STYLE2">提交日期</div></td>
  </tr>
  <%
  do while not rs.eof
  %>
  <tr>
    <td><center class="STYLE2"><%=rs("car_id")%></center></td>
    <td><center class="STYLE2"><%=rs("name")%></center></td>
 <td><center class="STYLE2"><%=rs("car_typenumber")%></center></td>
    <td><center class="STYLE2"><%=rs("car_type")%></center></td>
 <td><center class="STYLE2"><%=rs("car_changjia")%></center></td>
    <td><center class="STYLE2"><%=rs("car_pinpai")%></center></td>
 <td><center class="STYLE3"><%=rs("car_jiage")%></center></td>
    <td><center class="STYLE2"><%=rs("submit_date")%></center></td>
  </tr>
  <%
  rs.movenext
  loop
 
  %>
</table>
<%
 case "厂家"
str="select * from car where car_changjia like '"&"%"&ss&"%"&"' order by car_id desc"
set rs=db.execute(str)
%>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr bgcolor="#999999">
    <td><div align="center" class="STYLE2">编号</div></td>
    <td><div align="center" class="STYLE2">汽车名称</div></td>
 <td width="17%"><div align="center" class="STYLE2">型号</div></td>
 <td width="17%"><div align="center" class="STYLE2">样式</div></td>
 <td width="17%"><div align="center" class="STYLE2">厂家</div></td>
    <td><div align="center" class="STYLE2">汽车品牌</div></td>
 <td><div align="center" class="STYLE3">价格</div></td>
    <td><div align="center" class="STYLE2">提交日期</div></td>
  </tr>
  <%
  do while not rs.eof
  %>
  <tr>
    <td><center class="STYLE2"><%=rs("car_id")%></center></td>
    <td><center class="STYLE2"><%=rs("name")%></center></td>
 <td><center class="STYLE2"><%=rs("car_typenumber")%></center></td>
    <td><center class="STYLE2"><%=rs("car_type")%></center></td>
 <td><center class="STYLE2"><%=rs("car_changjia")%></center></td>
    <td><center class="STYLE2"><%=rs("car_pinpai")%></center></td>
 <td><center class="STYLE3"><%=rs("car_jiage")%></center></td>
    <td><center class="STYLE2"><%=rs("submit_date")%></center></td>
  </tr>
  <%
  rs.movenext
  loop
  end select
  %>
</table>
<p>
  <%end if%>
</p>
<form id="form1" name="form1" method="post" action="">
 <table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
   <tr>
     <td width="97">&nbsp;</td>
     <td width="97">&nbsp;</td>
     <td width="97">&nbsp;</td>
     <td width="467">&nbsp;</td>
     <td width="42"><input type="button" class="STYLE3" id="Button"   onclick="javascript:window.location.href='index.asp';" value="确定"></td>
   </tr>
 </table>
</form>
</body>
</html>

原创粉丝点击