cn.sexycode.springo.core.data.db.mybatis.dialect

类 SQLServer2005Dialect

java.lang.Object

cn.sexycode.springo.core.data.db.mybatis.Dialect

cn.sexycode.springo.core.data.db.mybatis.dialect.SQLServer2005Dialect

所有已实现的接口:

IDialect

public class SQLServer2005Dialect
extends Dialect

SQLServer2005方言。

构造器概要

构造器

构造器和说明
SQLServer2005Dialect()

方法概要

限定符和类型	方法和说明
String	getCountString(String sql) 截掉最后的order by 子句。
String	getLimitString(String querySqlString, int offset, String offsetPlaceholder, int limit, String limitPlaceholder) Add a LIMIT clause to the given SQL SELECT The LIMIT SQL will look like: WITH query AS (SELECT TOP 100 percent ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as __row_number__, * from table_name) SELECT * FROM query WHERE __row_number__ BETWEEN :offset and :lastRows ORDER BY __row_number__
boolean	supportsLimit() 支持limit
boolean	supportsLimitOffset() 支持limit偏移

从类继承的方法 cn.sexycode.springo.core.data.db.mybatis.Dialect

getLimitString, getSortString

从类继承的方法 java.lang.Object

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

构造器详细资料

SQLServer2005Dialect

public SQLServer2005Dialect()

方法详细资料

supportsLimit

public boolean supportsLimit()

从接口复制的说明: IDialect

支持limit

指定者:

supportsLimit 在接口中 IDialect

覆盖:

supportsLimit 在类中 Dialect

返回:

supportsLimitOffset

public boolean supportsLimitOffset()

从接口复制的说明: IDialect

支持limit偏移

指定者:

supportsLimitOffset 在接口中 IDialect

覆盖:

supportsLimitOffset 在类中 Dialect

返回:

getLimitString

public String getLimitString(String querySqlString,
                             int offset,
                             String offsetPlaceholder,
                             int limit,
                             String limitPlaceholder)

Add a LIMIT clause to the given SQL SELECT

The LIMIT SQL will look like:

WITH query AS (SELECT TOP 100 percent ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as __row_number__, * from table_name) SELECT * FROM query WHERE __row_number__ BETWEEN :offset and :lastRows ORDER BY __row_number__

指定者:

getLimitString 在接口中 IDialect

覆盖:

getLimitString 在类中 Dialect

参数:

querySqlString - The SQL statement to base the limit query off of.

offset - Offset of the first row to be returned by the query (zero-based)

limit - Maximum number of list to be returned by the query

返回:

A new SQL statement with the LIMIT clause applied.

getCountString

public String getCountString(String sql)

截掉最后的order by 子句。 避免错误： sql:除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询

指定者:

getCountString 在接口中 IDialect

覆盖:

getCountString 在类中 Dialect

参数:

sql - SQL语句

返回:

总记录数的sql