org.hdpagination.dataaccess.jdbc.hsqldb
Class HSQLDBJdbcQueryTemplate

java.lang.Object
  org.hdpagination.dataaccess.jdbc.JdbcQueryTemplate
      org.hdpagination.dataaccess.jdbc.hsqldb.HSQLDBJdbcQueryTemplate

All Implemented Interfaces:

QueryTemplate

public class HSQLDBJdbcQueryTemplate
extends JdbcQueryTemplate

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

Since:

1.0

Author:

Liangfeng Ren

Constructor Summary

HSQLDBJdbcQueryTemplate(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

HSQLDBJdbcQueryTemplate

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