org.hdpagination.dataaccess.jdbc.sybase
Class SQLAnywhereJdbcQueryTemplate

java.lang.Object
  org.hdpagination.dataaccess.jdbc.JdbcQueryTemplate
      org.hdpagination.dataaccess.jdbc.sybase.SQLAnywhereJdbcQueryTemplate

All Implemented Interfaces:

QueryTemplate

public class SQLAnywhereJdbcQueryTemplate
extends JdbcQueryTemplate

The type of JdbcQueryTemplate to run a pagination based query against Sybase SQL Anywhere

Since:

1.0.1

Author:

Liangfeng Ren

Constructor Summary

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

SQLAnywhereJdbcQueryTemplate

public SQLAnywhereJdbcQueryTemplate(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.