SQL Construction Kit aims to provide a simple builder/factory pattern based approach to generating DML SQL for all popular RDBMS systems. Included builders are SelectBuilder, InsertBuilder, UpdateBuilder, and DeleteBuilder. It is much lighter weight than any of the ORM tools available, and is 100% Java. It is a complete re-factoring of code that has been in production use since 2001 (updated to use features of Java 6). Also included is a Facade patterned Database object that wraps a Datasource object. This provides an execution framework for the results of the Builder objects, which includes simplified transaction and batch management as well as the ability to transparently handle SQL exceptions in a default manner. The Database object also provides a simple object-oriented approach via wrappers around the database metadata.
