Create the Person Java Class

1. Right-click the Source Packages node in the Projects window and choose New > Java Class to open the New Java Class wizard.
2. In the wizard, type Person for the class name and type travel for the package. Click Finish.
3. Make the following changes (displayed in bold) to the class to implement the Serializable interface and add fields for the table columns.

   public class Person implements Serializable {
       private int personId;
       private String name;
       private String jobTitle;
       private boolean frequentFlyer;
       private java.util.Set trips;
   }

4. Generate the getters and setters for the fields by right-clicking in the Source Editor, choosing Insert Code (Alt-Insert) and then selecting Getter and Setter.
5. In the Generate Getters and Setters dialog box, select all the fields and click Generate.
   

   In the Generate Getters and Setters dialog box, you can use the Up arrow on the keyboard to move the selected item to the Person item and then hit the Space bar to select all fields in Person.

6. Fix your imports and save your changes.

Create the Trip Java Class

1. Right-click the Source Packages node in the Projects window and choose New > Java Class to open the New Java Class wizard.
2. In the wizard, type Trip for the class name and type travel for the package. Click Finish.
3. Make the following changes (displayed in bold) to implement the Serializable interface and add fields for the table columns to the class.

   public class Trip implements Serializable {
       private int tripId;
       private int personId;
       private Date depDate;
       private String depCity;
       private String destCity;
       private int tripTypeId;
   }

4. Generate the getters and setters for the fields by right-click in the Source Editor, choosing Insert Code (Alt-Insert) and then selecting Getter and Setter.
5. In the Generate Getters and Setters dialog box, select all the fields and click Generate.
6. Fix your imports and save your changes.

You can close Person.java and Trip.java because you will not need to edit the files again.

Mapping Person.java to the PERSON table

First you will create the Hibernate mapping file Person.hbm.xml to map the fields in Person.java to columns in the PERSON table.

1. Start the JavaDB database server.
2. In the Projects window, right-click the travel node under Source Packages and select New > Other in the popup menu to open the New File wizard.
3. Select Hibernate from the Categories list and Hibernate Mapping File from the File Types list. Click Next.
4. Type Person.hbm for the file name and set the folder to src/java/travel. Click Next.
5. Type travel.Person for the Class to Map.

   Note: Alternatively, you can click the Browse button and type Person in the Find Type dialog.

6. Select PERSON from the Database Table drop-down list.

   Note: If the Database Table drop-down list is empty, that probably means that the database is not running. You can continue and create the file without specifying the table, but you need to remember to supply the table in the XML.

7. Click Finish.

   When you click Finish, the IDE creates the Person.hbm.xml file in the same source package as Person.java and opens the file in the editor. By default, the XML file looks like the following:

   <hibernate-mapping>
     <class dynamic-insert="false" dynamic-update="false" mutable="true"
     name="travel.Person" optimistic-lock="version" polymorphism="implicit"
     select-before-update="false" table="PERSON"/>
   </hibernate-mapping>

   Note: If you were unable to select the PERSON table in the drop-down list when you created the file, be sure to add table="PERSON" to the class element.

8. In the XML editor, make the following changes (displayed in bold) to map the ID, properties and the one-to-many relationship.

   <hibernate-mapping>
     <class dynamic-insert="false" dynamic-update="false"
         mutable="true" name="travel.Person" optimistic-lock="version"
         polymorphism="implicit" select-before-update="false" table="PERSON">
           <id column="PERSONID" name="personId">
               <generator class="increment"/>
           </id>
           <property column="NAME" name="name"/>
           <property column="JOBTITLE" name="jobTitle"/>
           <property column="FREQUENTFLYER" name="frequentFlyer"/>
           <set cascade="all-delete-orphan" inverse="true" lazy="true" name="trips" table="TRIP">
               <key column="PERSONID"/>
               <one-to-many class="travel.Trip"/>
           </set>
       </class>
   </hibernate-mapping>

   You can use the code completion in the XML editor to help you add properties and values. If the code completion is not working for you as in this screenshot, see the note below.

   

   Note: By default, the class element has a closing tag. Because you need to add property elements between the opening and closing class elements, you need to make the following changes (displayed in bold). After making the changes you can then use code completion between the class elements.

   <hibernate-mapping>
     <class dynamic-insert="false" dynamic-update="false"
     mutable="true" name="travel.Person" optimistic-lock="version"
     polymorphism="implicit" select-before-update="false" table="PERSON">
   
     </class>
   </hibernate-mapping>

9. Validate the XML, fix any validation errors and save your file.

Mapping Trip.java to the TRIP Table

You will now create the Hibernate mapping file Trip.hbm.xml to map the fields in Trip.java to columns in the TRIP table.

1. In the Projects window, right-click the travel node under Source Packages and select New > Other in the popup menu to open the New File wizard.
2. Select Hibernate from the Categories list and Hibernate Mapping File from the File Types list. Click Next.
3. Type Trip.hbm for the file name and set the folder to src/java/travel. Click Next.
4. Type travel.Trip for the Class to Map.

   Note: Alternatively, you can click the Browse button and type Trip in the Find Type dialog.

5. Select TRIP from the Database Table drop-down list.

   Note: If the Database Table drop-down list is empty, then leave it blank here. You can enter the table name later in the XML editor.

6. Click Finish.

   When you click Finish, the IDE creates Trip.hbm.xml in the same folder as the class Trip.java and opens the file in the editor.

7. In the XML editor, make the following changes (in bold).

   <hibernate-mapping>
           <class dynamic-insert="false" dynamic-update="false" mutable="true"
               name="travel.Trip" optimistic-lock="version" polymorphism="implicit"
               select-before-update="false" table="TRIP">
   	<id column="TRIPID" name="tripId">
               <generator class="increment"/>
           </id>
           <property column="PERSONID" name="personId"/>
           <property column="DEPDATE" name="depDate" type="date"/>
           <property column="DEPCITY" name="depCity"/>
           <property column="DESTCITY" name="destCity"/>
           <property column="TRIPTYPEID" name="tripTypeId"/>
       </class>
   </hibernate-mapping>

   Use the code completion in the XML editor to help you add properties and values.

8. Validate the XML, fix any validation errors and save your file.

Adding the Visual Web JSF Components to the Page

1. Expand the Web Pages folder in the Projects window and open Page1.jsp in the Visual Designer.
2. Drag a Drop Down List component from the Woodstock Basic component set in the Palette and drop it in the top left corner of Page1.
3. Right-click the Drop Down List component and choose Auto-Submit on Change from the pop-up menu.

   This action causes the browser to submit the page whenever the user chooses a new value from the drop-down list.

4. Right-click the Drop Down List component again and choose Add Binding Attribute.

   Note: You will specify the property bindings later in the tutorial. NetBeans IDE 6.1 features on-demand binding. Where components require Java coding, you must manually add the binding attribute to components in a Visual Web JSF application. To do so, right-click each component and choose Add Binding Attribute. For more information, see the On-demand Binding Attribute Wiki.

5. Drag and drop a Table component below the Drop Down List component.
6. Drag and drop a Message Group component below the Table component.

   Message Group components help you to diagnose runtime problems. By default, the Message Group component displays messages about runtime errors, validation errors, and conversion errors.

7. Save your changes.

Your web page now has the necessary components. You now need to bind the components to the data source.

Accessing the Data Source from SessionBean1

You now need to edit SessionBean1 to access the data source. In this exercise use the Add Property dialog box to specify the fields in SessionBean1 and to generate the getters and setters for the fields. The Session Bean opens a session context and then retrieves the data via the Java objects.

1. Expand the hibernatetravelapp source package in the Projects window and double-click SessionBean1.java to open the file in the editor.
2. Place the cursor in an empty space in the source code (for example, right after the constructor) and right-click and choose Insert Code > Add Property (Ctrl-I) to open the Add Property dialog box.
3. In the Add Property dialog box, type personOptions for the Name, type Option[] for the Type and select private.
4. Select Generate Getters and Setters, if unselected. Click OK.
   
5. Repeat the steps to add the following properties:

   Name	Type
   selectedPersonId	Integer
   trips4Person	Trip[]

   
6. Add the methods buildPersonOptions and updateTrips4Person to the class by adding the following (in bold) to SessionBean1 after the getApplicationBean1 method.

   protected ApplicationBean1 getApplicationBean1() {
           return (ApplicationBean1) getBean("ApplicationBean1");
       }
   
   private void buildPersonOptions() {
       List<Person> personList = null;
       try{
           Session session = HibernateUtil.getSessionFactory().getCurrentSession();
           Transaction tx = session.beginTransaction();
           Query q = session.createQuery("from Person");
           personList = (List<Person>) q.list();
   
       } catch(Exception e) {
           e.printStackTrace();
       }
   
       personOptions = new Option[personList.size()];
       int i=0;
       for(Person person : personList) {
           Option opt = new Option(person.getPersonId(), person.getName());
           personOptions[i++] = opt;
       }
   }
   
   private void updateTrips4Person() {
       if(selectedPersonId == null ) {
           trips4Person = new Trip[1];
           trips4Person[0] = new Trip();
           return;
       }
   
       Set personTrips = null;
       try{
          Session session =
                   HibernateUtil.getSessionFactory().getCurrentSession();
           Transaction tx = session.beginTransaction();
           Person person = (Person)session.load(Person.class, selectedPersonId);
           personTrips = (PersistentSet)person.getTrips();
   
       } catch(Exception e) {
           e.printStackTrace();
       }
   
       trips4Person = (Trip[]) personTrips.toArray(new Trip[0]);
   }

   The buildPersonOptions method calls a query on the Person data source and stores the results in the personOptions array. The updateTrips4Person method updates the trips for the selected person.

7. Fix your imports.
   

   Note: When you select the fully qualified names to import, make sure you select the org.hibernate libraries and com.sun.webui.jsf.model.Option and java.util.Set.

8. Call method buildPersonOptions by adding the following (in bold) at the end of the init() method.

   @Override
   public void init() {
       super.init();
   
       try {
           _init();
       } catch (Exception e) {
           log("SessionBean1 Initialization Failure", e);
           throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
       }
       // Fill in the personOptions[]
       buildPersonOptions();
   
   }

9. Call the method updateTrips4Person by adding the following (in bold) at the end of the setSelectedPersonId method.

   public void setSelectedPersonId(Integer selectedPersonId) {
       this.selectedPersonId = selectedPersonId;
       updateTrips4Person();
   }

10. Save your changes.
11. Right-click the project node in the Projects window and choose Build.

Binding Components to Data

In this section, you bind the Drop Down List and Table components in the web page to the properties defined in the previous section in SessionBean1.

1. Open Page1.jsp in the Visual Designer.
2. Right click the Drop Down List component and choose Property Bindings to open the Property Bindings dialog window.
3. Select items in the bindable property list and personOptions (under the SessionBean1 node) in the binding target list. Click Apply.
   
4. In the same dialog, select selected in the bindable property list and selectedPersonId (under the SessionBean1 node) in the binding target list. Click Apply.
   
5. Click Close to close the dialog window.
6. In the Visual Designer, right click on the Table component and select Table Layout.
7. In the dialog, choose trips4Person (SessionBean1) from the Get Data From drop-down list.
   

   Note: If you do not see trips4Person (SessionBean1) in the drop-down list, most likely is because you forgot to build the project at the end of the previous section.

8. Select personId in the Selected list and click the left-arrow button Left Arrow Button to move the field from the Selected list to the Available list.
9. Use the Up and Down buttons to arrange the remaining fields in the following order, as shown below, and click OK.
   
10. In the Editing toolbar, click Java to open Page1.java in the Java Editor.
11. In the prerender method, add the following code (displayed in bold).

    public void prerender() {
        try {
            if (dropDown1.getSelected() == null ) {
                Option firstPerson = getSessionBean1().getPersonOptions()[0];
                getSessionBean1().setSelectedPersonId((Integer)firstPerson.getValue());
            }
        } catch (Exception ex) {
            log("Error Description", ex);
            error(ex.getMessage());
        }
    }

    The code in the prerender method is invoked before a web browser starts to display the page. Adding the code to the prerender method causes the page to display the information for the first person in the drop-down list when the user first visits the page.

    When the browser first requests the page, the application creates an instance of Page1 and calls the prerender method. The server sends the response (the HTML page) and the Page1 instance is destroyed. The application does not call the value change event handler, because the application only generates value change events when a page is submitted (in this case, when a new person is selected).

12. Right-click in the source and choose Fix Imports from the popup menu to open the Fix Imports dialog box. In the Fully Qualified Name drop-down list, select com.sun.webui.jsf.model.Option, as shown below.
    
13. Save your changes.