📄 orderlist2.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBorder" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'orderlist2.jsp' starting page</title>
<script language=javascript src="../function/admin.js"></script>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<body BGCOLOR="#FFCCCC">
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY>
<TR>
<TH colSpan=2> 当前位置：系统管理>>订单管理</TH>
</TR>
<TR>
<TD align=right>[<A href="orderlist.jsp">所有订单</A>] [<A href="do_list.jsp">已处理订单</A>] [<A href="undo_list.jsp">未处理订单</A>] [<A href="que_list.jsp">缺货订单</A>] [<A href="index.jsp">回首页</A>]</TD></TR>
</TBODY>
</TABLE>
<%
try{
String id1=request.getParameter("ID");
ResultSet rs=null;
String str1="select * from userorderlist where OrderlistNo='"+id1+"' ";
rs=DBorder.executeQuery(str1);
rs.next();
%>
<FORM name=myform action= method=post>
<TABLE class=list cellSpacing=1 align=center>
<TBODY>
<TR>
<TH colSpan=4>订单号：<%=rs.getString("OrderlistNo") %></TH>
</TR>
<TR>
<TD>下单日期：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("SubmitTime") %> name=submittime readonly="true"></TD>
</TR>
<TR>
<TD>用户ID：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("UserID") %> name=userid readonly="true"></TD>
</TR>
<TR>
<TD>用户名：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("UserName") %> name=username readonly="true"></TD>
</TR>
<TR>
<TD>用户实名：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("RealName") %> name=realname readonly="true"></TD>
</TR>
<TR>
<TD>用户电话：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("Tel") %> name=usertel readonly="true"></TD>
</TR>
<TR>
<TD>详细地址：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("UserAddress") %> name=address readonly="true"></TD>
</TR>
<TR>
<TD>邮政编码：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("Post") %> name=post readonly="true"></TD>
</TR>
<TR>
<TD>发货时间：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("SendoutTime") %> name=sendtime readonly="true"></TD>
</TR>
<TR>
<TD>总金额：</TD>
<TD colSpan=3><INPUT size=50 value=<%=rs.getString("TotalPrice") %> name=totalprise readonly="true"></TD>
</TR>
<TR>
<TD>是否付款：</TD>
<TD colSpan=3>
<select name="fukuan" disabled="disabled">
<OPTION selected><%=rs.getString("IsPayoff")%></OPTION>
<option value="是">是 </option>
<option value="否">否 </option>
</select>
</TD>
</TR>
<TR>
<TD>是否发货：</TD>
<TD colSpan=3>
<select name="fahuo" disabled="disabled">
<OPTION selected><%=rs.getString("IsSendout")%></OPTION>
<option value="是">是 </option>
<option value="否">否 </option>
</select>
</TD>
</TR>
<TR>
<TD>是否缺货：</TD>
<TD colSpan=3>
<select name="quehuo" disabled="disabled">
<OPTION selected><%=rs.getString("Isquehuo")%></OPTION>
<option value="是">是 </option>
<option value="否">否 </option>
</select>
</TD>
</TR>
<TR>
<TD>订单状态：</TD>
<TD colSpan=3>
<select name="zhuangtai" disabled="disabled">
<OPTION selected><%=rs.getString("OrderlistState")%></OPTION>
<option value="已处理">已处理 </option>
<option value="未处理">未处理 </option>
<option value="已取消">已取消 </option>
</select>
</TD>
</TR>
<TR>
<TD width="15%">配送方式：</TD>
<TD width="35%">
<SELECT size=1 name=sendway disabled="disabled">
<option selected><%=rs.getString("SendWay") %></option>
<OPTION value=送货上门(货到付款)>送货上门(货到付款)</OPTION>
<OPTION value=普通邮寄(款到发货)>普通邮寄(款到发货)</OPTION>
<OPTION value=特快专递(款到发货)>特快专递(款到发货)</OPTION>
</SELECT>
</TD>
<TD width="15%">配送费用：</TD>
<TD width="35%"><INPUT size=15 value=0.00 name=d_deliverfee readonly="true"> 元</TD>
</TR>
<TR>
<TD width="15%">支付方式：</TD>
<TD width="35%">
<SELECT size=1 name=payway disabled="disabled">
<option selected><%=rs.getString("Way") %></option>
<OPTION value=邮政汇款>邮政汇款 </OPTION>
<OPTION value=工商银行汇款>工商银行汇款 </OPTION>
<OPTION value=招商银行汇款>招商银行汇款 </OPTION>
<OPTION value=建设银行汇款>建设银行汇款 </OPTION>
<OPTION value=农业银行汇款>农业银行汇款 </OPTION>
<OPTION value=见货即付>见货即付 </OPTION>
</SELECT>
</TD>
<TD width="15%">支付费用：</TD>
<TD width="35%"><INPUT size=15 value=0.00 name=payfee readonly="true"> 元</TD>
</TR>
<TR>
<TD>总计金额：</TD>
<TD align=right colSpan=3>应付人民币:<%=rs.getString("TotalPrice") %>元整</TD>
</TR>
</TBODY>
</TABLE>
</FORM>
<%
}catch(Exception e)
{out.print(e);}
%>
<TABLE class=list cellSpacing=1 align=center>
<%
try{
String id=request.getParameter("ID");
ResultSet rs2=null;
String strsql="select * from orderlist where OrderlistNo='"+id+"'";
rs2=DBorder.executeQuery(strsql);
%>
<TBODY>
<TR>
<TH>ID</TH>
<TH>订单编号</TH>
<TH>图书编码</TH>
<TH>书名</TH>
<TH>图书价格（元）</TH>
<TH>数量</TH>
<TH>计量单位</TH>
</TR>
<%
if(!rs2.next()){
out.print("<TR align=center><td colspan=7>对不起该书暂时缺货！</td></tr>");
}
else{
rs2.beforeFirst();
while(rs2.next()){
%>
<TR>
<TD><%=rs2.getInt("ID") %></TD>
<TD><%=rs2.getString("OrderlistNo") %></TD>
<TD><%=rs2.getString("BookNo") %></TD>
<TD><%=rs2.getString("BookName") %></TD>
<TD align=right><%=rs2.getString("Price") %></TD>
<TD align=right><%=rs2.getString("Number") %></TD>
<TD align=center>本</TD>
</TR>
<% } } }catch(Exception e)
{out.print(e);} %>
</TBODY>
</TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -