Gapless Sequence

-

                                                 Gapless Sequence


For this I have create new table in HR


Make two columns as Ids and Names.

Now create new application as hr connection

 


Create model part with table2 eo,vo,app module

 


In eo generate java classes as shows below

 



We have to write doDml statement in java class

 

 


------------------- -----------------------------------------------------------------------------------------------------

    protected void create(AttributeList attributeList) {

        super.create(attributeList);

        SequenceImpl se = new SequenceImpl("Final_SEQ",getDBTransaction());

        this.setIds(se.getSequenceNumber());

       

    }

--------------------------------------- ------------------------------------------------------------------------------------


 ------------------------------------------------ -------------------------------------------------------------------------- 

     protected void doDML(int operation, TransactionEvent e) {

        super.doDML(operation, e);

        if(operation == DML_INSERT){

            SequenceImpl se = new SequenceImpl ("Final_SEQ",getDBTransaction());

            this.setIds(se.getSequenceNumber());

}

----------------------------------------- ------------------------------------------------------------------------

        Now create jspx page



 

Drop in that page form from data control as adf form

 


 


 

Here take submit create insert ,commit, rollback buttons

 


 

Now Run the page for see output

 


Give value in that form fields


Click on submit then commit

Now go DB and refresh table here rows created

 


If u want to delete one row from DB select that column click on delete then commit


 

See in DB refresh table here row was deleted

If I delete ids 3  then hit the commit its remove from Data Base


FARHATH

Comments

Post a Comment

Popular posts from this blog

Programmatically invoke a Popup to create a new row.

-
Image
  Programmatically invoke a Popup to create a new row. Create an Application . Create the model part with Employee Table. Create EmployeeEO, EmployeeVO and AppModule. Now in the View controller project create a page (Employee.jspx). From the Data control drag and drop EmployeeVO1 (EmployeeVO instance) in to the page as Read only table. Surround this table with Panel Box. In the tool bar facet of panel box, drop a command button from the component pallate. Drag and drop Popup on to the page. Inside popup drop a dialog box. Create a ActionListenerEvent for the button "New". And bind RichPopup to the bean. Code for button.............       public void displayPopUp(ActionEvent actionEvent) {         // Add event code here...                  BindingContext bctx=BindingContext.getCurrent();         BindingContainer bctr=bctx.getCurrentBindingsEntry();         Operatio...
Read more

POJO(Plain Old Java Object) - Editable Data - DataControl.dcx

-
Image
POJO(Plain Old Java Object) - Editable Data - DataControl.dcx     Without using EO’s & VO’s we can create a UIPage with Java Class. First we need to create a Java Classes name it as a Entity Java Classes (i,.e. DepartmentsEO, EmployeesEO, LocationsEO.) Then Again create another three java classes for storing data in Department List Java class, Employee list, Location List. Below image for Creating Java classes.  End of the Page have a ZIP file  This JAVA class for creating list of Data (Dept list, Emplye list, location list) Now we have to create Another Java class for calling the All the above created java classes( This Java Class Act like APPMODULE ) Name it as Session Façade. After Creating Session Façade Java Class. Just Right click on the java class, in that options select the Create Data Control. CREATING DATA CONTROL After Creating Data control, All the java classes automatically created .XML files . Java Code for DepartmentsEO,   EmployeesEO, Locatio...
Read more

Dynamic Tabs in ADF

-
Image
First we have to create Departments and Employees(EO's,VO's,AM) Create Two task-flows ( Departments and Employees Creating JSPX page in adfc-config.xml Now Create to take " Oracle Dynamic Tabs Shell " (Max 15 tabs Only) In page template we have navigation facet, in that drag drop two links from component palette , for that link create ActionListener to write the java code in that.                                                            public class launcher {     public void openDepartmentsAsMain(ActionEvent actionEvent){         try{             TabContext.getCurrentInstance().setMainContent("/WEB-INF/dept-task-flow#dept-task-flow");         } catch (TabContext.TabContentAreaDirtyException e) {         }     }     pub...
Read more