📄 orderdetails.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="Connections/myesale.jsp" %>
<%
String recinfo__MMColParam = "1";
if (request.getParameter("ord_id") !=null) {recinfo__MMColParam = (String)request.getParameter("ord_id");}
%>
<%
Driver Driverrecinfo = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connrecinfo = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement Statementrecinfo = Connrecinfo.prepareStatement("SELECT * FROM orders WHERE ord_id = " + recinfo__MMColParam + "");
ResultSet recinfo = Statementrecinfo.executeQuery();
boolean recinfo_isEmpty = !recinfo.next();
boolean recinfo_hasData = !recinfo_isEmpty;
Object recinfo_data;
int recinfo_numRows = 0;
%>
<%
String recdetails__MMColParam = "1";
if (request.getParameter("ord_id") !=null) {recdetails__MMColParam = (String)request.getParameter("ord_id");}
%>
<%
Driver Driverrecdetails = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connrecdetails = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement Statementrecdetails = Connrecdetails.prepareStatement("SELECT ord_prodid,ord_quantity,prod_name,prod_price,(prod_price*ord_quantity) as Subtotal FROM orderdetails,product WHERE ord_id = " + recdetails__MMColParam + " and ord_prodid=prod_id");
ResultSet recdetails = Statementrecdetails.executeQuery();
boolean recdetails_isEmpty = !recdetails.next();
boolean recdetails_hasData = !recdetails_isEmpty;
Object recdetails_data;
int recdetails_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
recdetails_numRows += Repeat1__numRows;
%>
<!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">
<title>账户管理－订单明细</title>
<style type="text/css">
<!--
.style1 {color: #0000FF}
.样式2 {color: #FF6600}
.style4 {
font-family: "金梅浪漫反白字";
font-weight: bold;
font-size: 24px;
color: #2994BE;
}
.style9 {
font-size: 36px;
font-family: "金梅浪漫反白字";
}
.style8 {color: #009933}
.style10 {font-size: 14px}
-->
</style>
</head>
<body>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="7"><table width="200" border="3" align="center" cellpadding="2" cellspacing="1" bordercolor="#FFDEC1" class="style8">
<tr>
<td><img src="images/esale_title.jpg" width="760" height="120"></td>
</tr>
</table></td>
</tr>
<tr background="images/life_23.gif">
<td height="20" colspan="7" background="images/line_top.gif"> </td>
</tr>
<tr>
<td width="23" rowspan="3" background="images/line_top.gif"> </td>
<td width="16" rowspan="3" valign="top"> </td>
<td align="right" valign="top"><img src="images/border_ul.gif" width="50" height="51"></td>
<td width="598"><div align="center" class="样式2 style9"><img src="images/ico_item.gif" width="40" height="39" align="absmiddle">订单明细</div></td>
<td width="50" align="left" valign="top"><img src="images/border_ur.gif" width="50" height="51"></td>
<td width="16" rowspan="3"> </td>
<td width="21" rowspan="3" background="images/line_top.gif"> </td>
</tr>
<tr>
<td width="50" height="285"> </td>
<td width="598" rowspan="2" valign="top"><TABLE borderColor="#d8d7da" cellSpacing="0" cellPadding="5" width="100%" border="1">
<TBODY>
<TR>
<TD bgColor="#ffebb4" colSpan="2"><span class="style10">订单基本资料</span></TD>
</TR>
<TR bgColor="#ffffff">
<TD vAlign="top" width="50%"><TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
<TBODY>
<TR>
<TD align="right" width="40%">订单编号：</TD>
<TD width="69%"><%=(((recinfo_data = recinfo.getObject("ord_id"))==null || recinfo.wasNull())?"":recinfo_data)%></TD>
</TR>
<TR>
<TD align="right">订购日期：</TD>
<TD><%=(((recinfo_data = recinfo.getObject("ord_date"))==null || recinfo.wasNull())?"":recinfo_data)%></TD>
</TR>
<TR>
<TD vAlign="top" align="right">付款方式：</TD>
<TD>
<% String paystring="";
int paytype=recinfo.getInt("ord_paytype");
if (paytype==1) paystring="ATM转帐";
else paystring="邮政划拨";%>
<%=paystring%></TD>
</TR>
</TBODY>
</TABLE></TD>
<TD vAlign="top"><TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
<TBODY>
<TR>
<TD align="right" width="40%">收货人姓名：</TD>
<TD width="69%"><%=(((recinfo_data = recinfo.getObject("ord_toname"))==null || recinfo.wasNull())?"":recinfo_data)%></TD>
</TR>
<TR>
<TD align="right">收货人电话：</TD>
<TD><%=(((recinfo_data = recinfo.getObject("ord_tel"))==null || recinfo.wasNull())?"":recinfo_data)%></TD>
</TR>
<TR>
<TD align="right">收货人地址：</TD>
<TD><%=(((recinfo_data = recinfo.getObject("ord_address"))==null || recinfo.wasNull())?"":recinfo_data)%></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
订单状态<strong>：</strong> <BR>
<TABLE borderColor="#d8d7da" cellSpacing="0" cellPadding="2" width="100%" border="1">
<TBODY>
<TR align="middle" bgColor="#ffebb4">
<TD>商品编号</TD>
<TD>商品明细</TD>
<TD>数量</TD>
<TD>单价</TD>
<TD>小计</TD>
</TR>
<% while ((recdetails_hasData)&&(Repeat1__numRows-- != 0)) { %>
<TR align="middle" bgColor="#ffffff">
<TD><%=(((recdetails_data = recdetails.getObject("ord_prodid"))==null || recdetails.wasNull())?"":recdetails_data)%></TD>
<TD><%=(((recdetails_data = recdetails.getObject("prod_name"))==null || recdetails.wasNull())?"":recdetails_data)%></TD>
<TD><%=(((recdetails_data = recdetails.getObject("ord_quantity"))==null || recdetails.wasNull())?"":recdetails_data)%></TD>
<TD><%=(((recdetails_data = recdetails.getObject("prod_price"))==null || recdetails.wasNull())?"":recdetails_data)%></TD>
<TD><%=(((recdetails_data = recdetails.getObject("Subtotal"))==null || recdetails.wasNull())?"":recdetails_data)%></TD>
</TR>
<%
Repeat1__index++;
recdetails_hasData = recdetails.next();
}
%>
</TBODY>
</TABLE>
<div align="right"><br>
交易总金额：<span class="style1"></span><%=(((recinfo_data = recinfo.getObject("ord_total"))==null || recinfo.wasNull())?"":recinfo_data)%>元<BR>
</div>
<TABLE borderColor="#d8d7da" cellSpacing="0" cellPadding="8" width="100%" border="0">
<TBODY>
<TR align="right">
<TD><A href="http://shopping.pchome.com.tw/ec_service/s_bounse.php" target="_blank"></A></TD>
</TR>
</TBODY>
</TABLE>
<!-- 联系我们 -->
<TABLE borderColor="#d8d7da" cellSpacing="0" cellPadding="8" width="100%" border="0">
<TBODY>
<TR align="left">
<TD>说明：<BR>
<LI>完成付款后，约5个工作日才可查询出货进度!
<LI>已有出货日，约需2～3个工作日送达，因为运送和整合包装需要时间! <BR>
</LI></TD>
</TR>
</TBODY>
</TABLE>
<p align="center"><a href="esale.jsp"><img src="images/ico_back.gif" width="37" height="32" border="0" align="absmiddle"></a><span class="style4">回首页</span>
<label></label>
</p></td>
<td width="50"> </td>
</tr>
<tr>
<td align="right" valign="top"><img src="images/border_dl.gif" width="50" height="51"></td>
<td align="left" valign="top" background="ima"><img src="images/border_dr.gif" width="50" height="51"></td>
</tr>
<tr>
<td height="20" colspan="7" background="images/line_top.gif"> </td>
</tr>
</table>
</body>
</html>
<%
recinfo.close();
Statementrecinfo.close();
Connrecinfo.close();
%>
<%
recdetails.close();
Statementrecdetails.close();
Connrecdetails.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -