CGS4854 Tutorial 5

Due Thursday, 11/6 at 1 pm.

I have allowed extra time for the tutorial, so you will be able to resolve problems with accessing the database.

If you did not do a previous Tutorial, then create a web application named book in NetBeans. Review the web page that contains instructions on creating a servlet in a NetBeans project: Creating a Project in NetBeans

All previous Tutorials should still be able to be accessed and run from the application.

If you had errors in any of the previous tutorials, fix them, so that you do not lose points again for old mistakes.

Implement the Persistent Controller in the book web application. It must work exactly like the example from Chapter 5 of the book.

• Download the following Zip files to a directory on your system. Unpack them to a directory on your system. These ZIP files contain all the JAR files that are need to implement all the features in Chapter 5.
  • Hibernate ZIP file
  • Non-Hibernate ZIP file
• In NetBeans, right click the Libraries folder and add all of the JAR files, that were unzipped, to the web application. If you did Tutorial 4, then the following do NOT need to be added, since they have already been added.
  • log4j-1.2.11.jar (should already be there from Tutorial 4)
  • commons-collections-2.1.1.jar (should already be there from Tutorial 4)
  • commons-logging-1.0.4.jar (should already be there from Tutorial 4)
  • commons-beanutils.jar (should already be there from Tutorial 4)
• Add the following to the shared package in the Source Packages folder.
  • InitLog4j.java (should already be there from Tutorial 4)
  • HelperBaseCh4.java (should already be there from Tutorial 4)
  • ButtonMethod.java (should already be there from Tutorial 4)
  • HelperBaseCh5.java
  • HibernateHelper.java
  • PersistentBase.java
  • WebappListener.java
• Place the Controller.java, and ControllerHelper.java in the ch5.persistentData package in the Source Packages folder in NetBeans.
  • In the following, replace username with your ocelot user name. Notice that the mysql user name has fall08_ prepended to your ocelot user name. The name of your database is the same as your mysql user name: fall08_username
  • In the controller helper, set the connection URL to
    jdbc:mysql://ocelot.aul.fiu.edu:3306/fall08_username
  • In the controller helper, set the username to your mysql username: fall08_username
  • In the controller helper, set the password to your mysql password. This starts as your panther ID, but it is a good idea to change it.
• You will need to create the RequestDataPersistent.java file and place it in the ch5.persistentData package.
  • Start with a copy of the RequestDataRequired.java, from the first part of Chapter 5.
  • Add annotations so that the bean can be saved to a database.
    • Annotate the class so that it can be saved to its own table.
    • You may add a key field to the bean in one of two ways, but only do one of these
      • Add the Id property as is outlined in the book,
      • or extend the bean from PersistentBase.
      • Only do one of these.
• Place the .jsp files in the ch5.persistentData package in the Source Packages folder in NetBeans.
  • Use the JSPs from the ch4.enhanced controller, but copy them into the ch5.persistentData package.
  • Place all three JSPs in this directory. Please note that you are NOT placing these in the Web Pages folder.
  • Change each form method to POST. If you don't do this, then you will always be stuck on the edit page.
  • Modify the Edit.jsp file so that it will display any errors generated by the validation of the Hobby and Aversion.
  • Modify the process page so that it will display all of the data that is currently in the database.
    • Display the id, hobby and aversion for each row in the table. Place the data from each row on a separate line.
    • Use a JSTL for loop to iterate through the rows in the table. You will need to add the taglib statement that includes the JSTL in the JSP.
  • Add a second form to the process page that uses the GET method. The button in the form should be for the edit page.
    • Notice the difference between the form that uses the POST method and the one that uses the GET method.
    • When you use the POST form, then the last record that was added to the data base will be modified.
    • When you use the GET form, then a new record will be added to the data base.
    • The reason for this is that the GET request does not retrieve the old bean from the session.
• Modify the web.xml file so that it has a servlet definition and a servlet mapping for the servlet controller.
  • Map the controller to the URL /ch5/persistentData/Controller.
  • Add the create initialization parameter to the servlet definition.
    • Set its value to true, to create the table the first time you run the servlet.
    • After the table has been created, set it to false, so that your data will not be lost the next time Tomcat restarts.
  • Add the listener tag so that the WebappListener will close resources when Tomcat shuts down.
• Add a hypertext link in index.jsp to the controller.
  • Be sure that the index.jsp uses the strict DOCTYPE.
  • Use a relative link from the current location to the controller. Use the url-pattern from the web.xml, but omit the leading /.
  • All the previous Tutorials should also have links from this page. All of them should still work.

When you are done with everything, your directory and file structure should look like this.

Take a look at your log file, you will see that there are messages in it.

• Open the Files tab in NetBeans and navigate to build -> web -> WEB-INF -> logs
• Open the error.log file. It will look something like this.
  

Submitting Homework

Before you submit your homework, be sure that you have set the create parameter in the web.xml file to false.

Be sure that your NetBeans project is configured so that .java files are added to the WAR file: Adding .java files to a WAR file

Clean and Build your web application. After doing this, navigate to the WAR file in NetBeans and verify that the .java files are included: View WAR File

• Since you are using a log file that is in the web application, you will need to shut down Tomcat before you can do a Clean and Build.
• Open the Services (Runtime in 5.5) folder and open the Servers folder.
• Right-click the Tomcat server and select Stop.
• Now you can do a Clean and Build. 

In the operating system (not in NetBeans) navigate to the dist folder in the NetBeans project.

Deploy the WAR file on ocelot: Deploy a WAR File

• After deploying, open the WEB-INF/logs directory in winscp or on ocelot.
• Change the permission of the error.log file to 606. This will allow Tomcat to write to the file.
• Access your application and visit all the pages, then verify that some new messages have been added to the log file.

To hand in the assignment, zip the following directories into one ZIP file and upload it.

• First, delete the current book.zip file
  rm book.zip
• Next, please use the following command to compress your cgs4854/webapps/book folder.
  zip -r book ~/cgs4854/webapps/book -x \*.jar \*.zip \*.war \*.nfs\*
  Replacing book with the name of your book web app, if you used a different name. This will create a file named book.zip. It contains the book web application.
• Check the size of the ZIP file, it should be less than 3 MB. If it is not, then you probably have another ZIP file stored in the ZIP archive. Delete it and re-zip.
• You then have a choice for submitting the file.
  • If you are logged onto ocelot, use my uploading program to upload the file. Enter this command at the command prompt:
    ~downeyt/cs/public/webftp/webftp.pl
  • If you are using winscp, then download the zip file to your computer; then, upload the file to me: Submitting homework on-line via the Web.
• Upload the file as binary.

Be sure that all your files and subdirectories are included in the zip file.
After uploading, do not modify your files on ocelot until after your assignment has been graded.