org.hdpagination.dataaccess.jdbc
Class StandardJdbcQueryTemplate

java.lang.Object
  org.hdpagination.dataaccess.jdbc.JdbcQueryTemplate
      org.hdpagination.dataaccess.jdbc.StandardJdbcQueryTemplate

All Implemented Interfaces:

QueryTemplate

Direct Known Subclasses:

SQLServer2005JdbcQueryTemplate

public class StandardJdbcQueryTemplate
extends JdbcQueryTemplate

The type of JdbcQueryTemplate to run a pagination based query against database which supports standard syntax (ROW_NUMBER() OVER ) for pagination

Since:

1.0

Author:

Liangfeng Ren

Constructor Summary

StandardJdbcQueryTemplate(javax.sql.DataSource dataSource)

Method Summary

protected java.lang.String	convertCountSql(java.lang.String querySql) Translate original query sql to the sql which can be used to query the count of total records.
protected java.lang.String	convertPaginationSql(java.lang.String sql, int pageNo, int pageSize) Translate original query sql to pagination based sql

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

countRows, query

Methods inherited from class java.lang.Object

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

Constructor Detail

StandardJdbcQueryTemplate

public StandardJdbcQueryTemplate(javax.sql.DataSource dataSource)

Method Detail

convertPaginationSql

protected java.lang.String convertPaginationSql(java.lang.String sql,
                                                int pageNo,
                                                int pageSize)

Description copied from class: JdbcQueryTemplate

Translate original query sql to pagination based sql

Specified by:

convertPaginationSql in class JdbcQueryTemplate

Parameters:

sql - original sql

pageNo - current page number (start from 0)

pageSize - how many records is displayed in one page

Returns:

return pagination based sql

convertCountSql

protected java.lang.String convertCountSql(java.lang.String querySql)

Description copied from class: JdbcQueryTemplate

Translate original query sql to the sql which can be used to query the count of total records. If this default translation does not work in one particular database, its corresponding subclass of JdbcQueryTemplate should override this method.

Overrides:

convertCountSql in class JdbcQueryTemplate

Parameters:

querySql - original sql

Returns:

return sql to query the count of total records.