A "Three-tier" Web Application
Write a Web application that incorporates
-
A form-based Web front end to one or more servlets.
-
Servlet session tracking.
-
Access to an SQL database through JDBC.
The application should be deployed under a Tomcat server running on
the port allocated for you on
sirah, merlot or cabernet
in CSIT.
You may either rewrite the client/server based application you
developed in a previous homework or start with a new application.
If you choose to rewrite your simple client/server application using servlets, you
should now pay attention to the following issues:
-
If your file entries previously consisted of only a single field,
they should now be extended to use multiple fields (or columns) in an SQL
database.
-
To make use of servlet session tracking, add an undo mechanism.
This should keep a list of record deletions and/or updates
that were made in the current session, and allow them to be undone, e.g. in the
reverse order they were made.
-
You should ensure your servlets behave correctly in the presence of
concurrent accesses by multiple users.
For extra credit, you may consider adding new features of
interest, like
guarding against updates by unauthorized users,
additional mechanisms to search your database, use of
multiple tables, etc.
If you choose to start with a new application, possible projects
include business models such as:
- A simplified airline reservation
system. Servlets would access a database that kept files with airplane
flight schedules and who has made reservations for each flight.
The client could request flight information and make a reservation
for a particular flight.
- An online store with a shopping cart system. The database may store
products, shoppers, and orders.
You have some freedom in choosing details here, but you must meet the requirements
in the first paragraph above.
If you want to design a project substantially different from the topics listed above,
please send an email request.
This project will account for 30-40% of your final grade. You
should invest effort accordingly.
To submit your project, include
-
a project report document describing the application and
its implementation.
This should preferably be written as a Word document or HTML document.
It should be laid out and read like a paper or user's guide.
There is no fixed length, but 2000+ words is a reasonable size.
Include URLs and any special instructions necessary
for restarting your Web server.
- the .html and .java source files.
To submit the project you should copy these files to
/home/project/it1fall00/homework5/login/ on
sirah, where login is your
login id (user name) on this machine.
For this homework the .html and .java source
files may be left in the document directories of your Web server, if you
prefer. Example databases will be
expected---instructions on the location of these will be given later.
As usual, further advice may be added to this page as the submission deadline approaches ...
Please send questions to Bryan Carpenter at dbc@csit.fsu.edu.