1. Read the SQL Commands Reference we are going over together in class here (make sure you bring questions on things you don't understand to class).
2. Start designing your final project forms and reports. Create them so they look as nice as they will for turn-in. I know some of you are worried about how the connection to the database will work. This should NOT stop you from progressing on the project. I am designing an easier way to submit your SQL/JSP work. We will go over the details in class on Monday, May 19th but they are also documented in the Project 2 Requirements document available from our class home page.
3. Test out your SQL SELECT commmand knowledge against our entertainment planning database. You can do that here
4. You will have more data to work with as soon as a student from class turns in a JSP-enabled form from which to do so. I will share the first form for each table with the class via our class Web site.
5. Read the Java Server Page examples closely with a highlighter to figure out how the JSP works to embed the SQL you wish to run against the database. You will have to write some of that code for the project yourself so the examples should let you cut and paste most of what you need.
Some of the students in class will be able to do the project in 5-10 hours. If you think it will take you longer, please start now. You should be able to have all ten HTML pages written based on what you know now. Just make up your own data for the reports and leave the ACTION attribute values equal to "#nowhere" or "" so the form doesn't get processed yet.
I believe, if you follow these steps, you will do very well on the second half of our class' grades.