Simple Example

This is an example of a simple case. A single table "PERSON" stores the first, and last names of a person. The table is keyed by an artifical primary key created by an Oracle sequence. We will generate the code for a Java class Person.java for reading and writing to this table.

The ddl for creating the PERSON table is in table-definition.sql.
The file "person.xml" contains the details of the PERSON table, and the Java object we will generate.
The shell command generate.sh invokes the Xalan parser.
It applys the template oracleObjectPersisterTemplate.xsl against the data in the person.xml file.
The output will be written to Person.java.
Use "compile.sh" to compile the Person and Test objects.
The "Test.java" class demonstrates how to use the Person object.
Use "run.sh" to run the Test class.

Here are some examples of using the Person object.

You can create new row on the person table like this:

     Person person = new Person();           // Create a new empy Person             
     division.setFirstName("John");          // set the first name
     division.setLastName("Smith");          // set the last name
     division.store();                       // Insert the row to the table
   
     Assume that new person row was created a primary key of "1".

Now to read the details of a person:

     Person person = new Person(1);
     Location location = new Location(30);        // Get the existing location
     System.out.println("First Name = " + person.getFirstName() );
     System.out.println("Last Name = " + person.getLastName() );

You can modify a person if you have it's primary key:

     Location location = new Location(1);        // Get the existing location
     location.setFirstName("Jane);               // Change the name
     location.store();                           // Updates the person table

Back to: XSL template for JDBC Code generation