Trivial Data Access


Single table queries should be trivial
and they are

    DBvolution Overview Advantages Demo Code Quick Ref Connection Data Model Get Data Table Modeling Data Types Quick Queries Big Queries Expressions Create Information Transactions Extra Features Licensing Support us on Patreon

Using DBTable is Quick & Easy

DBtable provides access to advanced features while maintaining the simplicity of the DBDatabase get() method

DBDatabase provides the convenient getDBTable(DBRow) method to quickly create an instance

DBTable<Marque> dbTable = database.getDBTable(marque);

DBTable provides methods to limit the number of rows returned, sort the rows on the database, get pages of rows, allow blank queries, and allow cartesian joins. Basically all the functionality you'd expect from a single table query

dbTable.setRowLimit(30);
dbTable.setSortOrder(marque.name);
dbTable.setBlankQueryAllowed(true);
List<Marque> allMarques = dbTable.getAllRows();
List<Marque> allMarques = dbTable.getRowsForPage(5);

Using a DBTable instance allows you to retrieve all instances of a DBRow quickly. Just call getAllRows() to retrieve a list of each instance. This quickly converts a long query to a small number of distinct objects

When you want DB to be easier and faster...

Get DBvolution from GitHub or Maven

DBvolution is the gateway to your database and high-speed querying
  Contact us now for details
  +64 27 444 5201
Twitter
Support us on Patreon