org.velocityweb.jdbc.dialect
Class PostgreSQLPageDialect

java.lang.Object
  org.velocityweb.jdbc.dialect.StandardPageDialect
      org.velocityweb.jdbc.dialect.PostgreSQLPageDialect

All Implemented Interfaces:

PageDialect

public class PostgreSQLPageDialect

extends StandardPageDialect

PostgreSQL page dialect

Author:

Jacklondon Chen

Constructor Summary

PostgreSQLPageDialect()

Method Summary

int[]	getPageParemeterValuesWithPageInfo(int pageIndex, int pageSize) get parementer values if the page SQL is using ? before by calling public String getPageSql(String sql, String orderBy)
protected java.lang.String	getPageSqlImpl(java.lang.String sql, java.lang.String orderBy, java.lang.Long pageIndex, java.lang.Long pageSize) generate page SQL by non-page SQL

Methods inherited from class org.velocityweb.jdbc.dialect.StandardPageDialect

getCountSql, getPageSqlWithoutPageInfo, getPageSqlWithPageInfo, mergePageParemeterValues, supportSubqueryNaming, validatePageSqlParameters

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLPageDialect

public PostgreSQLPageDialect()

Method Detail

getPageSqlImpl

protected java.lang.String getPageSqlImpl(java.lang.String sql,
                                          java.lang.String orderBy,
                                          java.lang.Long pageIndex,
                                          java.lang.Long pageSize)

generate page SQL by non-page SQL

Overrides:

getPageSqlImpl in class StandardPageDialect

Parameters:

sql -

pageIndex - page index, begin from 0, if this parameter is null, the result SQL will place a '?'

pageSize - page size, bigger than 0, if this parameter is null, the result SQL will place a '?'

Returns:

getPageParemeterValuesWithPageInfo

public int[] getPageParemeterValuesWithPageInfo(int pageIndex,
                                                int pageSize)

get parementer values if the page SQL is using ? before by calling public String getPageSql(String sql, String orderBy)

Specified by:

getPageParemeterValuesWithPageInfo in interface PageDialect

Overrides:

getPageParemeterValuesWithPageInfo in class StandardPageDialect

Parameters:

pageIndex -

pageSize -

Returns:

int array contains 2 items.