📄 sort.jsp
字号:
<%@ page language="java" import="java.util.*" contentType="text/html; charset=gbk" pageEncoding="gbk"%>
<%@ page import="bean.Goods" %>
<jsp:useBean id="GoodsDao" class="bean.GoodsDao" scope="page"></jsp:useBean>
<jsp:useBean id="pager" class="lp.Page" scope="page"></jsp:useBean>
<%
request.setCharacterEncoding("GBK");
//从数据库中去出结果集
String sort=request.getParameter("sort");
System.out.println(sort);
String sql = "select * from goods where sort='"+sort+"'";
int currentRecord = 0;
ArrayList<Goods> result =GoodsDao.goodsSelect(sql);
//out.print("查询的结果有 " + result.size() + " 条记录.");
pager.setTotalRecord(result.size());
pager.setTotalPage(result.size(),pager.getPageSize());
//计算并设置分页的参数
if(request.getParameter("currentRecord")!=null)
{
currentRecord = Integer.parseInt(request.getParameter("currentRecord"));
pager.setCurrentRecord(currentRecord);
pager.setCurrentPage(currentRecord,pager.getPageSize());
}
//从结果集中取出当前页面要显示的子集
List<Goods> subResult = null;
if(currentRecord == 0 && result.size() > pager.getPageSize())
{
subResult = result.subList(0,pager.getPageSize());
}
else if(currentRecord == 0 && result.size() < pager.getPageSize())
{
subResult = result.subList(0,result.size());
}
if(pager.getCurrentRecord()+pager.getPageSize()<result.size()
|| pager.getCurrentRecord()+pager.getPageSize()==result.size())
subResult = result.subList(pager.getCurrentRecord(),pager.getCurrentRecord()+pager.getPageSize());
else
subResult = result.subList(pager.getCurrentRecord(),result.size());
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" rev="stylesheet" href="css/style.css" type="text/css" media="all" />
<link href="temp.files/books.css" rel="stylesheet" type="text/css">
<title><%=sort.concat("图书") %></title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<div
style="position: absolute; top: 0px; left: 0px;height: 200px; width: 1000px; border-top: 0px solid blue;
border-bottom: 0px solid blue; border-left:0px solid blue; border-right: 0px solid blue;">
<div style="height: 80px; width: 1000px;">
<div style="float:left; width: 285px;">
<UL style="MARGIN-TOP: 13px; ">
<IMG src="temp.files/logo.gif" border=0>
</UL>
</div>
<div style="float: left;">
<UL style="MARGIN-TOP: 18px">
<FONT color=#cc0000>本站58万种现货图书！特价图书4折封顶！</FONT>
</UL>
<UL style="MARGIN-TOP: 18px">
<A href="frame.htm"><IMG
src="temp.files/index.jpg" align=absBottom> </A>
<A href="frame.htm"><IMG
src="temp.files/book.jpg" align=absBottom> </A>
<A href="frame.htm"><IMG
src="temp.files/pifa.jpg" align=absBottom> </A>
</UL>
</div>
<div style="float: left;">
<UL style="MARGIN-TOP: 8px">
<A href="Buy.jsp" alt="购物车"><IMG
id=IMG1 alt=查看您已订购的图书 src="temp.files/shopcar.jpg"
border=0 name=IMG1>
</A>
<br>
<A href="javascript:AddToShoppingCart();">购物车</A>
</UL>
</div>
<div style="float: left;">
<UL style="MARGIN-TOP: 8px">
<A href="Regedit.jsp"
target=_blank><IMG alt=注册三方图书网会员，买特价打折书
src="temp.files/shopshow.jpg" border=0>
</A>
<br>
<A href="Regedit.jsp"
target=_blank>注册会员</A>
</UL>
</div>
<div style="float: left;">
<UL style="MARGIN-TOP: 8px">
<A href="my_Account.jsp"><IMG
alt=查看您的个人帐户 src="temp.files/onlinehelp.jpg" border=0>
</A>
<br>
<A href="my_Account.jsp"
target=_blank>我的帐户</A>
</UL>
</div>
<div style="float: left;width:285px;">
<UL style="MARGIN-TOP: 13px">
<A href="frame.htm" target=_blank><IMG
alt=欢迎光临三方图书网 src="temp.files/logo.gif" border=0>
</A>
</UL>
</div>
</div>
<DIV class=br> </DIV>
<div style="absolute; top: 100px;">
<DIV class=guide">
<UL>
<A id=glitter href="Sort.jsp?sort=特价图书">
<FONT size=+0>特价图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=文学图书">
<FONT size=+0>文学图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=生活图书">
<FONT size=+0>生活图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=经管图书">
<FONT size=+0>经管图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=社科图书">
<FONT size=+0>社科图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=艺术图书">
<FONT size=+0>艺术图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=少儿图书">
<FONT size=+0>少儿图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=礼品图书">
<FONT size=+0>礼品图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=新书上架"">
<FONT size=+0>新书上架</FONT></A>|
<A id=glitter href="Sort.jsp?sort=哲学图书"">
<FONT size=+0>哲学图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=农业科学图书">
<FONT size=+0>农业科学图书</FONT></A>
</UL>
<br>
<UL>
<A id=glitter href="Sort.jsp?sort=农业科学">
<FONT size=+0>集团购买</FONT></A>|
<A id=glitter href="Sort.jsp?sort=农业科学">
<FONT size=+0>语言图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=考试图书">
<FONT size=+0>考试图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=教材图书">
<FONT size=+0>教材书店</FONT></A>|
<A id=glitter href="Sort.jsp?sort=计算机技术">
<FONT size=+0>计算机书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=建筑图书">
<FONT size=+0>建筑图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=医学图书">
<FONT size=+0>医学图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=法律图书">
<FONT size=+0>法律图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=外文原版">
<FONT size=+0>外文原版</FONT></A>|
<A id=glitter href="Sort.jsp?sort=音乐图书">
<FONT size=+0>音乐图书</FONT></A>|
<A id=glitter href="Sort.jsp?sort=自然科学数">
<FONT size=+0>自然科学图书</FONT></A>
</UL></DIV>
</div><br>
<div>
<div style="float:left; width: 140px; "> </div>
<DIV class=s1><br></DIV><br><DIV class=s3><br></DIV></DIV>
<DIV class=s4><br><SPAN class=red></SPAN></DIV>
</div>
<div
style="position: absolute; top: 171px; left: 135px; width: 865px; border-top: 2px solid green; border-bottom: 2px solid green; border-left: 2px solid green; border-right: 2px solid green;">
<div id = "main">
<DIV class=br> </DIV>
<div style="float: center;">
<font size="2">总<%=pager.getTotalRecord()%>条记录|总<%=pager.getTotalPage()%>页|当前<%=pager.getCurrentPage() + 1%>页|每页<%=pager.getPageSize()%>条|
<%
//如果已经到了首页就去掉前一页的链接
if (pager.getCurrentRecord() - pager.getPageSize() < 0)
out.println("首页|");
else
//上一页就是把当前记录位置减去一页显示记录的条数
out.print("<a href='Sort.jsp?sort="+sort+"¤tRecord="
+ (pager.getCurrentRecord() - pager.getPageSize())
+ "&pageSize=" + pager.getPageSize() + "'>上一页</a>|");
//如果到了尾页就去掉下一页的链接
if (pager.getCurrentRecord() + pager.getPageSize() > pager
.getTotalRecord())
out.println("尾页");
else
//下一页就是把当前记录位置加上一页显示记录的条数
out.print("<a href='Sort.jsp?sort="+sort+"¤tRecord="
+ (pager.getCurrentRecord() + pager.getPageSize())
+ "&pageSize=" + pager.getPageSize() + "'>下一页</a>|");
%> </font>
</div>
<DIV class=week>
<DIV class=item-list>
<%
if (subResult.isEmpty() == false) {
for (int i = 0; i < subResult.size(); i++) {
Goods good = subResult.get(i);
out.print("<DIV class=itema>");
out.print("<DIV class=bookshop>");
out.print("<A href='" + "detailinform.jsp?goodID=" + good.getBookid() + "' target=_blank>"
+ good.getSort() + "</A></DIV>");
out.print("<DIV style='width:195px; height:150px;'> <A href='" + "detailinform.jsp?goodID=" + good.getBookid()
+ "' target=_blank><IMG src='" + good.getImageurl()
+ "'></A></DIV>");
out.print("<DIV style='width:195px; height:20px;overflow:auto;'> <A href='" + "detailinform.jsp?goodID=" + good.getBookid()
+ "' target=_blank><STRONG>" + good.getBookname()
+ "</STRONG></A></DIV><DIV style='width:195px; height:23px;'><STRONG> ￥"
+ good.getPrice() + "</STRONG></DIV>");
out.print("<UL><DIV style='width:195px; height:23px;overflow:auto;COLOR: #f37114;'>"
+ good.getAuthor() + "</DIV>");
out.print("<DIV style='width:195px; height:23px;overflow:auto;COLOR: #f37114;'>"
+ good.getPublish() + "</DIV>");
out.print("<DIV style='width:195px; height:23px;overflow:auto;COLOR: #f37114;'>" + good.getSort()
+ "</DIV>");
out.print("</UL></DIV>");
}
}
%>
</DIV>
</DIV>
<DIV class=br></DIV>
<div style="float: center;">
<font size="2">总<%=pager.getTotalRecord()%>条记录|总<%=pager.getTotalPage()%>页|当前<%=pager.getCurrentPage() + 1%>页|每页<%=pager.getPageSize()%>条|
<%
//如果已经到了首页就去掉前一页的链接
if (pager.getCurrentRecord() - pager.getPageSize() < 0 )
out.println("首页|");
else
//上一页就是把当前记录位置减去一页显示记录的条数
out.print("<a href='Sort.jsp?sort=" + sort + "¤tRecord="
+ (pager.getCurrentRecord() - pager.getPageSize())
+ "&pageSize=" + pager.getPageSize() + "'>上一页</a>|");
//如果到了尾页就去掉下一页的链接
if (pager.getCurrentRecord() + pager.getPageSize() > pager.getTotalRecord()
|| pager.getCurrentRecord() + pager.getPageSize() == pager.getTotalRecord())
out.println("尾页");
else
//下一页就是把当前记录位置加上一页显示记录的条数
out.print("<a href='Sort.jsp?sort=" + sort + "¤tRecord="
+ (pager.getCurrentRecord() + pager.getPageSize())
+ "&pageSize=" + pager.getPageSize() + "'>下一页</a>|");
%> </font>
</div>
<DIV class=br> </DIV>
</div>
</div>
<div
style="position: absolute; top: 1150px; left: 0px; height: 200px; width: 1000px; border-top: 0px solid blue; border-bottom: 0px solid blue; border-left: 0px solid blue; border-right: 0px solid blue; margin-top:5px">
<DIV class=booksbot-text>
<UL>
<LI>
客服电话:********** (工作时间:****************)
<LI style="PADDING-LEFT: 95px">
010－82389225 (工作时间：********;*******)
<LI>
传真：******** 客户服务E-mail
<A href=></A>
<LI>
<A href="" target=_blank>经营许可证编号:*********</A>
<A href=""
target=_blank>***监发******</A>
<LI>
<A href=""
target=_blank><IMG
src="temp.files/ectrust.gif">
</A>
<A
href=""
target=_blank><IMG height=48
src="temp.files/biaoshi.gif" width=40>
</A>
<A href=""
target=_blank><IMG
src="temp.files/315online.gif">
</A>
</LI>
</UL>
</DIV>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -