📄 orderdetail.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>淳.清凉花坊</title>
<meta name="keywords" content="淳.清凉花坊">
<meta name="description" content="淳.清凉花坊">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/css/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style11 {color: #006633}
.style13 {
font-size: 12px;
color: #FFFFFF;
}
.style15 {
color: #660000;
font-size: 14px;
font-weight: bold;
}
.style16 {font-size: 12px}
.style17 {color: #006633; font-size: 12px; }
-->
</style>
</style>
</head>
<%! public String getString(String s)
{if(s==null) s="";
try {byte a[]=s.getBytes("ISO-8859-1");
s=new String(a);
}
catch(Exception e)
{}
return s;
}
%>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="858" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top">
<table id="Table_06" width="100%" height="274" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="/images/6xiang_93.gif" width="11"></td>
<td height="300" colspan="3" align="center" valign="top">
<table width="98%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="378"><img src="images/13.jpg" width="125" height="144"> 您的位置：<a href="/">HOME</a> >> 查看订单详细信息</td>
<td width="103" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><a href="index.jsp">花坊首页</a></span></td>
<td width="95" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><A href="usercenter.jsp">会员中心</A></span></td>
<td width="121" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><A href="cart.jsp">我的购物车</A></span></td>
<td width="120" align="left" valign="bottom"><span class="style18"><img src="images/arrow_right.gif"><img src="images/arrow_right.gif"><A href="help.jsp">帮助中心</A></span></td>
</tr>
</table>
<br>
<table width="99%" align="center" border="1" cellpadding="5" cellspacing="0" bordercolor="#ECDECE" bordercolordark="#FFFFFF">
<tr bgcolor="#ECDECE">
<td width="20%" align="center">鲜花编号</td>
<td width="20%" align="center">鲜花名称</td>
<td width="20%" align="center">单价</td>
<td width="20%" align="center">数量</td>
<td width="20%" align="center">总计</td>
</tr>
<%
String orderid=(String)request.getParameter("id");
orderid=getString(orderid);
Connection con=null;
Statement sql=null;
ResultSet rs=null;
ResultSet rs1=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { System.out.print("runing here"); }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
String condition="select * from orderdetail where orderid="+"'"+orderid+"'";
rs=sql.executeQuery(condition);
float total=0;
while(rs.next())
{
String bid=rs.getString(2);
int num=rs.getString(3);
String con1="select * from bouquet where bouquetid="+"'"+bid+"'";
rs1=sql.executeQuery(con1);
while(rs1.next())
{
String name=rs.getString("bouquetname");
String classify=rs.getString("classify");
float price=rs.getFloat("price");
String meaning=rs.getString("meaning");
String discript=rs.getString("discript");
total=total+price;
%>
<tr>
<td align="center"><%=bid%></td>
<td align="center"><%=name%></td>
<td align="center"><%=price%></td>
<td align="center"><%=num%></td>
<td align="center"><%=num%></td>
</tr>
<%
}
%>
<tr>
<td colspan="2" align="center"> </td>
<td align="center"> </td>
<td colspan="2" align="center">总金额：<%=total%></td>
</tr>
<%
}
%>
<form method="post" name="payForm" action="/user/order_pay.jsp" target="_blank">
<input type="hidden" name="amount" value="284.0">
<input type="hidden" name="orderId" value="10223">
</form>
</table>
<br>
<table width="90%" border="1" cellpadding="5" cellspacing="0" bordercolor="#ECDECE" bordercolordark="#FFFFFF">
<tr align="center" bgcolor="#ECDECE">
<td height="25" colspan="4" class="sstitle">购买人资料</td>
</tr>
<tr bgcolor="#FAF8F1">
<td width="20%" align="right" bgcolor="#FAF8F1"><font color="#545454">姓名：</font></td>
<td width="30%">宋伟
</td>
<td width="20%" align="right"><font color="#545454">Email：</font></td>
<td width="30%">chun.qingliang@163.com </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">联系电话：</font></td>
<td>123 </td>
<td align="right"><font color="#545454">手机：</font></td>
<td> </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">省份：</font></td>
<td>辽宁 </td>
<td align="right"><font color="#545454">城市：</font></td>
<td>葫芦岛
</td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">详细住址：</font></td>
<td colspan="3">123456547
</td>
</tr>
<tr align="center" bgcolor="#ECDECE">
<td height="25" colspan="4" class="sstitle">收货人资料</td>
</tr>
<tr bgcolor="#FAF8F1">
<td width="20%" align="right" bgcolor="#FAF8F1"><font color="#545454">姓名：</font></td>
<td width="30%">tiantian </td>
<td width="20%" align="right"><font color="#545454">Email：</font></td>
<td width="30%">chun.qingliang@163.com </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">联系电话：</font></td>
<td>0429-2492870 </td>
<td align="right"><font color="#545454">手机：</font></td>
<td>afggg </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">省份：</font></td>
<td>重庆 </td>
<td align="right"><font color="#545454">城市：</font></td>
<td>agsghh </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">详细住址：</font></td>
<td colspan="3">555 </td>
</tr>
<tr align="center" bgcolor="#ECDECE">
<td height="25" colspan="4" class="sstitle">其他配送信息</td>
</tr>
<tr bgcolor="#FAF8F1">
<td width="20%" align="right" bgcolor="#FAF8F1"><font color="#545454">送货日期：</font></td>
<td width="30%">2006-06-07 00:00:00.0
</td>
<td width="20%" align="right"><font color="#545454">送货时段：</font></td>
<td width="30%">不限时 </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">付款方式：</font></td>
<td>
网上支付
</td>
<td align="right"><font color="#545454">送货方式：</font></td>
<td>市区免费配送
</td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">特殊要求：</font></td>
<td colspan="3" style="line-height:18px; ">
</td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">留言：</font></td>
<td colspan="3" style="line-height:18px; ">
</td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">署名：</font></td>
<td colspan="3" style="line-height:18px; ">
</td>
</tr>
</table>
<div align="center">
<input name="back" type="button" class="button" value="返回上一页" onClick="window.history.back()">
<input name="bujiao" type="button" class="button" value="补缴花款" onClick="document.payForm.submit()">
<br>
<br>
<font color="#FF0000">撤销订单请联系本站客服！</font> </div>
<br>
</td>
<p>
<%
con.close();}
catch(SQLException e) { }
%>
</tr>
</table></td>
</tr>
</table>
<script language="javascript" src="/js/copyright.js"></script>
<script language="javascript" src="/js/service.js"></script>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -