Download
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
Features
- Java objects all the time
- Database abstracted and no SQL required
- Aims to handle 99% of your everyday SQL without any SQL
- Supports the other 1% of SQL by supporting views and queries just like tables
- Automatically capture your schema whatever the size, tested on 800+ table/view schema
- Add relational semantics into Java code without altering any code or the database
- Query across multiple tables with as little as one line of code
- Clear, concise query criteria
- Automatically detects missing Primary Keys based on Foreign Keys
- Automatically prevent common errors like blank queries and cartesian joins
- Easily use the DB objects within JSP pages using get/set methods
Project Samples
