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>

<hr size=2 color="#000032" width=80%><br>
<% 
Vector vector=new Vector();
vector=db_orders.orders_Ulist(session.getAttribute("userid").toString());
if(vector!=null){
%>
<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>
<%

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>
 <%
}
}
else{
    out.println("<div align='center'>你目前还没有订单可以显示！</div>");
}
%>
</table>