org.hdpagination.dataaccess.jdbc
Class AbstractColumnMapJdbcQueryCallback

java.lang.Object
  org.hdpagination.dataaccess.jdbc.AbstractJdbcQueryCallback
      org.hdpagination.dataaccess.jdbc.AbstractColumnMapJdbcQueryCallback

All Implemented Interfaces:

java.io.Serializable, QueryCallback, JdbcQueryCallback

Direct Known Subclasses:

DefaultJdbcQueryCallback

public abstract class AbstractColumnMapJdbcQueryCallback
extends AbstractJdbcQueryCallback

A subclass of AbstractJdbcQueryCallback providing default implementation of processRow(ResultSet rs) method where it creates a java.util.Map for each row, representing all columns as key-value pairs: one entry for each column, with the column name (converted to lower case) as key.

Since:

1.0

Author:

Liangfeng Ren

See Also:

Serialized Form

Constructor Summary

AbstractColumnMapJdbcQueryCallback(java.lang.String queryStmt)

AbstractColumnMapJdbcQueryCallback(java.lang.String queryStmt, java.lang.String orderBy)

AbstractColumnMapJdbcQueryCallback(java.lang.String queryStmt, java.lang.String orderBy, boolean ascending)

Method Summary

java.lang.Object	processRow(java.sql.ResultSet rs) Create a java.util.Map for each row, representing all columns as key-value pairs: one entry for each column, with the column name (converted to lower case) as key.
abstract void	setValues(java.sql.PreparedStatement ps) set values on a PreparedStatement provided by JdbcQueryTemplate

Methods inherited from class org.hdpagination.dataaccess.jdbc.AbstractJdbcQueryCallback

getCountRecordsQueryStatement, getQueryOrder, getQueryStatement, setCountRowsStmt, setQueryOrder

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractColumnMapJdbcQueryCallback

public AbstractColumnMapJdbcQueryCallback(java.lang.String queryStmt)

Parameters:

queryStmt - The SQL statement to query

AbstractColumnMapJdbcQueryCallback

public AbstractColumnMapJdbcQueryCallback(java.lang.String queryStmt,
                                          java.lang.String orderBy)

Parameters:

queryStmt - The SQL to query

orderBy - column that will be added to the 'order by' clause of SQL statement

AbstractColumnMapJdbcQueryCallback

public AbstractColumnMapJdbcQueryCallback(java.lang.String queryStmt,
                                          java.lang.String orderBy,
                                          boolean ascending)

Parameters:

queryStmt - The SQL to query

orderBy - column that will be added to the 'order by' clause of SQL statement

ascending - if sorted by ascending order

Method Detail

processRow

public java.lang.Object processRow(java.sql.ResultSet rs)
                            throws java.sql.SQLException

Create a java.util.Map for each row, representing all columns as key-value pairs: one entry for each column, with the column name (converted to lower case) as key.

Specified by:

processRow in interface JdbcQueryCallback

Specified by:

processRow in class AbstractJdbcQueryCallback

Parameters:

rs -

Returns:

a instance of java.util.Map representing one row of data

Throws:

java.sql.SQLException

setValues

public abstract void setValues(java.sql.PreparedStatement ps)
                        throws java.sql.SQLException

Description copied from interface: JdbcQueryCallback

set values on a PreparedStatement provided by JdbcQueryTemplate

Specified by:

setValues in interface JdbcQueryCallback

Specified by:

setValues in class AbstractJdbcQueryCallback

Throws:

java.sql.SQLException