📄 book_leis.jsp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>图书列表</title>
<link href="style1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<%@ include file="inc/conn.jsp"%>
<!--首页上部分--><%@ include file="index_Top.jsp"%>
<!--用户登录表单-->
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table1">
<tr>
<td height="50" align="right">
<iframe border="0" name="main_trg" marginWidth="0" marginHeight="0" src="mem_Login.jsp"
frameBorder="0" width="900" height="45">浏览器不支持嵌入式框架，或被配置为不显示嵌入式框架。</iframe>
</td>
</tr>
</table>
<!--显示其他相关分类开始-->
<table width="95%" border="1" align="center" cellpadding="5" cellspacing="5" bordercolor="#CCCCCC"
bgcolor="#FFFFFF" ID="Table15">
<tr>
<td width="50%" bordercolor="#f8f8f8" bgcolor="#f8f8f8">
<img src="pic/dot1.jpg" width="10" height="10" />
<%
String Cateid=request.getParameter("Cateid");
if(Cateid==null) Cateid="1";
sql="SELECT * FROM category where highLevelID="+Cateid+" or categoryId="+Cateid+" order by categoryID";
rs=dbBean.exeSQL(sql);
while(rs.next()){
String categoryid=rs.getString("categoryID");
String categoryname=rs.getString("categoryName");
if(rs.getString("highLevelID").equals("0")){
%>
<a href="Book_Leis.jsp?Cateid=<%=categoryid%>">【<u><font color="#990000"><%=categoryname%></font></u>】</a>
<%}else{%>
·<a href="Book_Leis.jsp?Cateid=<%=categoryid%>" target="_blank"><u><%=categoryname%></u></a>
<%}}%>
</td>
</tr>
</table>
<!--显示其他相关分类结束-->
<br />
<%
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage,lei;
int i;
// 设置一页显示的记录数
intPageSize =3;
//取得待显示页码
strPage = request.getParameter("page");
lei = request.getParameter("Cateid"); //图书类别
if(lei==null){lei="1";}
//while(rs.next()){
if(strPage==null){
//表明在QueryString中没有page这一个参数，此时显示第一页数据
intPage = 1;
} else{
//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
}if(intPage< 1){
intPage = 1;
}
dbBean.connection();
Statement selstmt =dbBean.con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="select * from tushumingxi where lieID=(select highLevelID from category where categoryID="+lei+") or lieID="+lei;
rs=selstmt.executeQuery(sql);
//获取记录总数
rs.last();
intRowCount = rs.getRow();
//记算总页数
intPageCount = (intRowCount+intPageSize-1)/intPageSize;
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
rs.absolute((intPage-1) * intPageSize+1);
//显示数据
}
i = 0;
//rs.next();
//while(i<intPageSize && !rs.isAfterLast()){
%>
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" ID="Table2">
<tr>
<td colspan="2" bgcolor="#FFFFFF">
<%String url="Book_Leis.jsp";
if(request.getParameter("Cateid")!=null){url="Book_Leis.jsp?Cateid="+request.getParameter("Cateid");}
%>
<table width="97%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#222222"
ID="Table3">
<tr>
<td width="20%" bgcolor="#F3F3F3">
<div align="center"><b><font color="#FF0000"> 请选择排序方式</font></b></div> </td>
<td bgcolor="#F3F3F3" width="13%">
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="#FFFFFF" ID="Table6">
<tr>
<td width="100" height="24" bgcolor="#F3F3F3">
<div align="center"><a href="<%=url%>&sort=date"><font color="#0000FF"><b>按上架日期</b></font></a></div> </td>
</tr>
</table> </td>
<td width="100" bgcolor="#F3F3F3">
<div align="center"><a href="<%=url%>&sort=price"><font color="#CC0000">按价格</font></a></div> </td>
<td width="100" bgcolor="#F3F3F3">
<div align="center"><a href="<%=url%>&sort=hits"><font color="#CC0000">按点击率</font></a></div> </td>
<td width="100" bgcolor="#F3F3F3">
<div align="center"><a href="<%=url%>&sort=jinhuoliang"><font color="#CC0000">按销售数量</font></a></div> </td>
<td width="100" bgcolor="#F3F3F3">
<div align="center"><a href=""><b><font color="#FF0000"> 正序排列</font></b></a></div> </td>
<td width="16%" align="center" bgcolor="#F3F3F3"><a href="../bbs/list.asp?boardid=5" target="_blank"><img src="pic/queshu.gif" width="25" height="23" border="0" />我要登记缺货</a> </td>
</tr>
</table> <%
%> </td>
</tr>
</table>
<table width="97%" border="0" cellspacing="0" cellpadding="0" align="center" ID="Table11">
<tr>
<td class="s" align="left" height="28" valign="bottom" width="383"><font color="#000099"><strong>查询结果</strong> 关键字：[ <font color="#ff0000">软件与程序设计 </font>] 搜索结果共：[<font color="#000099"><%=intRowCount%></font>]条</font></td>
<td width="546" height="28" align="right" class="s">
<table border="0" class="s" ID="Table12">
<form action="" method="post" ID="Form1">
<tr>
<td> <a href="Book_Leis.jsp?Cateid=<%=Cateid%>"><font color="#003399">首页</font></a>
<%if(intPage>1){%><a href="Book_Leis.jsp?Cateid=<%=Cateid%>&page=<%=intPage-1%>">
<font color="#003399">上一页</font></a><%}%>
<%if(intPage<intPageCount){%><a href="Book_Leis.jsp?Cateid=<%=Cateid%>&page=<%=intPage+1%>">
<font color="#003399">下一页 </font></a><%}%>
<a href="Book_Leis.jsp?Cateid=<%=Cateid%>&page=<%=intPageCount%>"><font color="#003399">尾页</font></a><font color="#003399"> 页次：<font color="red"><%=intPage%>/<%=intPageCount%></font>页 每页<font color="#FF0000"><%=intPageSize%></font>条
跳转页</font>
<input name="page" size="4" style="BACKGROUND-COLOR: #f9fcff; BORDER-BOTTOM: #5f98e7 1px solid; BORDER-LEFT: #5f98e7 1px solid; BORDER-RIGHT: #5f98e7 1px solid; BORDER-TOP: #5f98e7 1px solid; FONT-SIZE: 9pt"
onMouseOver="this.focus()" onFocus="this.select()" maxlength="10" ID="Text1">
<input type="submit" name="submit" value="GO" ID="Submit1"> </td>
</tr>
</form>
</table> </td>
</tr>
</table>
<%
while(i<intPageSize && !rs.isAfterLast()){
String categoryid=rs.getString("shuID");
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"
ID="Table21">
<tr>
<td>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table22">
<tr>
<td colspan="2"><hr size="1" noshade="NOSHADE" color="#525D76"/>
</td>
</tr>
<tr>
<td width="16%" height="148"><div align="center"><a href="Book_info.jsp?Bookid=<%=categoryid%>"><img src="<%=rs.getString("fengmian")%>" width="100" height="140" border="0"></a></div>
</td>
<td width="84%"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table23">
<tr>
<td height="28" colspan="3"><strong><font color="#000099"><span class="m"><a href="Book_info.jsp?Bookid=<%=categoryid%>"><font color="#0000A0">《<%=rs.getString("shu_name")%>》</font></a></span></font></strong>
<%if(rs.getString("commend").equals("1")){%>[ <font color="#FF0000">推荐</font> ] <%}%> </td>
</tr>
<tr>
<td height="25" colspan="3">出版社：<%=rs.getString("banshe")%></td>
</tr>
<tr>
<td height="25" colspan="3">作者：<span class="s"><%=rs.getString("zhuozhe")%> 等</span></td>
</tr>
<tr>
<td height="20">上架日期：<%=rs.getString("date")%> <span class="s">浏览次数：<%=rs.getString("hits")%>次</span>
</td>
</tr>
<tr>
<td height="30"><table width="90%" border="0" cellspacing="0" cellpadding="0" align="left" ID="Table24">
<tr>
<td align="left"><strong>定价：</strong><strike><font color="#999999">￥<%=rs.getString("dingjia")%></font></strike>
<font color="#000099"><strong>会员：</strong></font><font color="#FF0000">￥<%=rs.getString("huiyuanjia")%></font> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3">
<a href="ShopCar_info.jsp?addBookid=<%=categoryid%>"><img src="pic/shopcart.gif" alt="放入购物车" width="90" height="16" border="0"></a>
<span class="s">
<a href="javascript:AddToMyBook('mybookproc.asp?lbbh=10008936')"><img src="pic/per.gif" alt="加入个人收藏" width="16" height="18" border="0">
加入收藏</a></span>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width="97%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999"
ID="Table25">
<tr>
<td height="7" bordercolor="#FFFFFF"></td>
</tr>
<tr>
<td height="20" bordercolor="#FFFFFF"><table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table26">
<tr>
<td> <font color="#990000"><%=rs.getString("shu_jian")%>...</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="7" bordercolor="#FFFFFF"></td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<%i++;
rs.next();
}
%>
<!--首页底部页面-->
<%@ include file="index_Endb.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -