XSL template for JDBC Code generation Icon

XSL template for JDBC Code generation

This XSL template generates Java code for mapping objects to an Oracle database.

XSL template for JDBC Code generationOverview

This Xsl template generates Java code for mapping objects to an Oracle database. You supply an Xml file with the Details of the table, and Java Class to generate for dealing with that table. An XSL processor, like Xalan, is used to read the template and xml files, and output a Java source file. There are many ways to arranges table to store a set of data. This template does not attempt to cover all cases- but requires that the database layout follow a pattern.

The tables should be indexed by artifical primay keys of type NUMBER. A table should contain the foreign key column to any sub type tables that add data to it in a one to one relationship. For example when a PERSON table is linked to a ADDRESS table; the PERSON table should have column that contains the primary key of the ADRESS row that contains the address information for this person. Also. when a table row can belong to another table row in a many to one relationship then it should contain a foreign key column to it's parent. For example; a PERSON table that is linked to a CREDIT_CARD table. The person can have many credit cards; the CREDIT_CARD table would have a column that points to the primary key that owns it on the PERSON table. Each tables primary key is generated by an Oracle sequence.

The Java classes generated follow a pattern where there is one Java object for each table, and the object represents one row on that table. If the object is instantiated by passing the db key in the constructor it will query the db and populate its properties. New rows are created by calling the no-args constructor, calling the misc set() methods, and then calling store(). Calling the store() method also calls the store() method on any linked objects. Deleting the row is done by callling delete(). Any linked tables are also deleted. See the Simple example for more information.

NEW

Fixed some bugs.

XSL template for JDBC Code generationInformation

Version
N/A
Date
01.12.10
License
Free
Language
English
File Size
210KB
Developer
Category
SubCategory
Operating Systems
Windows ,Linux,Mac OS,BSD,Solaris
System Requirements
No additional system requirements.
Two player game of Pong Icon
A game of Pong for two players
Free
JDScrollBox Class Icon
The Scroll Box Class that you can include in your own Java applets.
Free
Scrolling Image Map Applet Icon
Allow you to use very large image maps
Free
Bouncing Ball Applet Icon
A ball bouncing.
Free
Clickable Image Map Icon
This simple script written in Perl generates a clickable image map.
Free
More
FlexSQL Icon
FlexSQL is a Flex RIA component designed to run SQL queries directly in Flex
Paid
Using XML Schema Repositories Icon
Designing XML documents through DTDs
Free
Marshalling Populations to XML Icon
some sort of marshalling mechanism can be very useful
Free
Schema options Icon
This section describes the various Schema options that are available.
Free
Oracle Rdb7TM Icon
You cannot delete the schema RDB$SCHEMA. EXAMPLES
Free
Representing XML Schema in IFF Icon
illustrate how to represent XML schemas in IFF
Free
verticality schema Icon
A verticality schema is an image schema that involves “up” and “down” re
Free
Xtensible Shopping Bag Icon
extensibility via custom properties, and scalability
Free
More