Wednesday, April 2, 2008

CRUD implementation with JDeveloper 11g

In this post I want to describe how its possible to implement Create-Read-Update-Delete (CRUD) functionality with JDeveloper 11g. There are many approaches that can be used to implement those functions with JDeveloper 11g. Today I will describe how to develop form based CRUD functionality.

Main advantage of developed sample application - ADF11_CRUD.zip is that CRUD functionality is implemented with Regions and based on ADF Task Flow. This allows to implement logic in separate forms, but to present to user with one page. Regions and ADF Task Flows are features introduced from JDeveloper 11g, in previous releases it was possible to implement CRUD functionality with forms in separate pages or to play with forms rendering using one page. However, both approaches weren't ideal, since users usually don't like to navigate from page to page and on the other hand to implement full functionality inside one page was potential source for bugs.

I have designed ADF Task Flow in my sample application:


Page fragment that is opened first, when running defined task flow is - departments. This fragment contains Master information for Detail part accessed in subsequent pages. Implemented page fragments are aggregated by ADF Task Flow and registered to be used in main.jspx page as Region. ViewController layer structure, one JSPX page and four fragments:


When you will run sample application, main.jspx will be opened and you will see departments fragment:


Here you can choose one of the Departments and go to Detail part - Employees CRUD functionality. User still will be on the same page, however new fragment will be opened - employeesUpdate:


From here we can involve Create functionality in employeesCreate fragment:


You can notice that JobId is read-only in this form, it's because I'm assigning default value for this attribute. However, it can be changed later. JobId is assigned from value stored in #{processScope.JobId}:


When new employee is created, employeesUpdate fragment will be opened automatically. Here you can update employee information:


And finally, when Delete button is pressed, confirmation fragment for Delete action is opened:


Delete action is invoked from Backing bean, I'm using removeCurrentRow() function to remove row from iterator:

4 comments:

Ricardo said...

Would you have the sql to create the tables?

Andrejus Baranovskis said...

Hi,

HR schema comes with Oracle XE, but if you dont have it, always can download from OTN - Demoscripts.

Regards,
Andrejus

Andreas K said...

Hello Andrejus,

do you know, if there is a way to implement the delete functionality declarativly (without backing bean code)? Because both operations (removeWithRowKey, Commit) are available declarativly?

Is it maybe possible with the current production release 11.1.1.0.1? e.g. to define a sequence of commands in the binding layer...

Greets,
Andreas

Aleto said...

Hi Andrejus,

i read permanent your blog and download your examples, and this help me so much for my training, but i'm interesting on a CRUD operation, not using ADF BC but ADF only with toplink, do you have any example of this because all you example are with ADF BC.
i need ADF, Toplink, using EJB session beans on jdev is the proeject JAVA EE, not fusion Aplicattion.

Regards,
Alejandro