Monday, February 24, 2014

Sample ADF CRUD web application

In this post i will show you how to use ADF to create a simple CRUD application in just few minutes.

To know more about ADF "Application development framework" please go to this link.

1. Create an ADF web application.

2. Set application name "Sample Crud" and click finish.

3. Choose "Connect to a Database" and press "Create a Database Connection".

4. Put connection details, and connect to the Oracle Sample HR database, and make sure to test the connection.

Note: Make sure that the hr user is not locked, and if its locked you may need to unlock it.

5. Mark the "Connect to a database" step as Done.

6. Expand the "Build Business Services" step and click "Go to Substeps".

7. Expand "Create Entity Objects and Associations", Press "Create Entity Objects and Associations".

8. Choose the model project.

9. Choose the database connection created in step 3.

10. Press the Query button, and move the Jobs table to the right column.

11. For the updatable views, chose JobsView and move it to the right column, then press finish.

12. Mark the "Build Business Services" step as Done.

13. Open the "adf-config" unbounded task flow.

14. From the "Component Palette" panel drag the view icon to the task flow.

15. Rename it to "jobsView" and double click on it, and then click Ok.

16. Drag a button from "Component Palette" panel into the page, and rename it from the property panel.

17. Do the same for the Edit, Delete, View buttons.

18. From the "Data Control" panel, drag the JobsView1 into the page, and insert it as a read only table.

19. Choose "Single Row" for selection, and click Ok.

20. Back to the "adf-config" unbounded task flow, and drag a new view for the job form.

21. Double click the new page, and drag the JobsView1 into it from the "Data Control" panel as a form.

22. Check the "Include submit button" checkbox, and click Ok.

23. Back to the "adf-config" unbounded task flow, and drag a new view for the job details.

24. Double click the new view, and add the JobsView1 into it as a read only form, and click Ok.

25. Back to the "adf-config" unbounded task flow, In the "Data Control" panel, expand the JobsView1 -> Operations and drag the "CreateInsert" operation into the task flow.

26. Do the same for "Delete" operation.

27. From "Data Control" -> Operations, drag "Commit" and "Rollback" operations into the task flow page.

28. From the "Component Palette" panel click the "Control Flow Case" icon and drag from "jobsView" page to the "viewJobDetails" page, and name it "view".

29. Do the following to complete navigation flow for our business case:

A. "create" flow from "jobsView" to "createInsert" operation.
B. "edit" flow from "jobsView" to "jobForm" page.
C. "delete" flow from "jobsView" to "delete" operation.
D. "CreateInsert" flow from "CreateInsert" operation to "jobForm" page.
E. "Delete" flow from "Delete" operation to "Commit" operation.
F. "save" flow from "jobForm" page to "Commit" operation.
G. "cancel" flow from "jobForm" page to "Rollback" operation.
H. "Commit" flow from "Commit" operation to "jobsView" page.
I. "Rollback" flow from "Rollback" operation to "jobsView" page.
J. "back" flow from "viewJobDetails" page to "jobsView" page.

30. Go to the "jobsView" page, and double click it, and from the property panel, change the action for each button to be as follow:

A. "View" button action = "view"
B. "Create" button action = "create"
C. "Delete" button action = "delete"
D. "Edit" button action = "edit"

31. In the "jobForm" page, add a new button and name it cancel, and the action = cancel, imediate=true.

32. In the "viewJobDetails" page add a new button and name it back, and the action = back.

33. Right click the adf-config unbounded task flow and click run, if prompted to choose the run configuration choose "jobsView" page to be the start page.

34. Screen shots for the application:



  1. Thank you. This helped a lot!!

  2. Thanks for this,Creating ADF web application is easy. Fresh developers must read this post because it is helpful to learn;

  3. Wow, very impressive details with the snapshot for the processing of crud web application. Thanks for the sharing.

    Advanced app development in coimbatore | Alternate mobile apps solutions

  4. Thanks for sharing this useful blog and I think this blog is very useful for the fresh beginners who wish to create web applications.

  5. Thanks for your blog but i have the below error
    Server Instance IntegratedWebLogicServer is currently starting or stopping. Please try again when it has completed.

  6. Very good explain. For more details of development services click here.
    Web Application Development
    Web Development Services

  7. The cancel button in the JobForm is not working, why? Or is the problem from me?