searchbook.jsp

网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询

<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="inc/conn1.jsp"%>
<%@include file="inc/format.jsp"%>
<%@include file="inc/bytes.jsp"%>
<link href="css.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<%
int bookid=Integer.parseInt(request.getParameter("lei"));
String bookshu=Bytes(request.getParameter("Sname"));
//bookshu="%"+bookshu+"%";
if(bookid==0){//选择从所有类别中查询
sql="select * from tushumingxi where shu_name like '%"+bookshu+"%' order by shuID DESC";
}
else{
//从选择的类别中查询匹配数据
sql="select * from tushumingxi where lieID="+bookid+" and shu_name='"+bookshu+"'";
}
rs=stmt.executeQuery(sql);%>
<table   border=0 align="center" cellpadding=0 cellspacing=1>
<tr bgcolor="d1d1ff">
<th width="251" bgcolor="d1d1ff">图书名称</th>
<th width="111">出版社</th>
<th width="112">定价</th>
<th width="150">日期</th>
</tr>
<%while(rs.next())
{
%>
<tr valign="middle" bgcolor="#f8f8f8" height="25">
<td width="251" bgcolor="#f8f8f8" ><a href=# onClick="MM_openBrWindow('browbook.jsp?id=<%=rs.getString("shuid")%>','','width=400,height=550')"><%=rs.getString("shu_name")%></a></td>
<td><%=rs.getString("banshe")%></td>
<td><%=rs.getString("dingjia")%></td>
<td><%=rs.getString("date")%></td>
</tr>
        <tr>
          <td height=1 colspan="4" background="image/dian.gif"><img src="images/blank.gif" width=1 height=1></td>
        </tr>
<%}
%>
</table>
<br>
<a href="Javascript:window.close()">关闭本页</a>