org.tinygroup.jdbctemplatedslsession.pageprocess

Class AbstractPageSqlMatchProcess

java.lang.Object

org.tinygroup.jdbctemplatedslsession.pageprocess.AbstractPageSqlMatchProcess

All Implemented Interfaces:

PageSqlMatchProcess

Direct Known Subclasses:

DB2PageSqlMatchProcess, DerbyPageSqlMatchProcess, H2PageSqlMatchProcess, InformixPageSqlMatchProcess, MysqlPageSqlMatchProcess, OraclePageSqlMatchProcess, SqlServerPageSqlMatchProcess, SybasePageSqlMatchProcess

public abstract class AbstractPageSqlMatchProcess
extends Object
implements PageSqlMatchProcess

Author:

renhui

Constructor Summary

Constructors

Constructor and Description
AbstractPageSqlMatchProcess()

Method Summary

Modifier and Type	Method and Description
protected abstract String	dbType()
String	getCountSql(String originSql)
protected abstract String	internalComplexSelectSqlProcess(ComplexSelect complexSelect, int start, int limit)
protected abstract String	internalSqlProcess(Select select, int start, int limit)
boolean	isMatch(String dbType) 判断是否是该数据库类型的分页sql处理器
String	sqlProcess(ComplexSelect complexSelect, int start, int limit) 对查询语句进行分页sql处理，返回具有分页信息的sql语句
String	sqlProcess(Select select, int start, int limit) 对查询语句进行分页sql处理，返回具有分页信息的sql语句

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractPageSqlMatchProcess

public AbstractPageSqlMatchProcess()

Method Detail

isMatch

public boolean isMatch(String dbType)

Description copied from interface: PageSqlMatchProcess

判断是否是该数据库类型的分页sql处理器

Specified by:

isMatch in interface PageSqlMatchProcess

Parameters:

dbType - 数据库类型

Returns:

匹配返回true，否则返回false

sqlProcess

public String sqlProcess(Select select,
                         int start,
                         int limit)

Description copied from interface: PageSqlMatchProcess

对查询语句进行分页sql处理，返回具有分页信息的sql语句

Specified by:

sqlProcess in interface PageSqlMatchProcess

Parameters:

select - 原生sql，未带分页信息的sql语句

start - 分页参数 每页的起始数

limit - 分页参数，每页返回的条数

Returns:

dbType

protected abstract String dbType()

internalSqlProcess

protected abstract String internalSqlProcess(Select select,
                                             int start,
                                             int limit)

getCountSql

public String getCountSql(String originSql)

Specified by:

getCountSql in interface PageSqlMatchProcess

Parameters:

originSql - 原有sql

Returns:

sqlProcess

public String sqlProcess(ComplexSelect complexSelect,
                         int start,
                         int limit)

Description copied from interface: PageSqlMatchProcess

对查询语句进行分页sql处理，返回具有分页信息的sql语句

Specified by:

sqlProcess in interface PageSqlMatchProcess

Parameters:

complexSelect - 原生sql，未带分页信息的sql语句

start - 分页参数 每页的起始数

limit - 分页参数，每页返回的条数

Returns:

internalComplexSelectSqlProcess

protected abstract String internalComplexSelectSqlProcess(ComplexSelect complexSelect,
                                                          int start,
                                                          int limit)