orders_list.jsp

一个简单的网上商店系统

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.Vector"%>
<%@ page import="JavaBean.Orders"%>
<jsp:useBean id="db_orders" class="JavaBean.DB_orders" scope="session"/>
<%@ include file="../public.jsp" %>

<br>
<h3><center><font size=5 face="幼圆">后台管理之</font>订单处理</center><br></h3>
<table align=center>
    <tr><td><font size=4>请输入订单编号进行查询：</font></td>
    <td><form action="query_result.jsp" method="post">
        <input type="text" name="query_key" size=20%></td>
    <td><input type="submit" name="query" value="查询"></tr>
</table>
<hr size=2 color="#000032" width=80%><br>
<table align=center border=1 cellspacing=0 bgcolor="#ffccff" width=85%>
<tr><td align=center><font size=2>订单编号</font></td>
<td align=center><font size=2>用户编号</font></td>
<td align=center><font size=2>用户姓名</font></td>
<td align=center><font size=2>订购日期</font></td>
<td align=center><font size=2>收货地址</font></td>
<td align=center><font size=2>收货人</font></td>
<td align=center><font size=2>邮政编码</font></td>
<td align=center><font size=2>消费金额</font></td>
<td align=center><font size=2>交易日期</font></td>
<td align=center><font size=2>订单状态</font></td>
<td align=center><font size=2>备注信息</font></td></tr>
<%
Vector vector=new Vector();
vector=db_orders.orders_list();
for(int i=0;i<vector.size();i++)
{
    Orders orders=new Orders();
    orders=(Orders)vector.elementAt(i);
    String orderid=orders.getOrderid();
    int userid=orders.getUserid();
    String username=orders.getUsername();
    String orderdate=orders.getOrderdate();
    String address=orders.getAddress();
    String contactman=orders.getContactman();
    String postcode=orders.getPostcode();
    float ordersum=orders.getOrdersum();
    String dealdate=orders.getDealdate();
    String status=orders.getStatus();
    String note=orders.getNote();
 %>
 <tr><td align=center><font size=2>
 		<%="<a href=query_result.jsp?query_key="+orderid+">"+orderid%></font>
 	 </td><td align=center><font size=2><%=userid%></font></td>
     <td align=center><font size=2><%=username%></font></td>
     <td align=center><font size=2><%=orderdate%></font></td>
     <td align=center><font size=2><%=getStr(address)%></font></td>
     <td align=center><font size=2><%=getStr(contactman)%></font></td>
     <td align=center><font size=2><%=postcode%></font></td>
     <td align=center><font size=2><%=ordersum%></font></td>
     <td align=center><font size=2><%=dealdate%></font></td>
     <td align=center><font size=2><%=status%></font></td>
     <td align=center><font size=2>	<%=note%></font></td>
   
</tr>
 <%
}
%>
</table>