📄 orderlist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="Connections/myesale.jsp" %>
<%
String upd_details__ordid = null;
if(session.getValue("ordid") != null){ upd_details__ordid = (String)session.getValue("ordid");}
%>
<%
Driver Driverupd_details = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connupd_details = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement upd_details = Connupd_details.prepareStatement("UPDATE orderdetails SET ord_checkout='Y' WHERE ord_id="+ upd_details__ordid + " ");
upd_details.executeUpdate();
%>
<%
String recinfo__MMColParam = "1";
if (session.getValue("ordid") !=null) {recinfo__MMColParam = (String)session.getValue("ordid");}
%>
<%
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 reclist__MMColParam = "2";
if (session.getValue("ordid") !=null) {reclist__MMColParam = (String)session.getValue("ordid") ;}
%>
<%
Driver Driverreclist = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connreclist = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement Statementreclist = Connreclist.prepareStatement("SELECT ord_quantity,prod_name,prod_price,(prod_price*ord_quantity) as Subtotal FROM orderdetails,product WHERE ord_id = " + reclist__MMColParam + " and ord_prodid=prod_id");
ResultSet reclist = Statementreclist.executeQuery();
boolean reclist_isEmpty = !reclist.next();
boolean reclist_hasData = !reclist_isEmpty;
Object reclist_data;
int reclist_numRows = 0;
%>
<%
String reccust__MMColParam = "amber";
if (session.getValue("MM_Username") !=null) {reccust__MMColParam = (String)session.getValue("MM_Username");}
%>
<%
Driver Driverreccust = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connreccust = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement Statementreccust = Connreccust.prepareStatement("SELECT * FROM customers WHERE username = '" + reccust__MMColParam + "'");
ResultSet reccust = Statementreccust.executeQuery();
boolean reccust_isEmpty = !reccust.next();
boolean reccust_hasData = !reccust_isEmpty;
Object reccust_data;
int reccust_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
reclist_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;
}
.style5 {font-size: 32px}
.style7 {
color: #2994BE;
font-weight: bold;
font-size: 30px;
}
.style9 {
font-size: 36px;
font-family: "金梅浪漫反白字";
}
.box {border: thick solid #E68989;
}
.样式13 {font-size: 18px}
.style20 {
color: #FFFFFF;
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="7"><img src="images/esale_title.jpg" width="760" height="136"></td>
</tr>
<tr background="images/life_23.gif">
<td height="20" colspan="7" background="images/line_top.gif"> </td>
</tr>
<tr>
<td width="21" rowspan="3" background="images/line_top.gif"> </td>
<td width="15" rowspan="3" valign="top"> </td>
<td align="right" valign="top"><img src="images/border_ul.gif" width="50" height="51"></td>
<td width="548"><div align="center" class="样式2 style9"><img src="images/shop_car.gif" width="35" height="35" align="absmiddle">购物清单</div></td>
<td width="50" align="left" valign="top"><img src="images/border_ur.gif" width="50" height="51"></td>
<td width="15" rowspan="3"> </td>
<td width="20" rowspan="3" background="images/line_top.gif"> </td>
</tr>
<tr>
<td width="50" height="207"> </td>
<td valign="top"><div align="center"></div>
<table width="100%" border="0" class="box">
<tr>
<td><div align="center">
<table width="100%" border="2" bordercolor="#999999">
<tr bgcolor="#FFFFFF">
<td height="40" colspan="2"><div align="center" class="style1 style5"> <span class="style7">订单明细</span></div></td>
</tr>
<tr bgcolor="#99FF66">
<td><div align="right" class="style1">订购日期</div></td>
<td><div align="left" class="样式2"><%=(((recinfo_data = recinfo.getObject("ord_date"))==null || recinfo.wasNull())?"":recinfo_data)%></div></td>
</tr>
<tr bgcolor="#99FF66">
<td width="23%"><div align="right" class="style1">收货人</div></td>
<td width="77%"><div align="left" class="样式2"><%=(((recinfo_data = recinfo.getObject("ord_toname"))==null || recinfo.wasNull())?"":recinfo_data)%> </div></td>
</tr>
<tr bgcolor="#99FF66">
<td><div align="right" class="style1">收货人电话</div></td>
<td><div align="left" class="样式2"><%=(((recinfo_data = recinfo.getObject("ord_tel"))==null || recinfo.wasNull())?"":recinfo_data)%></div></td>
</tr>
<tr bgcolor="#99FF66">
<td><div align="right" class="style1">收货人地址</div></td>
<td><div align="left" class="样式2"><%=(((recinfo_data = recinfo.getObject("ord_address"))==null || recinfo.wasNull())?"":recinfo_data)%> </div></td>
</tr>
<tr bgcolor="#99FF66">
<td><div align="right" class="style1">送货日期</div></td>
<td><div align="left" class="样式2"><%=(((recinfo_data = recinfo.getObject("ord_senddate"))==null || recinfo.wasNull())?"":recinfo_data)%> </div></td>
</tr>
<tr bgcolor="#99FF66">
<td><div align="right" class="style1">付款方式</div></td>
<td><div align="left" class="样式2"><%=(((recinfo_data = recinfo.getObject("ord_paytype"))==null || recinfo.wasNull())?"":recinfo_data)%> </div></td>
</tr>
</table>
</div>
<div align="center">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#666666">
<tr bgcolor="#9999FF">
<td colspan="5"><div align="center" class="style20">购买商品</div></td>
</tr>
<tr>
<td width="14%">编号</td>
<td width="26%">商品名称</td>
<td width="18%">单价</td>
<td width="22%">数量</td>
<td>小计</td>
</tr>
<% while ((reclist_hasData)&&(Repeat1__numRows-- != 0)) { %>
<tr>
<td> </td>
<td><%=(((reclist_data = reclist.getObject("prod_name"))==null || reclist.wasNull())?"":reclist_data)%></td>
<td><%=(((reclist_data = reclist.getObject("prod_price"))==null || reclist.wasNull())?"":reclist_data)%></td>
<td><%=(((reclist_data = reclist.getObject("ord_quantity"))==null || reclist.wasNull())?"":reclist_data)%></td>
<td>$<%=(((reclist_data = reclist.getObject("Subtotal"))==null || reclist.wasNull())?"":reclist_data)%></td>
</tr>
<%
Repeat1__index++;
reclist_hasData = reclist.next();
}
%>
</table>
</div>
<p align="center">交易总金额：<span class="style1"><%=(((recinfo_data = recinfo.getObject("ord_total"))==null || recinfo.wasNull())?"":recinfo_data)%></span>元</p></td>
</tr>
</table></td>
<td width="50"> </td>
</tr>
<tr>
<td align="right" valign="top"><img src="images/border_dl.gif" width="50" height="51"></td>
<td width="548"><div 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></div></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();
%>
<%
reclist.close();
Statementreclist.close();
Connreclist.close();
%>
<%
reccust.close();
Statementreccust.close();
Connreccust.close();
%>
<%
Connupd_details.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -