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.