ADF View Objects

How to create ADF View Objects

What is View Object ?
A Typical View Object that lets you to work with set of rows .  View object contains SQL Query that collects data from Database . It can be associated with underlying entity object. At the same time VO query can be formed from various entity objects.

Step 1 :

Right click on AdfDemoModel project and select New

Step 2 :

Select the options as in the below screen shot

Step 3 ;

Enter Package : model.view , Name : EmployeesVO (since we are going to create employee VO out of employee EO ) . Select Updatable access through entity objects radio button. we will do CRUD operations later using this VO from UI ( Insert,Update operation). There are setting that you can set the way VO works (For ex : read only VO , this just helps to read data from DB not to do any CRUD operations) . Click Next

Step 4 :

Select the EmployeesEO from Avaiable area and shuttle it to Selected area and click Next .

Step 5 :

Shuttle all the attributes from left to right.

Step 6 :

Attribute settings can be made and there are various options .
Just click Next

Step 7 :

Using this step we can edit query .  Query can be edited from selecting Expert from SQL Mode drop down.
we can add where clause and order by to the existing query .Click Ok

Step 8 :

Bind variable can be added to the VO and it can be appended to the query at run time . Just Click Next


Step 9:

Java files can be generated for the VO which contains the getter and setter methods for the VO attributes.

Step 10 :

Check the application module check box and type as given in the below screen shot and click Next and click Finish. NOTE : If you uncheck this option when creating VO then we need to externally create AM and add VO instance to it . Refer how-to-create-adf-application-module and add VO to it . If you check application module when creating VO, then you can skip the lesson how-to-create-adf-application-module and add VO to it .

Step 11 :

Final look of just created VO

NOTE :  we can also create VO when creating Entity Object ( adf-model-how-to-create-entity-object Step 10) . This is direct approach .