query_result.jsp

一个简单的网上商店系统

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

   <% String key=request.getParameter("query_key");
       if(key=="")
       {
            out.print("<br><hr width=85% color='#000032'><br>");
            out.print("<center>关键字为空，请返回查询页面输入关键字！</center>");
            out.print("<br><center><a href='orders_list.jsp'>返回</a></center>");
       }
       else
       {
            Vector vector=db_orders.orders_list(key);
            if(vector.size()==0||vector==null)
            {
                 out.print("<br><hr width=80% color='#000032'><br>");
                 out.print("<center>本网站不存在您要查找的商品</center><br>");
                 out.print("<center><a href=orders_list.jsp>返回主页</a></center>");
            }
            else
            {   
    %>
                <center>订单详细信息</center><br>
                <table align=center border=1 cellspacing=0 bgcolor="#ffccff" width=75%>
                <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>
	<%
                orders=(Orders)vector.elementAt(0);
                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><%=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>
            <td align=center><font size=2></tr>
            </table>
            <br>
            <table align=center>
            <tr>
            <td align=center colspan=5>
            	<a href="orders_detail.jsp?orderid=<%=orderid%>">查看订单明细</a></td>
            <td align=center colspan=2>
            	<a href="remove_order.jsp?orderid=<%=orderid%>">取消订单</a></td>
            <td align=center colspan=2>
            	<a href="send_order.jsp?orderid=<%=orderid%>">订单发货</a></td>
            <td align=center colspan=2>
            	<a href="finish_order.jsp?orderid=<%=orderid%>">完成交易</a></td>
            <td align=center colspan=2>
            	<a href="orders_list.jsp">返回主页</a></td></tr>
            </table>
 <%
             }
             
         }
%>