📄 orderinfo.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">
s
</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="392"><img src="images/13.jpg" width="113" height="115"> 您的位置：<a href="/">HOME</a> >> 订单详细信息</td>
<td align="left" valign="bottom"><span class="style18"><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"><A href="usercenter.jsp">会员中心</A></span></td>
<td width="121" align="left" valign="bottom"><span class="style18"><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"><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">
<%
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 orderinfo where orderid="+"'"+orderid+"'";
rs=sql.executeQuery(condition);
while(rs.next())
{
String userid=rs.getString(2);
String accepter=rs.getString(3);
String acp_address=rs.getString(4);
String mess=rs.getString(5);
float total=rs.getFloat(6);
String orderdate=rs.getString(7);
String status=rs.getString(8);
String paytype=rs.getString(9);
String sendtime=rs.getString(10);
String paid=rs.getString(11);
%>
</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%"><%=orderid%>
</td>
<td width="20%" align="right"><font color="#545454">会员ID：</font></td>
<td width="30%"><%=userid%></td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">订购时间：</font></td>
<td><%=orderdate%></td>
<td align="right"><font color="#545454">付款方式：</font></td>
<td><%=paytype%> </td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">总消费额：</font></td>
<td><%=total%></td>
<td align="right"><font color="#545454">订单状态：</font></td>
<td><%=status%>
</td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">送货时间：</font></td>
<td><%=sendtime%>
</td>
<td align="right"><font color="#545454">支付状态：</font></td>
<td><%=paid%></td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right" ><font color="#545454">卡片留言：</font></td>
<td colspan="3"><%=mess%></td>
</tr>
<tr bgcolor="#FAF8F1">
<td align="right"><font color="#545454">送货地址：</font></td>
<td colspan="3" align="left"><%=acp_address%></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"><div align="center"><font color="#545454">细则</font></div></td>
<td width="30%"><div align="center"><font color="#545454">鲜花ID</font></div></td>
<td width="20%" align="right"><div align="center"><font color="#545454">订购量</font></div></td>
<td width="30%"><div align="center"><font color="#545454">查看</font></div></td>
</tr>
<%
String con1="select * from orderdetail where orderid="+"'"+orderid+"'";
rs=sql.executeQuery(con1);
int i=0;
while(rs.next())
{ i++;
String bid=rs.getString(2);
int num=rs.getInt(3);%>
<tr bgcolor="#FAF8F1">
<td align="right"><div align="center">第<%=i%>条</div></td>
<td><div align="center"><%=bid%> </div></td>
<td align="right"><div align="center"><%=num%></div></td>
<td><div align="center"><a href="item.jsp?id=<%=bid%>"><font color="#545454">查看</font></a></div></td>
</tr>
<%
}%>
</table>
<div align="center">
<input name="back" type="button" class="button" value="返回上一页" onClick="window.history.back()">
<br>
<br>
<font color="#FF0000">撤销订单请联系本站客服！</font> </div>
<br>
</td>
<td background="/images/6xiang_98.gif" width="11" ></td>
</tr>
<%
con.close();}
catch(SQLException e) { }
%>
</table></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -