The Example JSP Pages

This chapter illustrates JSTL using excerpts from the JSP version of the Duke's Bookstore application discussed in Chapter 4. Here, they are rewritten to replace the JavaBeans component database access object with direct calls to the database via the JSTL SQL tags. For most applications, it is better to encapsulate calls to a database in a bean. JSTL includes SQL tags for situations where a new application is being prototyped and the overhead of creating a bean may not be warranted.

The source for the Duke's Bookstore application is located in the <INSTALL>/javaeetutorial5/examples/web/bookstore4/ directory created when you unzip the tutorial bundle (see About the Examples).

To deploy and run the application using NetBeans 5.5, follow these steps:

  1. Perform all the operations described in Accessing Databases from Web Applications.
  2. In NetBeans 5.5, select FileRight ArrowOpen Project.
  3. In the Open Project dialog, navigate to:
  4. <INSTALL>/javaeetutorial5/examples/web/

  5. Select the bookstore4 folder.
  6. Select the Open as Main Project checkbox and the Open Required Projects checkbox.
  7. Click Open Project Folder.
  8. In the Projects tab, right-click the bookstore4 project, and select Deploy Project.
  9. To run the application, open the bookstore URL http://localhost:8080/bookstore4/books/bookstore.

To deploy and run the application using Ant, follow these steps:

  1. In a terminal window, go to <INSTALL>/javaeetutorial5/examples/web/bookstore4/.
  2. Run ant. This target will spawn any necessary compilations, copy files to the <INSTALL>/javaeetutorial5/examples/web/bookstore4/build/ directory, and create a WAR file and copy it to the <INSTALL>/javaeetutorial5/examples/web/bookstore4/dist/ directory.
  3. Start the Application Server.
  4. Perform all the operations described in Creating a Data Source in the Application Server.
  5. To deploy the example, run ant deploy. The deploy target outputs a URL for running the application. Ignore this URL, and instead use the one shown in the next step.
  6. To run the application, open the bookstore URL http://localhost:8080/bookstore4/books/bookstore.

To learn how to configure the example, refer to the web.xml file, which includes the following configurations:

See Troubleshooting for help with diagnosing common problems.