A "Three-tier" Web Application
For the final project you should develop a
a Web application that incorporates
-
an HTML-form-based Web front end,
-
a middle tier consisting of a group of servlets and/or JavaServer pages,
-
access to an SQL database through JDBC, and that
-
supports multiple concurrent clients and exploits servlet
session tracking mechanisms in a useful way.
The application should be deployed under a Tomcat server running on
the port allocated for you on
sirah, merlot, cabernet,
or pinot in CSIT (see the course announcements page).
Your application must include at least one servlet. It
may optionally include some JSP pages as well (this may lead to extra credit).
You should use the high-level session tracking APIs
in preference to explicit use of cookies, hidden fields, etc.
You may choose build on your the client/server applications
developed in a previous homeworks, or you may start with a new application.
If you choose to extend your simple client/server application, you
must ensure you add sufficiently complex behaviors to cover
all the requirements above. In particular the application must involve
some non-trivial "session state" (akin to a shopping cart),
to exploit session-tracking in a meaningful way.
If you choose to start with a new application, possible projects
include business models such as:
- A simplified airline reservation
system. Servlets or JSP pages would access a database that kept files
with airplane
flight schedules, and passengers who have 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 considerable 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 with a brief explanation.
Submission of your Homework
Your submission should 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.
You should copy this file to
/home/project/it1fall00/homework5/login/ on
sirah, where login is your
login id (user name) on this machine.
- The .html and .java and
.jsp source files you develop should be left in the
installation directory for your Tomcat server, which should be in the
home directory of your sirah account.
- Example database tables should be installed under your Oracle
account on sirah. Instructions for accessing this account will be
given in class.
Grading
For this project, there will be a total of 40 points.
This may account for 30-40% of your final grade. You
should invest effort accordingly.
In general grading criteria are similar to
Assignment 1. In this project points will
be substantially assigned on the basis of apparent effort and
uniqueness.
To get a high grade some certain minimum level of complexity is expected
in your application.
A system with around 6 inter-related servlets or JSP pages, 2 database
tables, and one or more static HTML pages would be reasonable (these
are guidelines only).
Moderately realistic example databases make a good impression; tables
with very few entries do not. You should aim for an attractively
designed Web sites with clear logic.
Resources and Tips
Servlet examples
See the examples for the servlets lecture set,
here.
JDBC examples
See the examples for the JDBC lecture set,
here.
JSP examples
See the examples for the JSP lecture set,
here.
Please send questions to Bryan Carpenter at dbc@@csit.fsu.edu.
@
1.1
log
@Added Files:
hw5.html
@
text
@d3 1
a3 1
Applications of Information Technology I: Homework 4, Fall 00
d9 1
a9 1
CIS 6930-01
Fall 2000
d20 2
a21 1
Write a Web application that incorporates
d24 1
a24 1
A form-based Web front end to one or more servlets.
d26 1
a26 1
Servlet session tracking.
d28 4
a31 1
Access to an SQL database through JDBC.
d35 2
a36 5
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.
d38 12
a49 21
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.
a50 1
d55 3
a57 2
system. Servlets would access a database that kept files with airplane
flight schedules and who has made reservations for each flight.
d63 8
a70 9
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
d73 1
a73 1
a project report document describing the application and
d80 1
a80 5
- the .html and .java source files.
To submit the project you should copy these files to
d84 8
a91 4
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.
d94 37
a130 1
As usual, further advice may be added to this page as the submission deadline approaches ...
@