📄 books.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<HTML>
<HEAD>
<TITLE>Site Title</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<style type="../../web/text/css">
<!--
@import url("../../web/css_link.css");
@import url("../../web/text.css");
@import url("../../web/css_link.css");
-->
</style>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="100%" height="397" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="386" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="189" height="397" valign="top" background="../../web/images/side_back.jpg">
<table width="100%" height="516" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="516" valign="top" background="../../web/images/home_side.jpg">
<%
String categoryname="";
ResultSet rs_category=conndb.executeQuery("select * from categorydata");
while(rs_category.next()){
categoryname=chstr.chStr(rs_category.getString("categoryname"));
%>
<table width="99%" border="0" cellspacing="3" cellpadding="3">
<tr> <td height="17" valign="middle">
<p class="smbold"><font size="2"><img src="../../web/images/3dots.gif" width="6" height="9">
<a href="books.jsp?categoryname=<%=categoryname%>"><%=categoryname%></a></font></p>
</td>
</tr>
<%}%>
</table>
</td></tr>
</table></td>
<td valign="top" bgcolor="#FFFFFF">
<%
String ctgname="";
if(request.getParameter("categoryname")!=null)
{
ctgname=request.getParameter("categoryname");
}
else{
ctgname=request.getParameter("ctgname");
}
%>
<table width="100%">
<tr><td><p><font size="2"><strong> ==<%=ctgname%>==</strong></font></p></td>
</tr>
</table>
<br>
<%int pagesize=4;int maxPage=0;int Page=0;
ResultSet rs=conndb.executeQuery("select * from bookdata where category='"+ctgname+"'");
if(!(rs.next())){%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("无该类别的书");%></td>
</tr>
</table>
<%}else{%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr>
<td width="87" height="21"> <div align="center"><font size="2"><strong>书号</strong></font></div></td>
<td width="150" height="21"> <div align="center"><font size="2"><strong>书名</strong></font></div></td>
<td width="222"><div align="center"><font size="2"><strong>出版社</strong></font></div></td>
<td width="138"><div align="center"><font size="2"><strong>作者</strong></font></div></td>
<td width="87"><div align="center"><font size="2"><strong>定价</strong></font></div></td>
<%if(session.getAttribute("Username")!=null){%>
<td width="101"><div align="center"><font size="2"><strong>操作</strong></font></div></td>
<%}%>
</tr>
<%String str=(String)request.getParameter("Page");
if(str==null){str="0";}
rs.last();
int recordcount=rs.getRow();
maxPage=(recordcount%pagesize==0)?(recordcount/pagesize):(recordcount/pagesize+1);
Page=Integer.parseInt(str);
if(Page<1){Page=1;}
else{if(((Page-1)*pagesize+1)>recordcount){Page=maxPage;}}
rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
String bookid=rs.getString("bookid");
String bookname=rs.getString("bookname");
String publisher=rs.getString("publisher");
String author=rs.getString("author");
float price=rs.getFloat("price");
%>
<tr bgcolor="E0E0E0" valign="middle">
<td bgcolor="E0E0E0"><div align="center"><font size="2"><a href="book_detail.jsp?bookid=<%=bookid%>"><%=bookid%></a></font></div></td>
<td bgcolor="E0E0E0"><div align="center"><font size="2"><%=bookname%></font></div></td>
<td bgcolor="E0E0E0"><div align="center"><font size="2"><%=publisher%></font></div></td>
<td bgcolor="E0E0E0"><div align="center"><font size="2"><%=author%></font></div></td>
<td bgcolor="E0E0E0"><div align="center"><font size="2"><%=price%></font></div></td>
<%if(session.getAttribute("Username")!=null){%>
<td bgcolor="E0E0E0"><div align="center"><font size="2">[<a href="../shopcart/cart_add.jsp?bookid=<%=bookid%>">购买</a>]</font></div></td>
<%}%>
</tr>
<%try{if(!rs.next()){break;}}catch(Exception e){}}}%>
</table>
<table width="100%">
<tr valign="top">
<td > </td>
<td width="15%" ><font size="2">当前页：<%=Page%>/<%=maxPage%></font></td>
<%if(Page>1){%>
<td width="15%" ><font size="2"><a href="books.jsp?page=<%=Page-1%>&ctgname=<%=ctgname%>">上一页</a>
<%}if(Page<maxPage){%>
<a href="books.jsp?page=<%=Page+1%>&ctgname=<%=ctgname%>">下一页</a></font></td>
<%}%>
</tr>
</table>
</td></tr>
</table></td>
</tr>
</table>
<div align="center"></div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" height="19" valign="top" background="../../web/images/link_bar_hold.jpg"><img src="../../web/images/link_bar_hold.jpg" width="9" height="23"></td>
<td width="99%" background="../../web/images/link_bar_hold.jpg"><div align="center">:
<a href="#">License Agreemen</a>t : <a href="#">Jobs</a> : <a href="#">Site
Map</a> :</div></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="34" bgcolor="#000000"><div align="center">
<p class="smWhite">2003 Copyright Information or webmaster information</p>
</div></td>
</tr>
</table>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -