⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 viewproductsbyorder.jsp

📁 ORACLE AQ sample 演示的如何出列
💻 JSP
字号:

<%--
  *  @author   Rajat Gupta
  *  @version  1.0
  *
  *  Development Environment        : Oracle9i JDeveloper
  *  Name of the Application        : ViewProductsByOrder.jsp
  *  Creation/Modification History  :
  *
  *     Rajat Gupta     10-Mar-2002     Created
  *
  *  Overview of Application        :
  *    This JSP is accessible to the Retail Administrator. It displays all
  *    the products in the selected order.
--%>

<%@ page language="java" %>
<%@ page errorPage="Exception.jsp" %>

<HTML><HEAD><TITLE>Advanced Queuing Sample - View Products By Order</TITLE>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<link rel="stylesheet" href="stylesheets/styles.css" type="text/css">
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff  text=#000000>
<form name="ProductForm" method="post">
<!-- Main table -->
   <jsp:include page="include/Top.jsp" />
                  <SPAN class="greeting"> Hi <%= session.getAttribute("Name")%>. You have logged in as a Retail Administrator.</SPAN>
              <jsp:include page="include/Links.jsp" />
     <!-- Heading of the page goes here -->

     <TR><TD class="mainHeading" align="center">Product List</TD></TR>
     <TR><TD>&nbsp;</TD></TR>
     <TR><TD class="subHeading" align="center"> Order Id: <%=request.getParameter("ShowProducts")%></TD></TR>
     <TR>
        <TD>
            <!-- 5th table starts here working area -->
            <TABLE border=0 cellPadding=0 cellSpacing=0 width=970 >
              <TBODY>
                <%
                    // Get information about all the products in a Vector
                    Vector products = (Vector)request.getAttribute("Products");

                    // Get the size of the Vector
                    int size = products.size();

                    if (size == 0){
                %>
                  <TR>
                    <TD class="subHeading" colspan=3><center><br>
                       All the Products placed in this order have been discontinued by the manufacturer.
                    </center></TD>
                  </TR>                
                <%
                    }else{
                %>

              <TR>
                <TD valign="top" width="15%" noWrap>&nbsp;</TD>
                <TD vAlign=top width="75%">
                
                
                  <!-- 6th table starts here-->
                  <TABLE border=1 borderColor="#9BCDFF" cellPadding=2 cellSpacing=0 width="100%">
                    <TBODY>
                    <TR align="center">
                      <TD class="subHeading" width="4%">S.No</TD>
                      <TD class="subHeading" width="10%">Prd Id</TD>
                      <TD class="subHeading" width="30%">Product Name</TD>
                      <TD class="subHeading" width="30%">Manufacturer Name</TD>
                      <TD class="subHeading" width="15%">Price in $ (per Unit)</TD>
                      <TD class="subHeading" width="11%">Quantity Ordered</TD>
                    </TR>

                    <%
                       // Iterate through the Vector and get the String Array from it.
                       // The String array contains various information about the
                       // products in this order.
                       for (int i=0; i<size; i++){
                         String[] productArr = (String[])products.elementAt(i);
                    %>

                    <TR align="center" height="25">
                      <TD class="data"><%=i+1%></TD>
                      <TD class="data"><%=productArr[0]%></TD>
                      <TD class="data"><%=productArr[1]%></TD>
                      <TD class="data"><%=productArr[2]%></TD>
                      <TD class="data"><%=productArr[3]%></TD>
                      <TD class="data"><%=productArr[4]%></TD>
                    </TR>

                    <%
                      }
                    %>

                   </TBODY>
                  </TABLE>
            <!-- 6th table ends here -->
                </TD>
                <TD width="10%">&nbsp;</TD>
              </TR>
                <%
                  }
                %>
              
              <TR><TD colspan=3>&nbsp;</TD></TR>
              <TR>

            <TD colspan=3 align="center"> <a href="ControllerServlet?Event=SignOut"><img src="images/signOut.gif" border=0></a></TD>
              </TR>
              </TBODY>
            </TABLE>
            <!-- 5th table ends here working area-->
        </TD>
      </TR>
      <TR>
        <TD vAlign=top align=left noWrap>&nbsp;</TD>
      </TR>
      <TR>
        <TD vAlign=top align=left ><image src="images/line.gif" height="3" width="970"></TD>
      </TR>
      <TR>
        
    <TD height=19 vAlign=top align="left"><font face="Arial, Helvetica" size=-2> 
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &copy; Copyright 2002 Oracle Corporation. 
      All rights reserved.</font> </TD>
      </TR>
    </TABLE>
    <!-- Main table ends here-->
</form>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -