<%@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"> </td>
<td width="97"> </td>
<td width="97"> </td>
<td width="467"> </td>
<td width="42"><input type="button" class="STYLE3" id="Button" οnclick="javascript:window.location.href='index.asp';" value="确定"></td>
</tr>
</table>
</form>
</body>
</html>