CS320 HW4

Homework 4
CS320, Winter 2013

Due: Thursday, March 14

Please upload your files to CSNS. The files should include all the source code, documentation (optional), and an HTML file hw4.html which contains a link to your application deployed on the CS3 server. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

[Readings]

Textbook - Chapter 17
JDBC Tutorial
The HBGary Hack

[CS320Starter] (80pt)

Modify the CS320Starter application you developed in Homework 3 so that it stores data in a database instead of in the application scope. Again, the application must use MVC architecture, and all features described in previous assignments must work; otherwise you will not receive any credit.

For this assignment, in addition to the application source code, you also need to turn in an SQL script file hw4.sql which contains the statements to create and populate all the tables in the database.

[Extra Credit] (+30pt)

Add the user registration function to CS320Starter, which allows new users to create accounts by filling out a registration form as shown below::

Username:
Password:
Retype password:
First Name:
Last Name:

All the fields in the form are required. Your application should properly handle the following errors:

Required fields are empty.
Username is shorter than 4 characters.
Username conflicts with an existing username.
Password is shorter than 4 characters.
Password and re-typed password do not match.

For each type of error, output an error message and ask the user to re-enter the data.

Once a user is registered successfully, the user can create and sponsor projects as described in previous assignments.