?? showorder.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*,bookshop.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<html>
<title>查詢訂單詳細資料
</title>
<%
String orderid= request.getParameter("orderid");
OrderBean xie=new OrderBean();
String str="select * from consignee where orderid='"+orderid+"' order by id desc";
ConsigneeBean xx=new ConsigneeBean();
ArrayList consignee= xx.selectConsignee(str);
ArrayList orders= xie.selectOrders(orderid);
request.setAttribute("consignee",consignee);
request.setAttribute("orders",orders);
%>
<c:set var="connsignee" value="${requestScope.consignee}" scope="page"/>
<c:set var="orders" value="${requestScope.orders}" scope="page"/>
<style type="text/css">
<!--
.style1 {font-size: 24px;
font-weight: bold;
color: #FF0000;
}
.style3 {font-size: 16px}
-->
</style>
<body bgcolor="#799AE1">
<table width=100% height="28" border=1 cellpadding=0 cellspacing=0 bordercolor=#6a7f9a background="image/1.gif" style="border-collapse:collapse;" >
<tr>
<td height=25 align=center><span class="style1"> <img src="image/v001.jpg" width="19" height="16"> <span class="style3">更新訂單</span></span></td>
</tr>
</table>
<br>
<form action="updateOrder.jsp?action=update&orderid=<%=orderid%>" method="post">
<c:forEach var="myuser" items="${connsignee}" >
<table width=100% border="01" align=center cellspacing="2" bordercolor="#6a7f8a" bgcolor="#edecf4" >
<tr>
<td width="30%" height="30"><font size=2>訂單編號: </font><font size=2 color="red"><u><%=orderid%></font></td>
<td width="40%"><font size=2>下單日期: ${myuser.submittime}</font> </td>
<td width="30%"><font size=2>發貨日期:${myuser.consigndate}</font></td>
</tr>
</table>
<table width="100%" height="29" border=1 align=center
cellspacing=0 bordercolor=#edecf4 bgcolor="#FFFFFF" style="border-collapse:collapse">
<tr >
<td width=51% align=center height=20><font size=2 color=#333333>收貨人詳細資料</font></td>
</tr>
</table>
<table width="100%" height="160" border=1 align=center
cellspacing=2 bordercolor=#6a7f9a bgcolor="#FFFFFF" style="border-collapse:collapse">
<tr >
<td width=30% height="29" align=center><font size=2>收貨人姓名:</font></td>
<td width=24% align=center><font size=2>${myuser.consignName}</font></td>
<td width=23% align=center><font size=2>性 別:</font></td>
<td width=23% align=center><font size=2>${myuser.sex}</font></td>
</tr>
<tr >
<td width=30% height="32" align=center><font size=2>OICQ號碼:</font></td>
<td align=center><font size=2>${myuser.qq}</font></td>
<td align=center><font size=2>郵 編:</font></td>
<td align=center><font size=2>${myuser.zip}</font></td>
</tr>
<tr >
<td width=30% height="26" align=center><font size=2>E-MAIL地址:</font></td>
<td align=center><font size=2>${myuser.email}</font></td>
<td align=center><font size=2>付款方式</font>:</td>
<td align=center><font size=2>${myuser.payclass}</font></td>
</tr>
<tr >
<td width=30% height="28" align=center><font size=2>聯系電話:</font></td>
<td align=center width=24%><font size=2>${myuser.tel}</font></td>
<td width=23% align=center><font size=2>付款狀態:</font></td>
<td width=23% align=center><font size=2>
<select name="txtispay" id="txtispay">
<c:choose>
<c:when test="${myuser.ispay=='已付款'}">
<option selected value="已付款">已付款</option>
<option value="未付款">未付款</option>
</c:when>
<c:otherwise>
<option selected value="未付款">未付款</option>
<option value="已付款">已付款</option>
</c:otherwise>
</c:choose>
</select>
</font></td>
</tr>
<tr >
<td width=30% align=center><font size=2>收貨人地址:</font></td>
<td align=center><font size=2>${myuser.address}</font></td>
<td align=center><font size=2>發貨狀態</font>:</td>
<td align=center> <font size=2>
<select name="txtissales" id="txtissales">
<c:choose>
<c:when test="${myuser.issales=='未發貨'}">
<option selected value="未發貨">未發貨</option>
<option value="已發貨">已發貨</option>
</c:when>
<c:otherwise>
<option selected value="已發貨">已發貨</option>
<option value="未發貨">未發貨</option>
</c:otherwise>
</c:choose>
</select>
</font></td>
</tr>
</table>
</c:forEach>
<table width="100%" height="29" border=1 align=center
cellspacing=0 bordercolor=#edecf4 bgcolor="#FFFFFF" style="border-collapse:collapse">
<tr >
<td width=51% align=center height=20><font size=2 color=#333333>圖書詳細資料</font></td>
</tr>
</table>
<table width=100% height="30" border=1 align=center cellpadding=0 cellspacing=2 bordercolor=#6a7f8a bgcolor="#edecf4" style="border-collapse:collapse;" >
<tr>
<td height=24 width=30% align=center><font size=2>圖書名稱</font></td>
<td width=24% align=center><font size=2>圖書單價</font></td>
<td width=23% align=center><font size=2>訂購數量</font></td>
<td width=22% align=center><font size=2>應付金額 </font></td>
</tr>
</table>
<c:set var="sum" scope="page" /> <c:set var="count" scope="page" />
<table width="100%" border=1 align=center
cellspacing=2 bordercolor=#6a7f9a bgcolor="#FFFFFF" style="border-collapse:collapse">
<c:forEach var="myorder" items="${orders}">
<tr >
<td width=31% height="25" align=center><font size=2>${myorder.ordername}</font></td>
<td width=24% align=center><font size=2>${myorder.price}</font></td>
<td width=22% align=center><font size=2>${myorder.amount}</font></td>
<td width=23% align=center><font size=2>${myorder.totalprice}</font></td>
<c:set var="sum" value="${sum+myorder.totalprice}" scope="page"/>
<c:set var="count" value="${count+myorder.amount}" scope="page"/>
</tr>
</c:forEach>
<tr>
<td colspan=4 align=right><div align="right"><font size=2>
<input name="imageField" type="image" src="image/sendorder.gif" width="61" height="20" border="0">
圖書總數:</font><font size=2 color=red>${count}</font>(本) 總金額:<font size=2 color=red> </font><font size=2 color=red></font><font size=2 color=red><fmt:formatNumber var="mysum" value="${sum}" type="currency"/>${mysum}</font>元</div></td>
</tr>
</table>
<br>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -