📄 orderdetail.jsp
字号:
<%@ page contentType="text/html; charset=utf-8" language="java"
import="java.sql.*" errorPage=""%>
<%@ page import="com.test.ps.order.*"%>
<%
String orderID = null;
String userName="";
orderID = (String) request.getParameter("orderid");
String saleAddr = ""; //收货地址
Connection conn = DB.getConnection();
String sql = "select * from sale where saleId=" + orderID;
if (orderID != null) {
ResultSet rs = DB.executeQuery(conn, sql);
//int goodID = -1;
String goodID="";
String goodsname = "";
float nowprice = 0;
int number = 0;
if (rs.next()) {
orderID = rs.getString("saleId");
saleAddr = rs.getString("saleAddr");
userName=rs.getString("username");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>订单详情</title>
<link href="../img/adminStyle.css" type="text/css" rel="stylesheet" />
<style type="text/css">
<!--
.STYLE2 {font-weight: bold}
-->
</style>
</head>
<body>
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="80" colspan="3">
<jsp:include page="../adminTop.jsp" flush="true"/></td>
</tr>
<tr>
<td colspan="3" height="30" bgcolor="#e6f3ff"><span class="STYLE2"><a href="../adminRight.jsp">首页</a>><a href="javascript:history.go(-1)">订单列表</a>>订单详情</span></td>
</tr>
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="3" height="30"><hr size="5" color="#e6f3ff"></td>
</tr>
<tr>
<td height="30" align="left"><h1>订单详情</h1></td>
</tr>
<tr>
<td valign="top" height="91">
<table border="0" cellspacing="0" cellpadding="0" align="left" width="662">
<tr>
<td height="30" colspan="2" align="center">
<div align="left">订 单 号： <%=orderID%> </div></td>
</tr>
<tr>
<td width="502" height="30" align="center">
<div align="left">用 户 名： <%=userName%></div></td>
</tr>
<tr><td height="30" colspan="2" align="center"><div align="left">地 址: <%=saleAddr%></div></td><td valign="top"></td></tr>
<tr><td height="30" colspan="2" align="center">
<div align="left"><a href="../userManage/userInf.jsp?userName=<%=userName%>">——点击查看用户信息——</a></div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" >
<table width="80%" border="0" cellspacing="1" cellpadding="0" align="left">
<tr align="center" bgcolor="#CBEDFE">
<td width="20%" height="24">商品名称</td>
<td width="20%" align="center">商品编号</td>
<td width="20%" align="center">单价</td>
<td width="20%" align="center" bgcolor="#CBEDFE">数量</td>
</tr>
<%
sql="select * from saleItem where saleId='"+orderID+"'";
rs=DB.executeQuery(conn, sql);
while(rs.next()){
goodID=rs.getString("goodsCode");
goodsname=rs.getString("goodsname");
nowprice=rs.getFloat("sPrice");
number=rs.getInt("pNum");
%>
<tr align="center">
<td height="27" bgcolor="#E9F4F5"><%=goodsname%></td>
<td height="27" bgcolor="#E9F4F5"><%=goodID%></td>
<td bgcolor="#E9F4F5"><%=nowprice%>(元)</td>
<td bgcolor="#E9F4F5"><%=number%></td>
</tr>
<%}%>
</table>
<% }%>
</td>
</tr>
<tr>
<td colspan="3" height="30"><hr size="5" color="#e6f3ff"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="30" valign="top"></td>
</tr>
<tr>
<td><hr align="left" size="10" noshade color="#318EB7"></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -