org.velocityweb.jdbc.dialect
Class MySQLPageDialect

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

All Implemented Interfaces:

PageDialect

public class MySQLPageDialect

extends StandardPageDialect

MySQL page dialect

Author:

Jacklondon Chen

Constructor Summary

MySQLPageDialect()

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

MySQLPageDialect

public MySQLPageDialect()

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.