📄 select_order.jsp
字号:
<%@ page language="java" import="java.util.*" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%>
<%@ page import="bean.GoodsOrder" %>
<jsp:useBean id="GoodsOrderDao" class="bean.GoodsOrderDao" scope="page"></jsp:useBean>
<jsp:useBean id="pager" class="lp.Page" scope="page"></jsp:useBean>
<%
String sql = null;
if(session.getAttribute("sqlselectorder") == null)
sql = "select * from goodsorder where username = '" + session.getAttribute("username") + "' && state = 1 ";
else
sql = session.getAttribute("sqlselectorder").toString();
//从数据库中去出结果集
int currentRecord = 0;
ArrayList<GoodsOrder> result = GoodsOrderDao.orderSelect(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<GoodsOrder> 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());
%>
<script language="javascript">
</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<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>用户个人帐户管理</title>
</head>
<body>
<!---top start--->
<div>
<div
style="position: absolute; top: 0px; left: 0px;height: 200px; width: 1000px; border-top: 2px solid blue;
border-bottom: 2px solid blue; border-left:2px solid blue; border-right: 2px 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=""><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="Buy.jsp">购物车</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>
<div
style="position: absolute; top: 0px; left: 0px;height: 200px; width: 1000px; border-top: 2px solid blue;
border-bottom: 2px solid blue; border-left:2px solid blue; border-right: 2px 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=""><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="Buy.jsp">购物车</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=农业科学图书">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -