📄 doneorder.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="bean.GoodsOrder" %>
<%@ page import="bean.GoodsOrderDao" %>
<jsp:useBean id="GoodsOrder" class="bean.GoodsOrder" scope="page"></jsp:useBean>
<jsp:useBean id="GoodsOrderDao" class="bean.GoodsOrderDao" scope="page"></jsp:useBean>
<jsp:useBean id="pager" class="Orders.Page" scope="page"></jsp:useBean>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
String sql="select * from goodsorder where state=1";
//从数据库中去出结果集
int currentRecord = 0;
ArrayList<GoodsOrder> result = GoodsOrderDao.orderSelect(sql);
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)
{
subResult = result.subList(0,pager.getPageSize());
}
if(pager.getCurrentRecord()+pager.getPageSize()<result.size())
subResult = result.subList(pager.getCurrentRecord(),pager.getCurrentRecord()+pager.getPageSize());
else
subResult = result.subList(pager.getCurrentRecord(),result.size());
%>
<html>
<head>
<title>网上书店系统</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<link rel="stylesheet" href="images/css.css" type="text/css" media="screen">
</head>
<body text="#000000" topmargin=0>
<!-- 全部订单的列表 -->
<table width="98%" border="1" cellpadding="2" cellspacing="0" align="center" class=TableBorder>
<tr height="22" valign="middle" align="center">
<th height="25" colspan="10">管理订单</th>
</tr>
<!--订单列表的表头 -->
<tr>
<td width="4%" height="25" class=forumrow>
<div align="center">订单号</div>
</td>
<td width="8%" height="25" class=forumrow>
<div align="center">收货人</div>
</td>
<td width="8%" height="25" class=forumrow>
<div align="center">支付方式</div>
</td>
<td width="8%" height="25" class=forumrow>
<div align="center">价格</div>
</td>
<td width="8%" height="25" class=forumrow>
<div align="center">下单时间</div>
</td>
<td width="8%" height="25" class=forumrow>
<div align="center">所属用户</div>
</td>
<td width="10%" height="25" class=forumrow>
<div align="center">审核</div>
</td>
<td width="10%" height="25" class=forumrow>
<div align="center">操作</div>
</td>
</tr>
<!--循环显示所有的订单-->
<%
if(subResult.isEmpty() == false) {
for(int i=0; i<subResult.size(); i++) {
String word;
GoodsOrder order = subResult.get(i);
out.print("<tr>");
out.print("<td>" + order.getOrdernumber() + "</td>");
out.print("<td>" + order.getReceiver() + "</td>");
out.print("<td>" + order.getHowtopay() + "</td>");
out.print("<td>" + order.getCost() + "</td>");
out.print("<td>" + order.getOrdertime() + "</td>");
out.print("<td>" + order.getUsername() + "</td>");
out.print("<td>" + "已审核" + "</td>");
out.print("<td>" + "<a href="+"/gouwuche3/Mandelete?del="+order.getOrdernumber()+">"+"删除订单"+"</a>" + "</td>");
out.print("<tr>");
}
}
%>
<span><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='DoneOrder.jsp?currentRecord="+(pager.getCurrentRecord()-pager.getPageSize())+"&pageSize="+pager.getPageSize()+"'>上一页</a>|");
//如果到了尾页就去掉下一页的链接
if(pager.getCurrentRecord()+pager.getPageSize()>pager.getTotalRecord())
out.println("尾页");
else
//下一页就是把当前记录位置加上一页显示记录的条数
out.print("<a href='DoneOrder.jsp?currentRecord="+(pager.getCurrentRecord()+pager.getPageSize())+"&pageSize="+pager.getPageSize()+"'>下一页</a>|");
%>
</font></span>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -