org.velocityweb.jdbc.dialect
Interface PageDialect

All Known Implementing Classes:

StandardPageDialect

public interface PageDialect

Represents a dialect of SQL implemented by a particular RDBMS. Subclasses implement this compatibility with different systems.

Author:

Jacklondon Chen

Method Summary

java.lang.String	getCountSql(java.lang.String sql) generate count SQL, like select count(*) from xxx.
int[]	getPageParemeterValuesWithPageInfo(int pageIndex, int pageSize) get paremeter values if the page SQL is using '?' before by calling public String getPageSql(String sql, String orderBy)
java.lang.String	getPageSqlWithoutPageInfo(java.lang.String sql, java.lang.String orderBy) generate page SQL by non-page SQL
java.lang.String	getPageSqlWithPageInfo(java.lang.String sql, java.lang.String orderBy, int pageIndex, int pageSize) generate page SQL by non-page SQL
java.util.List	mergePageParemeterValues(java.util.List originalParemeterList, int[] pageParemeterValues) merge page paremeter values, some normally add after orignal paramters

Method Detail

getPageSqlWithoutPageInfo

public java.lang.String getPageSqlWithoutPageInfo(java.lang.String sql,
                                                  java.lang.String orderBy)

generate page SQL by non-page SQL

Parameters:

sql -

Returns:

the paging SQL, with '?' stands for pageIndex and pageSize

getPageSqlWithPageInfo

public java.lang.String getPageSqlWithPageInfo(java.lang.String sql,
                                               java.lang.String orderBy,
                                               int pageIndex,
                                               int pageSize)

generate page SQL by non-page SQL

Parameters:

sql -

orderBy - cannot be missing, "order by" fields should exists in "select" fields

pageIndex - page index, begin from 0

pageSize - page size, bigger than 0

Returns:

the paging SQL, with pageIndex and pageSize

getPageParemeterValuesWithPageInfo

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

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

Parameters:

pageIndex -

pageSize -

Returns:

int array contains 2 items.

getCountSql

public java.lang.String getCountSql(java.lang.String sql)

generate count SQL, like select count(*) from xxx.

Parameters:

sql -

Returns:

count SQL

mergePageParemeterValues

public java.util.List mergePageParemeterValues(java.util.List originalParemeterList,
                                               int[] pageParemeterValues)

merge page paremeter values, some normally add after orignal paramters

Parameters:

pageParemeterValues -

Returns:

the paremeter list for query current page data