Oracle9iAS Web Cache - Order Entry System

---

Table Of Contents

• Introduction
• Order Entry System - Screen Shots
• Dependencies
• Version Dependencies
• Installation and Configuration

Order Entry System

        The Order Entry System allows tracking of orders made by the customers. The users of this system are customers and employees.  The system maintains product information, order information, customer and employee information in the database. The  user of this system, employee/customer has to login into the system using the unique identifier given to them.

        When the customer logs into the system, a product catalog is shown to them. This page allows them to add products into the Shopping cart, view more information about the product, view customer information and order items in the cart. The system also displays the list of top 5 products on the left hand side of the screen. The top 5 products is determined by the total number of orders received for the product from all the customers. A greeting message "Welcome <username>" is also displayed in this page. The product catalog has "More Info" and "Add to Cart" links for each product. The "More Info" link gives a detailed information about the product. "Add to Cart" link adds the product to the Shopping Cart. The product catalog lists the orderable products only. (orderable products has product_status value "orderable"). When 'order items' button is clicked, all the items in the cart are ordered and the cart is reset.

        The employees in the system can add/ modify/ remove products in the system. Similar to the Customer, when the employee logs into the system a greeting message is displayed. The product catalog consisting of all products is displayed. The employees can select the products from the catalog to modify/delete the product details. Product details like name, description of the product,  product status, list price, catalog url can be modified.

Role of Oracle9iAS Web Cache

        Oracle9iAS Web Cache can be used in this system to store both static and dynamic pages. When the dynamic pages are cached, the first request alone will be sent to the Application Server and the content will be stored in Oracle9iAS Web Cache. All subsequent requests will be served from the Oracle9iAS Web Cache server until the pages are invalidated. Oracle9iAS Web Cache handles the session information stored in these cached pages and substitutes session information to the content stored in it. The suitable candidates for caching dynamic pages in the system are

• Product catalog displayed both to the employee and customers.
• List of top 5 products displayed to the customers
• Product information displayed for each product
• Customer information displayed for each customer
• Greeting message displayed to each user of the system

       The top 5 products are based on the orders received from the customer. When the customer orders for a product,  the pages needs to be invalidated. The product information displayed for each product can also be cached in Oracle9iAS Web Cache. The product information page embeds the product id in its URL. Oracle9iAS Web Cache will use the embedded product id in the URL to identify the content for each of the products. The customer information pages can also be cached in Oracle9iAS Web Cache by embedding customer id in its URL. The cached pages has to be invalidated when the information changes.

        The greeting message or Oracle9iAS Web Cache's "Personalized messages" can also be cached. The only content in this greeting message which will change is the <username>. The personalized content will be identified by the special tag <!-- WEBCACHETAG --> in the source content. The personalized content  i.e., the user name in this case, can be passed as encoded URLs or as cookies to these pages. Oracle9iAS Web Cache will substitute the cookie value / encoded URL value into these pages. The greeting message "Welcome <username>" will be displayed correctly only from the second request to web cache as the first request will just display 'username' alone.

 

Order Entry System - Screen Shots

Back To Top

        This section shows the various screen shots in this application.

Figure 1.1 Login Page

Figure 1.1 Customer Catalog
     This page is displayed when the customer logs into the system.

Figure 1.3 Product Information Page
     This page is displayed when the user clicks on the More Info link.

Figure 1.4 Add Product to Cart page
     This page is displayed  when the user adds the product to the cart.

Figure 1.5 Product Added to cart
     This page is displayed  when the selected product is added to the cart.

Figure 1.6 Order Products in the cart

     This page is displayed when the customer submits the cart.  When the products are ordered,  the products in the top 5 product list will also change. The top 5 product list, which is cached in Oracle9iAS Web Cache will be invalidated. The invalidation messages in this page, displays status of this Invalidation Mechanism.

Figure 1.7 Customer Information Page

   This page displays the customer information. It is displayed when the user presses the 'Custom Information' button.
Figure 1.8  View Cart

  This page displays the products in the cart. This page is displayed when the user presses' View cart' button

Figure 1.9 Employee Product Catalog

  This page displays the product catalog for the employees. This page is displayed when the user logs in as employee. The user can add, modify and delete products from this page.

Figure 1.10 Add Product to the system
   This page is displayed when the user chooses to add new products into the system.

Figure 1.11 Product Added to the system

This page is displayed when a product is added to the system. The invalidation messages list the various pages that should be invalidated, when a product is added to the system. The catalog displayed to both customer and employee will change as a result of this. The names of the pages that need to be invalidated are shown below.
Figure 1.12 Modify Product in the system

  This page is displayed when the user chooses to modify a product.

Figure 1.13 Product Modified

This page is displayed when the product is successfully modified in the system. After modification,  the pages like top 5 products page, product catalog for both customers and employees,  product information pages will be invalidated. The invalidation messages carry the status of this invalidation.

Figure 1.14 Delete Product in the system

  This page is displayed when the user chooses to delete a product.

 

Dependencies

Back To Top

        This system uses Oracle9i sample schemas. It uses Order Entry Schema available at  Understanding the Common Schema
 

Version Dependencies

Back To Top

This sample has been tested against the  Oracle9iAS Containers for Java 1.0.2.2 and Oracle9iAS Web Cache Release 2.0.
 

Installation and Configuration

Back To Top

Refer to Install.html for step-by-step instructions on copying files, installing packages, and configuring any other systems to successfully run the sample.

Contents of Archive file

Revision history:

Nov 20, 2001

Please enter your comments about this sample in the OTN Sample code discussion forum.