Step 1. Setting Up the Hibernate Tutorial Sample Application

This tutorial uses a sample application and the HypersonicSQL database to demonstrate the features for working with Hibernate web application in Workshop.

Application Description

The sample application used in this tutorial is a web application for a company selling various products. The application maintains a list of products for sale and customers who placed orders. The diagram below shows the database tables used in this application.

In this tutorial, you will develop "Add Customer" and "View Orders" modules of the web application. The Add Customer module adds customers to the database. The View Orders module displays a list of customers who have placed orders and an overview of each order.

Web Components

The following are the software components of the sample web application.

• Hypersonic Database files
  
  • SalesDB.script and SalesDB.properties

  Hypersonic database files for SalesDB database.

  • hsqldb.jar

  JDBC driver for accessing Hypersonic database. (Note that this tutorial uses an in-memory database that will not be written to disk.)

• DAO classes

• CustomerDAO.java and CustomerDAO_Hibernate.java

CustomerDAO is an interface, which defines methods for retrieving the customer details. The CustomerDAO_Hibernate class implements the CustomerDAO interface and uses the Hibernate API for retrieving customer details.

• OrderDAO.java and OrderDAO_Hibernate.java

OrderDAO is an interface, which defines methods for retrieving the order details. The OrderDAO_Hibernate class implements the OrderDAO interface and uses the Hibernate API for retrieving order details.

• DAOHelper.java and DAOFactory.java

DAOHelper creates the Hibernate SessionFactory class based on the Hibernate configuration file hibernate.cfg.xml. It also provides a method for closing a given Hibernate Session. DAOFactory is a factory class for creating DAO instances, which uses Hibernate for persistence.

• HTML and CSS files
  

• addCustomer.jsp

Provides a form to add a new customer. Sends request to addCustomer( ) method of Customer bean.

• viewAllCustomers.jsp

Displays complete list of customers. Provides facility to view orders of specific customer.

• viewOrders.jsp

Displays a list of orders placed by a specific customer.

• stylesheet.css

CSS file to customize appearance of JSP pages.

• Other files

• MessageFactory.java

A factory class for retrieving localized messages from the application resource file.

• application.properties

A default properties file that contains a series of keywords and values.

• faces.config.xml

Configuration file defining JSF components.

You will create the workshop-hibernate-tutorial project which contains database files and resources (.java, .css file and .jsp files) for a Hibernate web application. Using the resources and steps described in this tutorial, you will learn how to develop Hibernate web applications using Workshop™.

Click one of the following arrows to navigate through the tutorial: