Monday, September 9, 2013

How to execute sql using ADF Application

How to execute sql using ADF Application

I am going to explain the here is How can we execute the sql statement Application.
  • Open your AppModule. 
  • Select the java option
  • Add the below appmodule classes like AppModuleImpl. 
  • Click on edit icon and select Generate Application Module Class
  •  
  • Once click on ok button java class is added to appmodule
  •  
  •  Go to Java class by clicking the link on appmodule for java class
  •  Add your method like below
  •  
  •  Once you done with method add. Open the Appmodule select the java tab again 
  •  
  • Click on the edit link of Client Interface section, It will launch a popup which will show list of method you added to your application module like below:
  • Select the method from available and mode it to selected
  • Once you click on OK button and goto data-control section. you can found your method added to list.
  • Drag drop parameters form
  • Select the return Boolean as desired output
Now your page is ready to use your custom method as Button.