SQL DATABASE APPLICATIONS

Application 1:  The Internet BookShop

Description:  This is a simple bookshop website.  Customers can search the database for books, create a new account, add items to their shopping basket, and place an order. Note that code development assumes an Apache Tomcat application server as the middleware, and a Microsoft SQL Server as the DBMS backend.

Files:

File Description File Name (click to download)

System Specifications

Internet-Bookshop-Case.pdf

Design Document:

Design Document - The Internet BookShop.doc

Application Install Guide:

Application Server Install Guide - The Internet BookShop.doc

Application Server Files, Version A:

bookshop.zip

Application Server Class Files, Version A:

bookshop-classes.zip

Application Server Files, Version B: (contains servlets)

bookshop-2.zip

Application Server Class Files, Version B: (contains servlets)

bookshop-classes-2.zip

October 2002

Scott Selikoff [sms65@cornell.edu]

The above raw files were modified and hosted in an Apache Tomcat application server located at enb340pc.csee.usf.edu. You can access them via http://enb340pc.csee.usf.edu:8080/sample . The application-level code connects to the same database we have used for previous projects at netcluster.csee.usf.edu.

You can also download the modified code package here. Unzip this file, you will get a folder named 'sample'. You can make it accesible by copying it to the "webapps" folder under the Apache Tomcat home directory.