org.hdpagination.dataaccess.jdbc
Class DefaultJdbcQueryCallback

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

All Implemented Interfaces:

java.io.Serializable, QueryCallback, JdbcQueryCallback

public class DefaultJdbcQueryCallback
extends AbstractColumnMapJdbcQueryCallback

A default implementing class of JdbcQueryCallback 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.

Empty implementation of setValues(PreparedStatement ps)

Since:

1.0

Author:

Liangfeng Ren

See Also:

Serialized Form

Constructor Summary

DefaultJdbcQueryCallback(java.lang.String queryStmt)

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

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

Method Summary

void	setValues(java.sql.PreparedStatement ps) set values on a PreparedStatement provided by JdbcQueryTemplate

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

processRow

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

DefaultJdbcQueryCallback

public DefaultJdbcQueryCallback(java.lang.String queryStmt)

Parameters:

queryStmt - The SQL statement to query

DefaultJdbcQueryCallback

public DefaultJdbcQueryCallback(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

DefaultJdbcQueryCallback

public DefaultJdbcQueryCallback(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

setValues

public 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 AbstractColumnMapJdbcQueryCallback

Throws:

java.sql.SQLException