org.hdpagination.dataaccess.jdbc.db2
Class DB2JdbcQueryTemplate

java.lang.Object
  org.hdpagination.dataaccess.jdbc.JdbcQueryTemplate
      org.hdpagination.dataaccess.jdbc.db2.DB2JdbcQueryTemplate

All Implemented Interfaces:

QueryTemplate

public class DB2JdbcQueryTemplate
extends JdbcQueryTemplate

The type of JdbcQueryTemplate to run a pagination based query against DB2

Since:

1.0

Author:

Liangfeng Ren

Constructor Summary

DB2JdbcQueryTemplate(javax.sql.DataSource dataSource)

Method Summary

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

convertCountSql, countRows, query

Methods inherited from class java.lang.Object

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

Constructor Detail

DB2JdbcQueryTemplate

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