Search Results for "table"

Now stored at https://github.com/gregorydgraham/DBvolution Available from Maven Central: nz.co.gregs.dbvolution Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes. Simple declaration of a DB table: @DBTableName("mytable") public class MyTable extends DBRow { @DBColumn("numeric_code") @DBForeignKey(Code.class) private DBNumber numericCode = new DBNumber(); @DBColumn("uid_mytable") @DBPrimaryKey @DBAutoIncrement private DBNumber uidMyTable = new DBNumber(); } Easy Gets: List<MyTable> myRows = myDB.get(new MyTable()); MyTable row = myDB.getDBTable(new MyTable()).getByPrimaryKey(61176904); Natural and Outer Joins and Criteria: CarCo carCo = new CarCo(); carCo.name.isLiterally("GM"); List<DBQueryRow> results = myDB.get(carCo, new Marque()); dbQuery.addOptional(new CarModel()); Easy debugging: query.getSQLForQuery(); Simple processing: db.print(query.getAllRows()); List<Marque> marques = query.getAll

Bridge To Babylon is a java object relational mapper (java ORM). It is intended to be lightweight and easy to use.

Abstracts developers from SQL syntax, with methods that return Strings to pass on to JDBC, thus allowing compile-time checking for, many, otherwise run-time bugs. e.g. stmt.executeQuery(SqlWrapper.selectId(ordersTable, customerColumn, "John Smith")

A utility that helps developers to access SQL databses and convert them to Objects. Each table in the database becomes a RecordStore Object and each Record becomes a Record Object. Multiple queries on same data generates no duplicates.