Merge Records in Session bean by using ADF Drag/Drop

Posted by shantala.sankeshwar on Oracle Blogs See other posts from Oracle Blogs or by shantala.sankeshwar
Published on Tue, 15 Mar 2011 14:37:00 +0530 Indexed on 2011/03/15 16:15 UTC
Read the original article Hit count: 378

Filed under:
|
|

This article describes how to merge multiple selected records in Session Bean using ADF drag & drop feature.
Below described is simple use case that shows how exactly this can be achieved.

Here we will have table & user input field.Table shows  EMP records & user input field accepts Salary.When we drag & drop multiple records on user input field,the selected records get updated with the new Salary provided.

Steps:

Let us suppose that we have created Java EE Web Application with Entities from Emp table.Then create EJB Session Bean & generate Data control for the same.

Write a simple code in sessionEJBBean & expose this method to local interface : 

public void updateEmprecords(List empList, Object sal)
{
      Emp emp = null;
      for (int i = 0; i < empList.size(); i++)
      {
       emp = em.find(Emp.class, empList.get(i));
        emp.setSal((BigDecimal)sal);
      }

     em.merge(emp);

  }

Now let us create updateEmpRecords.jspx page in viewController project & Drop empFindAll object as ADF Table

adf_table

Define custom SelectionListener method for the table :

   public void selectionListener(SelectionEvent selectionEvent) 
    {
    // This method gets the Empno of the selected record & stores in the list object
     UIXTable table = (UIXTable)selectionEvent.getComponent();
     FacesCtrlHierNodeBinding fcr
     =(FacesCtrlHierNodeBinding)table.getSelectedRowData();
     Number empNo = (Number)fcr.getAttribute("empno") ;
      this.getSelectedRowsList().add(empNo);
    }

Set table's selectedRowKeys to #{bindings.empFindAll.collectionModel.selectedRow}"

Drop inputText on the same jspx page that accepts Salary .Now we would like to drag records from the above table

& drop that on the inputtext field.This feature can be achieved by inserting dragSource operation inside the table &

dropTraget operation inside the inputText:

<af:dragSource discriminant="tab"/> //Insert this inside the table
<af:inputText label="Enter Salary" id="it13" autoSubmit="true" 
      binding="# {test.deptValue}">
      <af:dropTarget dropListener="#{test.handleTableDrop}">
      <af:dataFlavor
       flavorClass="org.apache.myfaces.trinidad.model.RowKeySet"    discriminant="tab"/>
      </af:dropTarget>
      <af:convertNumber/>
</af:inputText>

In the above code when the user drags & drops multiple records on inputText,the dropListener method gets called.

Goto the respective page definition file & create updateEmprecords method action& execute action

updateAction

execute

dropListener method code: 
       public DnDAction handleTableDrop(DropEvent dropEvent)
       {
         //Below code gets the updateEmprecords method,passes parameters & executes method
           DataFlavor<RowKeySet> df = DataFlavor.getDataFlavor(RowKeySet.class);
           RowKeySet droppedKeySet = dropEvent.getTransferable().getData(df);
           if (droppedKeySet != null && droppedKeySet.size() > 0)
          {
                 DCBindingContainer bindings =

                 (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                 OperationBinding updateEmp;
                 updateEmp= bindings.getOperationBinding("updateEmprecords");
                 updateEmp.getParamsMap().put("sal",
                 this.getDeptValue().getAttributes().get("value"));          
                 updateEmp.getParamsMap().put("empList", this.getSelectedRowsList());
                 updateEmp.execute();

//Below code performs execute operation to refresh the updated records
                OperationBinding executeBinding;
                executeBinding= bindings.getOperationBinding("Execute");
                executeBinding.execute();

AdfFacesContext.getCurrentInstance().addPartialTarget(dropEvent.getDragComponent());
                this.getSelectedRowsList().clear();
         }
                return DnDAction.NONE;
       }

Run updateEmpRecords.jspx page & enter any Salary say '5000'.

Select multiple records in table & drop these selected records on the inputText Salary.

Note that all the selected records salary value gets updated to 5000.


 

© Oracle Blogs or respective owner

Related posts about adf

Related posts about ejb