Package av.tob.rdb

This package defines standard TheObjectBase.Querier interface for TOBs upon RDBMS family SwapEngines.

See:
Description

Interface Summary

SQLResultList	This interface defines the custom query results list, for buffered processing.
SQLResultProcessor	This interface defines the custom query processor for event driven processing.
TheObjectQ

Class Summary

QueryField	This class is used to define constants to construct SQL WHERE clauses, each reference a single database table column.
SQLQuerier	The standard TheObjectBase.Querier interface by SwapEngines run atop traditional relational databases.
SQLResultArrayList	An ArrayList based SQLResultList implementation used to return custom query results by SQLQuerier.query(long, long, String).

Package av.tob.rdb Description

This package defines standard TheObjectBase.Querier interface for TOBs upon RDBMS family SwapEngines.

This standard interface tries best to value SQL knowledge of the developers, by defining a simular query syntax to SQL. And in close cooperation with the RDBMS family SwapEngines, a query criteria interface will be generaged for each persistent class at compile time, which will contain static QueryField constants for all generated table columns. So programmers will feel easy to write vendor neutral SQL like queries for TOB upon RDBMS family SwapEngines.

And because SQL is just strong in statistic functionalities, compared to Object Oriented DataBase access interface, some raw custom SQL methods are also provided to enable SQL expert programmers benefit max from underlying RDBMS SwapEngine.

For each persistent class compiled by Ableverse, a query criteria interface will be generated. It'll resident in the same package of that persistent class, and have a class name of that class followed by a capital leter 'Q'. It'll define a set of QueryField constants each identifies a db column reference with proper table alias prefixed thus suitable for query clauses on that persistent class. Because QueryField overrides its Object.toString() method to return that column reference, programmers can just combine Strings and these QueryFields with java string concatenations to form the clause parameter in SQLQuerier queries.

Because RDB Connections are TOB managed resources, this querier interface won't expose much JDBC™ details (ResultSet, Statement, Savepoint etc.). Instead, it defines SQLResultList for buffered records processing and SQLResultProcessor for event driven records processing.