Part 1: Create Business Components

You can easily install the schema and connect to the database, and then create an application and project in which to organize your application files. Then work in JDeveloper's IDE to create the business services for your application.

Install the Schema: Download the schema zip file from OTN and install it. The cue cards use tables that are part of the Fusion Order Demo (FOD) schema.

Create a New Application: Use the Create Application wizard to create a web application based on the application template that includes the ADF Faces, ADF Page Flow, and ADF Business Components technologies.

Create a Database Connection: Use the Create Database Connection dialog to create a connection to the schema.

Create Oracle ADF Business Components: Use the Create Business Components from Tables wizard to create the business components that will provide access to data and implement the business logic.

Edit the View Object: Use the Attributes and Entity Objects pages in the view object editor to modify the view object.

Add Validation Logic: Add validators in the Add Validation Rule dialog.

Test the Application: Test the application in the Business Component Browser.

Install the Schema

1. Download the schema zip file from OTN. If you created the schema previously, go to the next cue card.
2. Unzip the file to a convenient location (for example, c:\temp).
3. From the File menu, choose Open . Open the workspace c:\temp\Infrastructure\Infrastructure.jws.
4. If you are prompted to migrate the project, click Yes to confirm, then click OK.
5. In the Application Navigator, expand the MasterBuildScript project. Under Resources double-click build.properties to open it in the editor.
6. Set the appropriate values in the build.properties file ( jdeveloper.home, and all the jdbc.* and db.* settings). Keep all other properties set to their default values. The demo user must be named FOD.
   The relevant settings are:
   jdeveloper.home             The /jdeveloper directory where you have JDeveloper installed, for example, c:/JDeveloper_11/jdeveloper/
   jdbc.urlBase                    Base URL for your database, for example, jdbc:oracle:thin:@localhost
   jdbc.port                         Port number for your database, for example, 1521
   jdbc.sid                           Database System Identifier, for example, XE or ORCL
   db.adminUser                  Database user with admin privileges, for example, system
   db.demoUser.tablespace  Tablespace name where the FOD user will be installed, for example, USERS
7. In the MasterBuildScript project, select the build.xml file.
8. In the Structure window, right-click the refreshSchema target and choose Run Target "refreshSchema" .
9. When prompted, enter the password for the database user with admin privileges.
   

   In the IDE

   After running the Ant task, you should see a build successful message in the JDeveloper Log window.   [ tell me more...]

   
   
   

Create a New Application

1. Open the Create Application wizard [ File > New > General > Applications > Application] .
2. Enter the application name BrowseEditApp to follow along with the example.
3. In the A pplication Package Prefix field, enter oracle.fod.
4. Select Fusion Web Application (ADF) from the Applica tion Template list, and click Finish .
   

   Application Templates

   Application templates provide you with a quick way to create the project structure for standard applications with the appropriate combination of technologies already specified. The new application created from the template appears in the Application Navigator already partitioned into tiered projects, with the associated technology scopes set in each project.   [ tell me more...]

   
   
   
5. In the Application Navigator, expand the Application Resources panel to see where resources for this application are displayed.
   

   In the IDE

   The application template that you used for your application partitions your application into two projects: Model and ViewController. In the Application Navigator, projects are displayed as the top level in the hierarchy. The Application Navigator should now look like this:   [ tell me more...]

   
   
   

Create a Database Connection

1. Open the Create Database Connection dialog [ File > New > General > Connections > Database Connection] .
2. Select Application Resources if it is not selected as the Create Connection In option.
3. Enter a name for the connection, select the connection type, and enter the username and password. To follow along with this example, use FOD for the connection name and fod for the username.
4. Click Test Connection to confirm that you can connect.
5. Click OK if the connection was successful.
6. In the Application Navigator, expand the Connections and Database nodes in the Application Resources panel to see the database objects.
   

   In the IDE

   The database connection is now included as a resource for your application in the Application Resources panel of the Application Navigator.   [ tell me more...]

   
   
   

Create Oracle ADF Business Components

1. In the Application Navigator, select the Model project and launch the Create Business Components from Tables wizard [ File > New > Business Tier > ADF Business Components > Business Components from Tables] .
2. In the Initialize Business Components Project dialog which opens before the wizard, confirm that the database connection you created (for example, FOD) is the current selection and click OK.
3. On step 1 of the Business Components from Tables wizard, Entity Objects, click Query to populate the A vailable list.
4. Select three tables, ORDERS, ORDER_ITEMS and PRODUCTS_BASE, from the A vailable list and shuttle them to the Selec ted list to create default business components based on them. Then click Next .
5. On step 2, Updatable View Objects, select business components Orders (FOD.ORDERS) and OrderItems (FOD.ORDER_ITEMS), from the A vailable list and shuttle them to the Selec ted list. Then click Next .
6. Click Next to skip step 3, Read-Only View Objects, which aren't needed.
7. On step 4, Application Module, change the application module name to FODModule. Then click Finish .
   

   ADF Business Components

   The Create Business Components from Tables wizard does not create a user interface (this is governed by the "view" portion of the application), nor does it determine other application logic such as control flow. It just provides a representation of, and access to, data, and implements business logic.  [ tell me more...]

   
   
   
8. Click Save All to save your work.
   

   In the IDE

   After completing the Create Business Components from Tables wizard, the Model project in the Application Navigator should look like this:  [ tell me more...]

   
   
   

Edit the View Object

1. In the Application Navigator, double-click OrdersView in the Model project to open it in the view object editor.
2. Select the Attributes tab to display all the attributes in the OrdersView view object.
3. In the attributes table, select the following attributes: PaymentOptionId, DiscountId, CouponId, CollectionWarehouseId, CreatedBy, CreationDate, LastUpdatedBy, LastUpdateDate, and ObjectVersionId. Then click Delete.
   

   Removing Attributes

   By removing attributes from the OrdersView view object you have reduced the number of columns in the view object's query.  [ tell me more...]

   
   
   
4. In the Application Navigator, double-click OrderItemsView in the Model project to open it in the view object editor.
5. Select the Entity Objects tab.
6. Select ProductsBase in the Available pane and shuttle it to the Selected pane.
   

   Entity Objects

   A view object can be based on more than one entity object; you do this if you need your client pages to show data from multiple tables. In the list of order items on the client page you will show each item's id, quantity and price, from the OrderItems entity object, as well as the product name, from the ProductsBase entity object.   [ tell me more...]

   
   
   
7. Select the Attributes tab. To add the ProductsBase attributes to the OrderItemsView object, choose Add Attribute from Entity from the Add dropdown menu.
8. In the Attributes dialog, select the following attributes under the ProductsBase node in the A vailable pane: CategoryId, ProductName, and WarrantyPeriodMonths. Then shuttle the selected attributes to the Selected pane. Click OK.
   

   In the IDE

   The OrdersView view object now contains attributes from both the Orders entity object and the ProductsBase entity object. Notice that OrderItemsView now contains two ProductId attributes: ProductId from the OrderItems entity object and ProductId1 from the ProductsBase entity object; this is necessary to specify the join between the two entity objects.  [ tell me more...]

   
   
   

Add Validation Logic

1. In the Application Navigator, double-click Orders in the Model project to open it in the entity object editor.
2. Select the Business Rules tab.
3. Select Orders and then click Add.
4. In the Add Validation Rule dialog, select Script Expression from the Rule Type dropdown list.
5. On the Rule Definition tabbed page, enter OrderShippedDate == null || OrderShippedDate >= OrderDate in the E xpression panel. Click Test to verify the expression, and click OK when you see the expression syntax check message.
6. Select the Failure Handling tab. Click Add to add a row to the Message Text table.
7. Change the default Message Id to Orders_10. Change the default Message String to {0} cannot be earlier than {1}. Then press Enter or Tab.
8. In the Token Message E xpressions table, enter the error message expressions. For Message Token 0, enter source.hints.OrderShippedDate.label as the Expression. For Message Token 1, enter source.hints.OrderDate.label. Then click OK.
   

   In the IDE

   You have created a custom error message for your validation rule; the {0} and {1} are placeholders for parameters that you will define as the labels of the OrderShippedDate and OrderDate attributes. ADF Business Components allow you to create custom labels for each attribute; these labels are stored in message bundles that can be translated for different locales, and they are automatically displayed as the attribute's label on client pages. In this example you have not defined custom labels, so the labels default to the names of the attributes.  [ tell me more...]

   
   
   

Test the Application in the Business Component Tester

1. In the Application Navigator, right-click FODModule and choose R un .
2. In the Oracle Business Component Browser, double-click OrdersView1.
3. Browse through the orders until you reach an order without an OrderShippedDate. Enter a new order shipped date that is earlier than the order date. For example, if the order date is 2009-01-14, enter 2009-01-13 for the order shipped date.
4. Click Move to navigate to the next record. Click OK when you see the error dialog containing your error message: OrderShippedDate cannot be earlier than OrderDate.
5. Change the order shipped date so that it is later than the order date. For example, if the order date is 2009-01-14, enter 2009-01-15 for the order shipped date, so that no error dialog displays.
6. Click Save changes to the database to save your changes.
7. Close the Oracle Business Component Browser.
   

   In the IDE

   After entering valid data, the Oracle Business Component Browser shows the data that you have just saved to the database:   [ tell me more...]

   
   
   

Copyright © 1997, 2009, Oracle. All rights reserved.