com.finalist.tools.database
Class RowMapper

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

Direct Known Subclasses:

DBFRowMapper, GenericRowMapper, MySQLRowMapper, OracleRowMapper, PostgreSQLRowMapper

public abstract class RowMapper

extends java.lang.Object

Abstract class that database specific RowMappers should extend.

Version:

1.0

Author:

P.S.D.Reitsma, Finalist IT Group

Constructor Summary

RowMapper()

Method Summary

abstract 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.
abstract 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
abstract 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

RowMapper

public RowMapper()

Method Detail

bind

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

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

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:

NotMappableException - when no appropriate bind method could be found

java.sql.SQLException

unBindIntoHashMap

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

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

Parameters:

rset - the resultset that serves a source

target - the HashMap in which the values will be stored

Returns:

the resulting HashMap

Throws:

NotMappableException - when no appropriate unbind method could be found

java.sql.SQLException

unBindIntoBean

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

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

Parameters:

rset - the resultset that serves a source

target - the bean of which the properties should be set

Returns:

the resulting bean

Throws:

NotMappableException - when no appropriate unbind method could be found

java.sql.SQLException