gusucode.com > asp+SQLServer网上书店系统设计(源代码+论文) > asp+SQLServer网上书店系统设计(源代码+论文)\网上书店asp+SQLServer\网上书店\left.asp
<!--#include file="conn.asp"-->
<html>
<head>
<style type="text/css"><!--
td,body{font-size:9pt}a:link{color:#000000;text-decoration:none}a:visited{COLOR:#000000;TEXT-DECORATION:none}a:active{color:green;text-decoration:none}a:hover{color:red;text-decoration:none}--></style>
<title>网上书城</title>
</head>
<body bgcolor="#b4aed2" align="center">
<form name="form2" method="post" action="displaybook.asp" target="main">
<tr><font size=3>书籍查找 </font><input size=10 name="bookname">
<select name='method' size='1' tabindex='0' class='a' style="font-size: 14px">
<option value='1'>书名</option>
<option value='2'>作者</option>
</select>
<INPUT type=submit size=3 value=查找 name=Submit2 style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 12px; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #bbcc33"> </tr>
</form>
<form name="form3" method="post" action="displayorderlist.asp" target="main">
<p><font size=3>订单查询 </font><input size=10 name="order_id">
<select name='reserch_method' size='1' tabindex='0' class='a' style="font-size: 14px">
<option value='1'>用户名</option>
<option value='2'>订单号</option> </select>
<INPUT type=submit size=3 value=查询 name=Submit2 style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 12px; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #bbcc33"> </tr>
</form><br>
<font size=4 color="black">书籍分类</font>
<hr>
<%
set rs=server.createobject("adodb.recordset")
cn_str="select distinct book_sort1 from book "
rs.open cn_str,cn,1,1
i=0
%>
<left>
<% While i<>rs.recordcount%>
<p> <a href="sort.asp?sort=<%=rs(0)%>" target="main">
<font size=2>
<%=rs(0)%></font></p>
<%
i=i+1
rs.MoveNext
wend
rs.close
%>
</left>
</body>
</html>