1. Upgrade the JSP produced for Project IV as follows:
   • Define a new Type 4 entry to your JSP following return from your Registration form. This Type 4 entry will verify that no user with the proposed user id presently exist. For this purpose you should automatically generate a String sql command and execute it from your JSP. The following SQL is a model for you to use:

      select * from users where e_mail = 'barton@fiu.edu';
     

     In the case that we have a new user the program must verify that the proposed password and it's copy are identical. In the case of identical passwords then the program must insert the information for the new user into the users table. You should automatically generate a String sql command and execute it from your JSP. The following SQL is a model for you to use:

     insert into users(f_name,l_name,e_mail,passw)
                       values('David','Barton','barton@fiu.edu','fredfred');
     

     In all cases an appropriate HTML response page should be generated for the user.
     
     
   • Redefine the Type 1 entry to your JSP to verify that the user's id and password are contained in the users table of your database. To do this you should automatically generate a String sql command and execute it from your JSP. The following SQL is a model for you to use:

      select * from users where e_mail = 'barton@fiu.edu';
     

     If they are not present in the table then an appropriate HTML response should be generated. If they are present then an HTML response indicating a successful login should appear.
   
   
   For the present note the following:
   • Ensure that all your HTML output uses the colors and emphasis that you selected for Project II.
   • Read and understand the JSP at /aul/homes/barton/cgs4825/webapps/ROOT/Database.jsp because it contains some guidance on using MySql from a JSP.
   • Read and understand the JSP at /aul/homes/barton/cgs4825/webapps/ROOT/Insertdata.jsp because it contains some guidance on using MySql from a JSP.
   • Read and understand the HTML of this page because it contains some guidance on the simple formatting of text.
   
   Your project should be run on ocelot.aul.fiu.edu.
   The project should be completed by October 8th, 2009.
   You should submit a hard copy listing of your HTML/Java program in your JSP at the time of the practical examination. This project will be tested via the Web for grading purposes.
   The project is the basis of your MidTerm Examination which carries 20% of your final grade. The MidTerm practical examination will take place Thursday October 15th. Further details of the MidTerm Examination are here