com.github.pagehelper.dialect.helper

Class SqlServerDialect

java.lang.Object

com.github.pagehelper.dialect.AbstractDialect

com.github.pagehelper.dialect.AbstractHelperDialect

com.github.pagehelper.dialect.helper.SqlServerDialect

All Implemented Interfaces:

Constant, Dialect

Direct Known Subclasses:

SqlServer2012Dialect

public class SqlServerDialect
extends AbstractHelperDialect

Author:

liuzh

Field Summary

Fields

Modifier and Type	Field and Description
protected Cache<String,String>	CACHE_COUNTSQL
protected Cache<String,String>	CACHE_PAGESQL
protected SqlServerParser	pageSql
protected ReplaceSql	replaceSql

Fields inherited from class com.github.pagehelper.dialect.AbstractDialect

countSqlParser

Fields inherited from interface com.github.pagehelper.Constant

PAGEPARAMETER_FIRST, PAGEPARAMETER_SECOND, SUFFIX_COUNT, SUFFIX_PAGE

Constructor Summary

Constructors

Constructor and Description
SqlServerDialect()

Method Summary

Modifier and Type	Method and Description
String	getCountSql(org.apache.ibatis.mapping.MappedStatement ms, org.apache.ibatis.mapping.BoundSql boundSql, Object parameterObject, org.apache.ibatis.session.RowBounds rowBounds, org.apache.ibatis.cache.CacheKey countKey) 生成 count 查询 sql
String	getPageSql(String sql, Page page, org.apache.ibatis.cache.CacheKey pageKey) 单独处理分页部分
Object	processPageParameter(org.apache.ibatis.mapping.MappedStatement ms, Map<String,Object> paramMap, Page page, org.apache.ibatis.mapping.BoundSql boundSql, org.apache.ibatis.cache.CacheKey pageKey) 处理分页参数
void	setProperties(Properties properties) 设置参数

Methods inherited from class com.github.pagehelper.dialect.AbstractHelperDialect

afterAll, afterCount, afterPage, beforeCount, beforePage, getLocalPage, getPageSql, handleParameter, processParameterObject, skip

Methods inherited from class java.lang.Object

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

Field Detail

pageSql

protected SqlServerParser pageSql

CACHE_COUNTSQL

protected Cache<String,String> CACHE_COUNTSQL

CACHE_PAGESQL

protected Cache<String,String> CACHE_PAGESQL

replaceSql

protected ReplaceSql replaceSql

Constructor Detail

SqlServerDialect

public SqlServerDialect()

Method Detail

getCountSql

public String getCountSql(org.apache.ibatis.mapping.MappedStatement ms,
                          org.apache.ibatis.mapping.BoundSql boundSql,
                          Object parameterObject,
                          org.apache.ibatis.session.RowBounds rowBounds,
                          org.apache.ibatis.cache.CacheKey countKey)

Description copied from interface: Dialect

生成 count 查询 sql

Specified by:

getCountSql in interface Dialect

Overrides:

getCountSql in class AbstractHelperDialect

Parameters:

ms - MappedStatement

boundSql - 绑定 SQL 对象

parameterObject - 方法参数

rowBounds - 分页参数

countKey - count 缓存 key

Returns:

processPageParameter

public Object processPageParameter(org.apache.ibatis.mapping.MappedStatement ms,
                                   Map<String,Object> paramMap,
                                   Page page,
                                   org.apache.ibatis.mapping.BoundSql boundSql,
                                   org.apache.ibatis.cache.CacheKey pageKey)

Description copied from class: AbstractHelperDialect

处理分页参数

Specified by:

processPageParameter in class AbstractHelperDialect

Returns:

getPageSql

public String getPageSql(String sql,
                         Page page,
                         org.apache.ibatis.cache.CacheKey pageKey)

Description copied from class: AbstractHelperDialect

单独处理分页部分

Specified by:

getPageSql in class AbstractHelperDialect

Returns:

setProperties

public void setProperties(Properties properties)

Description copied from interface: Dialect

设置参数

Specified by:

setProperties in interface Dialect

Overrides:

setProperties in class AbstractHelperDialect

Parameters:

properties - 插件属性