Package com.interface21.jdbc.object

The classes in this package represent RDBMS queries, updates, and stored procedures as threadsafe, reusable objects.

See:
Description

Interface Summary

StoredProcedure.ParameterMapper

Implement this interface when parameters need to be customized based on the connection.

Class Summary

MappingSqlQuery	Reusable query in which concrete subclasses must implement the abstract mapRow(ResultSet, int) method to convert each row of the JDBC ResultSet into an object.
MappingSqlQueryWithParameters	Reusable RDBMS query in which concrete subclasses must implement the abstract mapRow(ResultSet, int) method to map each row of the JDBC ResultSet into an object.
RdbmsOperation	Root of the JDBC object hierarchy, as described in Chapter 9 of Expert One-On-One J2EE Design and Development by Rod Johnson (Wrox, 2002).
ReflectionExtractionSqlQuery	Reusable threadsafe query in which reflection is used to extract each result row.
ReflectionRowExtractor	DEMONSTRATION OF THIS APPROACH ONLY: NOT FULLY IMPLEMENTED, DOCUMENTED OR TESTED.
SqlFunction	SQL function wrapper that returns a single row of results.
SqlOperation	RdbmsOperation using a JdbcTemplate and representing a SQL-based operation such as a query or update, as opposed to a stored procedure.
SqlQuery	Reusable threadsafe object to represent a SQL query.
SqlUpdate	RdbmsOperation subclass representing a SQL update.
StoredProcedure	Superclass for object abstractions of RDBMS stored procedures.
StoredProcedure.OutputParameter	Subclass of SqlParameter to represent an output parameter.

Package com.interface21.jdbc.object Description

The classes in this package represent RDBMS queries, updates, and stored procedures as threadsafe, reusable objects. This approach is modelled by JDO, although of course objects returned by queries are "disconnected" from the database.

This higher level of JDBC abstraction depends on the lower-level abstraction in the com.interface21.jdbc.core package. Exceptions thrown are as in the com.interface21.dao package, meaning that code using this package does not need to implement JDBC or RDBMS-specific error handling.

This package and related packages are discussed in Chapter 9 of Expert One-On-One J2EE Design and Development by Rod Johnson (Wrox, 2002).