SQL Construction Kit Simple builder/factory pattern based approach to generating DML (Data Manipulation Language) SQL for all popular RDBMS systems
Download

SQL Construction Kit Ranking & Summary

SQL Construction Kit Tags

build transaction construct sql builder sql construction sql transaction

SQL Construction Kit Description

Simple builder/factory pattern based approach to generating DML (Data Manipulation Language) SQL for all popular RDBMS systems SQL Construction Kit includes the following builders: SelectBuilder, InsertBuilder, UpdateBuilder, DeleteBuilder. SQL Construction Kit is much lighter weight than any of the ORM tools available, and is 100% Java, no other special configuration language or query language to learn. This code has been in production use since its first incarnation around 2001. Also included is a Facade patterned Database object that wraps a Datasource object. This will provide an execution framework for the results of the Builder objects which includes batch management and simplified transaction 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.There are no DDL (Data Definition Language) builders. This library is aimed at creating runtime dynamic sql easy. The DDL for the different databases is so varied that trying to abstract it out to a single generation framework would be counter productive. There are no plans to address DDL any time in the future. NOTE: SQL Construction Kit is licensed, provided and developed under the terms of the MIT/X Consortium License. What's New in This Release: · Fixing broken DeleteBuilder that didn't override the toString() method correctly

SQL Construction Kit Related Software