📄 displayorder.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>untitled</title>
<link href="css/jdeveloper.css" rel="stylesheet" media="screen"/>
</head>
<body>
<P>
<%@ page import="Flower.model.DBConnect"%>
<%@ page import="java.util.*"%>
<%@ page import="Flower.model.Orderlist"%>
<%@ page import="Flower.model.Ordermain"%>
<%@ page import="java.sql.*"%>
</P>
<table cellspacing="0" cellpadding="0" border="0" width="578" align="left">
<tr>
<td>
<H1 align="center">订单查询结果</H1>
<form>
<table cellspacing="0" cellpadding="0" border="1" width="95%" align="center">
<%
Collection c=null;
Iterator it=null;
Ordermain oo=null;
c=(Collection)request.getAttribute("findorder");
it=(Iterator)c.iterator();
while(it.hasNext())
{
oo=(Ordermain)it.next();
Connection con1=null;
PreparedStatement pstmt1=null;
ResultSet rs1=null;
con1=DBConnect.getConnection();
pstmt1=con1.prepareStatement("select * from Ordermain where OrderId=?");
pstmt1.setString(1,oo.getOrderid());
rs1=pstmt1.executeQuery();
while(rs1.next())
{
%>
<tr>
<td width="13%">
<P>订单编号</P>
</td>
<td width="14%"><%=rs1.getString(1)%></td>
<td width="13%">客户编号</td>
<td width="12%"><%=rs1.getString(2)%></td>
<td width="13%">订购日期</td>
<td width="12%"><%=rs1.getDate(3)%></td>
<td width="13%">总金额</td>
<td colspan="2"><%=rs1.getDouble(4)%></td>
</tr>
<input type="checkbox"/>
<td colspan="9">
<P> </P>
<table cellspacing="0" cellpadding="0" border="1" width="60%" align="center">
<tr>
<td>明细编号</td>
<td>商品编号</td>
<td>数量</td>
<td>单价</td>
</tr>
<%
Connection con=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
con=DBConnect.getConnection();
pstmt=con.prepareStatement("select * from OrderList where OrderId=?");
pstmt.setString(1,oo.getOrderid());
rs=pstmt.executeQuery();
while(rs.next())
{
%>
<tr>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getLong(4)%></td>
<td><%=rs.getDouble(5)%></td>
</tr>
<%
}
rs.close();
pstmt.close();
con.close();
%>
</table>
<P align="center"> </P>
</td>
</tr>
<tr>
<td width="13%">付款方式</td>
<td width="14%"><%=rs1.getString(5)%></td>
<td width="13%">是否付款</td>
<td width="12%"><%=rs1.getString(6)%></td>
<td width="13%">状态</td>
<td width="12%"><%=rs1.getString(7)%></td>
<td width="13%"><a href=editOrder.jsp?orderid=<%=oo.getOrderid()%>>修改</a></td>
<td colspan="2"><a href=cartservlet?action=delorder&orderid=<%=oo.getOrderid()%>>删除</a></td>
</tr>
<%
}
rs1.close();
pstmt1.close();
con1.close();
}
%>
</table>
<P> <a href="ManagerMain.jsp">返回管理员主页</a></P>
</form>
<P> </P>
<P> </P>
<P> </P>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -