com.finalist.tools.database
Class GenericRowMapper

java.lang.Object
  com.finalist.tools.database.RowMapper
      com.finalist.tools.database.GenericRowMapper

public class GenericRowMapper

extends RowMapper

This RowMapper attempts to break away from the database-dependent row mappers by providing a generic JDBC-to-Java Object mapping.

Author:

Michael O'Connor - Finalist IT Group

Constructor Summary

GenericRowMapper()

Method Summary

java.sql.PreparedStatement	bind(java.sql.PreparedStatement pstmt, java.lang.Object bindVar, java.lang.String bindVarClassType, int pos) Method that binds an object of a specified type into a PreparedStatement and returns the PreparedStatement.
java.lang.Object	unBindIntoBean(java.sql.ResultSet rset, java.lang.Object target) Method that reads the values from a ResultSet an populates the properties of a bean
java.util.HashMap	unBindIntoHashMap(java.sql.ResultSet rset, java.util.HashMap target) Method that reads the values from a ResultSet for one row and stores them into a HashMap.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

GenericRowMapper

public GenericRowMapper()

Method Detail

bind

public java.sql.PreparedStatement bind(java.sql.PreparedStatement pstmt,
                                       java.lang.Object bindVar,
                                       java.lang.String bindVarClassType,
                                       int pos)
                                throws java.sql.SQLException,
                                       NotMappableException

Description copied from class: RowMapper

Method that binds an object of a specified type into a PreparedStatement and returns the PreparedStatement.

Specified by:

bind in class RowMapper

Parameters:

pstmt - PreparedStatement to which the object should be bound.

bindVar - the object that is to be bound.

bindVarClassType - the full classname that identifies the type of the class

pos - the position at which the object should be bound into the statement.

Returns:

PreparedStatement the resulting PreparedStatement after the bind has happened.

Throws:

java.sql.SQLException

NotMappableException - when no appropriate bind method could be found

See Also:

{@link RowMapper#bind}.

unBindIntoHashMap

public java.util.HashMap unBindIntoHashMap(java.sql.ResultSet rset,
                                           java.util.HashMap target)
                                    throws java.sql.SQLException,
                                           NotMappableException

Description copied from class: RowMapper

Method that reads the values from a ResultSet for one row and stores them into a HashMap.

Specified by:

unBindIntoHashMap in class RowMapper

Parameters:

rset - the resultset that serves a source

target - the HashMap in which the values will be stored

Returns:

the resulting HashMap

Throws:

java.sql.SQLException

NotMappableException - when no appropriate unbind method could be found

See Also:

{@link RowMapper#unBindIntoHashMap}.

unBindIntoBean

public java.lang.Object unBindIntoBean(java.sql.ResultSet rset,
                                       java.lang.Object target)
                                throws java.sql.SQLException,
                                       NotMappableException

Description copied from class: RowMapper

Method that reads the values from a ResultSet an populates the properties of a bean

Specified by:

unBindIntoBean in class RowMapper

Parameters:

rset - the resultset that serves a source

target - the bean of which the properties should be set

Returns:

the resulting bean

Throws:

java.sql.SQLException

NotMappableException - when no appropriate unbind method could be found

See Also:

{@link RowMapper#unBindIntoBean}.