AuDAO - SQL and Java DAO Generator
This is a free Java
Data Access Objects (DAO),
Data Transfer Objects (DTO)
and SQL script generator
for MySQL, Oracle, HSQLDB and Google App Engine datastores.
The input is a source configuration xml file which describes the tables (entities)
and their relations. The output is a set of SQL scripts and Java DAO layer which allows
you to access your data structures without any knowledge of the underlying datastore API.
Click on the DAO and DTO icons to show the generated classes:
<database version="1.0" xmlns="http://www.spoledge.com/audao">-
<table name="entities" java="Entity">+
For more information about DAO concept, please see Wikipedia or DAO Pattern.
The generated Java DAO layer uses plain JDBC to access database (MySQL, Oracle, HSQLDB).
No other frameworks or technologies are needed to run ! The code is fully under your control.
The generated Java DAO layer for Google App Engine (GAE) uses directly the GAE Datastore API now
It is also possible to generate DAO layer over JDO (using PersistenceManager),
but it is not recommended to use it for production environments due to performance issues.
The generated Java code requires Java 1.5 or higher.
AuDAO is an open-source project hosted at http://code.google.com/p/audao/.
Learn how to begin in Getting Started with AuDAO
or list all DAO and SQL Generator Features
or order and download AuDAO immediatelly.
Why DAO ?
Look at the following code snippets - in the left you can see one JDBC and one JDO code example.
In the right you can see the corresponding code using generated DAO layer.
Which side do you like more ?
As shown above the generated DAO layer can also perform some validations
or even automatically assigns values to empty fields - depending how you configure the source.
And moreover the generated DAO layer can be independent of the underlying database.
For example you do not care about the way how autoincrement fields are fetched from the database
- it is the responsibility of the DAO layer to use autoincrement fields in MySQL,
sequences in Oracle / HSQLDB and automatically generated fields in Google App Engine.
Free Online Generator
We provide you our online generator as a free service.
You do not need to register. If you want to try it, then just try it!
Of course, this online generator service is limited by the size of the source configuration file.
You can increase that limit by signing-in with your Google Account.
Or you can use the standalone version for free now, go to the download