24x7Shop.Com
This is a web application used by a company to sell products through internet. Customer can select and place order for a product, which are then
delivered to the customer. Upon the delivery of the product customer is expected to pay. This application is based on the concept of what websites like telebrandsindia.com do.
Major Operations
The following are the major operations of this portal:
- Home page where users can see th recent products and categories
- Search page - where user can search for product based on category, name and price of the products
- User placing the order for a product
- User can also modify some details of the order based on order number.
- User can also cancel the order; provided order has not been dispatched.
- User can subscribe so that information related to new products is sent to user through email.
- FAQs - questions and answers related to how to use website.
Technologies and Products used
- Tomcat 4.x
- Oracle8i/Oracle9i
- Weblogic Server 7.0
- Java Server Pages (JSP)
- Java Beans
- Enterprise Java Beans
The following table lists operations and associated objects and files.
| Operation
| Files
| Associated Objects
|
| Home page
| home.jsp , listitems.jsp
| UtilBean
|
| Listing items
| listitems.jsp
| UtilBean
|
| Displaying details of item in a category
| items.jsp
| UtilBean
|
| Searching for items
| search.jsp, listitems.jsp
| UtilBean
|
| Details of an item
| itemdetails.jsp
| UtilBean
|
| Placing order
| ordernow.jsp, placeorder.jsp
| UtilBean, OrderBean
|
| Modifying or cancelling order
| orderquery.jsp
| UtilBean, OrderBean
|
| Subscription
| subscribe.jsp
| SubscriberBean, Subscriber EJB
|
| FAQs
| faqs.xml, faqs.xsl
|
|
The following are the steps to related to be taken to run the existing part of the application :
- Download 24x7shop.zip and unzip it into webapps directory of
Tomcat installation directory.
- Make sure you copy classes111.zip ( after renaming it to classes111.jar) or classes12.jar into WEB-INF/lib directory
- Compile javabeans in WEB-INF/classes/shop directory. Run batch file s.bat before compiling javabeans. You may have to make necessary
changes to batch file depending on the directory structure of your system.
- Also make sure the classpath of Tomcat is changed to include weblogic.jar using setclasspath.cmd in BIN directory of Tomcat.
After the change set CLASSPATH in setclasspath.cmd should look like as shown below:
rem Set standard CLASSPATH
rem Note that there are no quotes as we do not want to introduce random
rem quotes into the CLASSPATH
set CLASSPATH=%JAVA_HOME%\lib\tools.jar;c:\weblogic\weblogic700\server\lib\weblogic.jar
- Create account shop with password shop in Oracle Database. If you cannot do this, you can still use SCOTT account wiith TIGER password.
- Create required tables in Oracle using TABLES.TXT file and also insert some sample data.
- Place pictures realated to items added to ITEMS table in 24x7shop/pictures directory. This application uses JPG files.
- Make sure Oracle and Tomcat are running.
- Start Weblogic Server and create the following
- A connection pool with the name shopOracle - It should access Oracle with shop user and shop password
- A TxDataSource with the name shoporacle and JNDI name shop.oracle
- Copy examples.properties file from c:\weblogic\weblogic700\samples\server\src directory of Weblogic server to 24x7shop/suscriber
- Build the ejb in 24x7shop/subscriber directory.
- Copy subscriber_client.jar from user directory to 24x7shop/WEB-INF/lib
- Run the application using the following url:
http://localhost:8080/24x7shop
- You should see home page of the application.