Install Oracle JDeveloper10g.

Install the sample schema and create a connection to the HR or HR8 schema to use in this lesson. See Installing the Sample Schemas and Establishing a Database Connection.

Create a Session Facade

In the Application Navigator, right-click the Applications node and choose New Application Workspace.

The Create Application Workspace dialog opens.

Change the Application Name to HRApplication.
In the Application Templates field, choose Web Application [JSP, Struts, EJB] from the dropdown list.

Click OK to create the Application Workspace. The new application is represented in the Application Navigator by two new projects, Model and ViewController.

From the File menu, choose Save All.

In the Application Navigator, right-click Model (under the HRApplication node) and choose New.

The New Gallery opens.

In the New Gallery, under the Categories list, expand Business Tier, and select Enterprise JavaBeans. In the Items list, select EJB Diagram.

Click OK. The Create EJB dialog opens.

Accept the default package name, but change the name of the diagram to EJB HR Diagram.

Click OK.

In the Navigator, click the Connections tab.
In the Connection Navigator, expand the nodes for Database, jdbc_tutorial_connection, HR, and Tables.

If you have not established this connection to the HR schema, please see prerequisites section.

Select DEPARTMENTS and drag it onto the blank EJB diagram.

The Create from Tables dialog opens

In the Create from Tables dialog, select EJB 2.0 Entity Beans and click OK.

The new entity bean appears on the diagram.

In the Navigator, click on the Applications tab and you'll notice that a new node, Departments, appears in the Application Navigator in the model package.

From the File menu, choose Save All.

In the Component Palette, click Session Bean and then click inside the EJB diagram.

The Create Enterprise JavaBean Wizard opens.

Review the information on the welcome page and click Next.
On the Name and Options page, change the EJB Name to hrApp.

Click Next .

On the Class Definitions page, accept the default values and click Next.
For this sample we use local interfaces as the client JSP pages are running in the same OC4J instance. On the EJB Home and Component Interfaces page, clear the checkbox for Include Remote Interfaces and select the box for Include Local Interfaces.

Click Finish.

In the Component Palette, choose EJB Local Reference.

In the diagram, click on the session bean ( hrApp), drag to the entity bean ( Departments) and click again.

The local reference is displayed as a line between hrApp and Departments.

Select the Departments bean in the EJB diagram.
Right-click and select Generate | Data Transfer Object.

If the generated DTO is off the screen on the diagram, select Thumbnail from the View menu to navigate through your EJB diagram.

On the EJB diagram, click in the first empty cell of the hrApp session bean and add a new attribute named showDepartments : Collection.

Click in the second empty cell and add a new method named updateDepartment(DepartmentsLocalDTO dept) : void

Click in the next cell and add a new method named addDepartment (DepartmentsLocalDTO dept) : void

On the diagram, right click hrApp and choose Go to Source | hrAppBean.java Bean Class.
The Code Editor opens.

In the Code Editor, scroll down to the getShowDepartments() method.
Modify this method so that it returns a collection of Department DTOs by copying and pasting the following code:

public Collection getShowDepartments()
{
 try
 {
 ArrayList al = new ArrayList();
 Collection col = this.getDepartmentsLocalHome().findAll();
 DepartmentsLocal dept;
 Iterator it = col.iterator();
 while(it.hasNext())
  {
  DepartmentsLocalDTO deptsDTO = new DepartmentsLocalDTO((DepartmentsLocal)it.next());
  al.add(deptsDTO);
  }
 return al;
 }
 catch (FinderException e)
 {
 System.out.println(e.toString());
 throw new javax.ejb.EJBException(e);
 }
 catch (NamingException e)
 {
 System.out.println(e.toString());
 throw new javax.ejb.EJBException(e);
 }
}

Locate the updateDepartment() method and modify the method by copying and pasting the following code:

public void updateDepartment(DepartmentsLocalDTO dept)
{
 try
 {
 DepartmentsLocal deptlocal = this.getDepartmentsLocalHome().findByPrimaryKey(dept.getDepartmentId());
 deptlocal.setDepartmentName(dept.getDepartmentName());
 deptlocal.setLocationId(dept.getLocationId());
 deptlocal.setManagerId(dept.getManagerId());
 }
 catch (FinderException e)
 {
 System.out.println(e.toString());
 throw new javax.ejb.EJBException(e);
 }
 catch (NamingException e)
 {
 System.out.println(e.toString());
 throw new javax.ejb.EJBException(e);
 }
}

Note: The method only updates Department Name and Location ID. Additional logic can be added to update other fields.

Modify the addDepartment() method by copying and pasting the following code:

public void addDepartment(DepartmentsLocalDTO dept)
{
 try
 {
 this.getDepartmentsLocalHome().create(dept.getDepartmentId(),
                                       dept.getDepartmentName());
 }
 catch (NamingException e)
 {
 System.out.println(e.toString());
 throw new javax.ejb.EJBException(e);
 }
 catch (CreateException e)
 {
 System.out.println(e.toString());
 throw new javax.ejb.EJBException(e);
 }
}

Import the following classes:

import java.util.ArrayList;
import java.util.Iterator;
import javax.ejb.FinderException;
import javax.ejb.CreateException;

In the Application Navigator, right-click hrApp and choose Make to compile.

From the View menu, choose Data Control Palette.

The Data Control Palette opens.

Drag hrApp from the Application Navigator to the Data Control Palette.

Notice the following files in the Application Navigator:

hrAppLocalDataControl.java is the DataControl that exposes the methods and accessors in the business service layer.
hrAppLocalDataControlBeanInfo.java is the bean info class, which hides the system methods appearing in the Data Control Palette.
hrAppLocalDataControl.xml contains the metadata for the methods and accessors.

In the Application Navigator, click hrAppLocalDataControl.xml.
In the Structure pane, select showDepartments.

From the View menu, choose Property Inspector.
Select the Bean Class field and click the ellipsis ( ...).

The Bean Class dialog opens.

In the Bean Class dialog, click Browse.
In the Class Browser, select model.DepartmentsLocalDTO and click OK.

Click OK to close the Bean Class dialog.
DepartmentsLocalDTO.xml is generated. This file contains the metadata for the collection.

From the File menu, choose Save All.

In the Application Navigator, expand the ViewController project, the Web Content folder, and the WEB-INF folder. Double-click struts-config.xml to see a blank page flow diagram.

In the Component Palette, click the Data Page element and then click on the diagram to create it.

A new data page appears on the diagram.

Change the name to /browseDepartments.

Double-click /browseDepartments to create the JSP. Accept the default JSP name.

Optionally, add the text List of Departments to the JSP. Add a style sheet and modify the JSP page as needed.

On the Component Palette, click the Data Controls tab. On the Data Control Palette, click showDepartments. In the Drag and Drop As dropdown list, select Read-Only Form.

Drag showDepartments from the Data Control Palette and drop it onto browseDepartments.jsp in the Editor.

A new read-only form is created on the page. Right now the read-only form is functional, but it would only show the first record in the Departments table.

In the Data Control Palette, expand the nodes for showDepartments and Operations, and click First.
In the Drag and Drop As dropdown list, select Button.

Click inside the border of the read-only form you created (but not inside the table cells) to drop the button.

In a similar manner, drop Previous, Next, and Last buttons from the Data Control palette to browseDepartments.jsp .

Drag the buttons around if you want to arrange them differently.

From the File menu, choose Save All.

On the Page Flow Diagram, right-click /browseDepartments and select Run. Navigate through the Department rows using the navigation buttons.

First create a page flow for inserting new department data. In the Component Palette, click the Page element and then click on the diagram to create it. Change the name to /createDepartments.jsp.

In the Component Palette, click the Page Link element. Click on /browseDepartments and click again on /createDepartments.jsp to add a link from the browse page to the insert page.

Now create a data action to create the new row. In the Component Palette, click the Data Action element and click on the diagram to create it. Change the name to /createDepartmentsDA.

In the Data Control Palette, expand hrAppLocalDataControl and Operations. Select addDepartment(DepartmentsLocalDTO) and verify that Method is selected in the Drag and Drop As dropdown list.

Drag and drop the addDepartment() method to the /createDepartmentsDA data action.

Next, override the method in the createDepartmentsDA data action to take the parameters from Request object and create a DTO.

Right click /createDepartmentsDA and choose Go To Code.
In the Create Struts Data Action dialog, change the package name to view.actions.

This creates a separate package where all struts actions can reside.
Click OK to create CreateDepartmentsDAAction.java.

From the Tools menu, choose Override Methods...

In the Override Methods dialog, select the initializeMethodParameters() checkbox.

Click OK.

Update the initializeMethodParameters() method in CreateDepartmentsAction.java with the following code:

protected void initializeMethodParameters(DataActionContext actionContext, JUCtrlActionBinding actionBinding)
{
 // Construct a new DepartmentLocalDTO to be the single parameter for the
 // createDepartments() method
 DepartmentsLocalDTO dept = new DepartmentsLocalDTO();

 // Populate the DepartmentsLocalDTO with data from the form
 String data = actionContext.getHttpServletRequest().getParameter( "departmentId" );
 if ( data != null )
  {
  dept.setDepartmentId( new Long( data ) );
  }
 data = actionContext.getHttpServletRequest().getParameter( "departmentName" );
 if ( data != null )
  {
  dept.setDepartmentName( data );
  }
 data = actionContext.getHttpServletRequest().getParameter( "locationId" );
 if ( data != null )
  {
  dept.setLocationId( new Long( data ) );
  }
 data = actionContext.getHttpServletRequest().getParameter( "managerId" );
 if ( data != null )
  {
  dept.setManagerId( new Long( data ) );
  }

 // Add this DepartmentsLocalDTO to the parameter list for this data action
 ArrayList params = new ArrayList();
 params.add( dept );
 actionBinding.setParams( params );
}

Import the following classes:

import model.DepartmentsLocalDTO;
import java.util.ArrayList;

In the application navigator, double-click the ViewController project.
In the Project Properties dialog, select the Libraries category in the Development node.
Select J2EE in the Available Libraries and use the arrow buttons to move it to Selected Libraries

Click OK. Right-click CreateDepartmentsDAAction.java in the code editor and select Make.

Return to the Page Flow Diagram. Choose the Forward component in the Component Palette, click on /createDepartmentsDA, drag the forward component to the /browseDepartments data page, and click again.

From the page flow diagram, double-click /createDepartments.jsp to create the page and open it in the visual JSP editor.
Optionally, add the text Insert a New Department to the JSP. Add a style sheet and modify the JSP page as needed.

Use the HTML category of the Component Palette to create an html form containing a table with 4 rows and 2 columns.

Add labels and text fields to the table for Department Id, Department Name, Location Id, and Manager Id.

Select the text field for the department id and use the Property Inspector to specify the name of the text field according to the name used in the session bean: departmentId

In the Component Palette, select the Submit button and drag below the table to create it.

Click inside the blank area of the html form to select it. In the Property Inspector, change the action property to /createDepartmentsDA.do

Now change the link from browseDepartments.jsp to createDepartments.jsp to user-friendly text. In the Application Navigator, expand the view project under Application Sources. Double click the ApplicationResources.properties file.

Change the value for link.createDepartments to Insert a New Department.

From the File menu, choose Save All.

On the Page Flow Diagram, right-click browseDepartments.jsp and select Run. Click the Insert a New Department link to add a new Department.

Click Submit to create the new department and return to the browse page.

Now create a Data Action to select the current row for editing or deleting. In the Component Palette, click Data Action.

Click on the page flow diagram to create the Data Action and rename it to /updateDepartmentDA.

In the Component Palette, select the Data Page component and click on the page flow diagram to create a new data page. Name the page /editDepartment.

Choose the Forward component in the Component Palette, click on /updateDepartment, drag the forward component to the /browseDepartments Data Page, and click again.

In the Data Control Palette, expand Operations. Select updateDepartment(DepartmentsLocalDTO) and verify that Method is selected in the Drag and Drop As dropdown list.

Drag and drop the updateDepartment method to the /updateDepartmentDA data action.

Double-click /updateDepartmentDA.
In the Create Struts Data Action dialog, accept the default name and package

This creates a separate package where all struts actions can reside.
Click OK to create UpdateDepartmentsDAAction.java.

From the Tools menu, choose Override Methods...

In the Override Methods dialog, select the initializeMethodParameters() checkbox.

Click OK.

Update the initializeMethodParameters() method in UpdateDepartmentDAAction.java with the following code:

protected void initializeMethodParameters(DataActionContext actionContext, JUCtrlActionBinding actionBinding)
{
 // TODO: Override this oracle.adf.controller.struts.actions.DataAction method
 // super.initializeMethodParameters(actionContext, actionBinding);

 DepartmentsLocalDTO dept = new DepartmentsLocalDTO();

 String data = actionContext.getHttpServletRequest().getParameter( "departmentId" );
 if ( data != null )
  {
  dept.setDepartmentId( new Long( data ) );
  }
 data = actionContext.getHttpServletRequest().getParameter( "departmentName" );
 if ( data != null )
  {
  dept.setDepartmentName( data );
  }
 data = actionContext.getHttpServletRequest().getParameter( "locationId" );
 if ( data != null )
  {
  dept.setLocationId( new Long( data ) );
  }
 data = actionContext.getHttpServletRequest().getParameter( "managerId" );
 if ( data != null )
  {
  dept.setManagerId( new Long( data ) );
  }
 ArrayList deptparams = new ArrayList();
 deptparams.add(dept);
 actionBinding.setParams(deptparams);
}

Import the following classes:

import model.DepartmentsLocalDTO;
import java.util.ArrayList;

In the Application Navigator, expand the View Controller, Application Sources, and view nodes.
Select browseDepartmentsUIModel.xml and in the Structure Pane, select updateDepartment.

In the Property Inspector, set the Requires Update Model property to True.

From the page flow diagram, double-click /editDepartment to create the page and open it in the visual JSP editor.
Optionally, add the text Edit Department Information to the JSP. Add a style sheet and modify the JSP page as needed.

On the Component Palette, click the Data Controls tab. On the Data Control Palette, click showDepartments. In the Drag and Drop As dropdown list, select Input Form.

Drag showDepartments from the Data Control Palette and drop it onto editDepartment.jsp in the Editor.

Select the text field for the departmentId.
In the Property Inspector, set the readOnly property to true.

In the structure pane, select html:form.

In the Property Inspector, change the action property to /updateDepartmentDA.do.

When the Submit button is pressed in editDepartment.jsp, the updateDepartmentDA data action is called.

Open /browseDepartments.jsp in the JSP visual editor. Select the Source tab to view the code.
Place the cursor in front of <c:out value="${bindings.departmentId}"/>&nbsp;

In the Data Control Palette, expand showDepartments and Operations and select setCurrentRowWithKey(String)
In the Drag and Drop As dropdown list, select Find Row Link.

Drag the Find Row Link from the Data Control Palette onto the browseDepartments.jsp page and change the href to point to editDepartment.do

From the File menu, choose Save All.