SQLServer2005Dialect

java.lang.Object
- org.hibernate.dialect.Dialect
- - org.hibernate.dialect.SQLServerDialect
  - - org.hibernate.dialect.CTPSQLServerDialect
    - - org.hibernate.dialect.SQLServer2005Dialect

所有已实现的接口:

CTPDBDialect

直接已知子类:

SQLServer2008Dialect
```
public class SQLServer2005Dialect
extends CTPSQLServerDialect
```
SQLServer 2005 方言实现
主要使用数据库 ROW_NUMBER()分页算法重构原来低效的TOP N算法

数据量越大、分页页码越大对分页效率影响就越大

从以下版本开始:

sqlserver2005+

字段概要

字段
限定符和类型	字段和说明
`protected static java.lang.String`	`DISTINCT`
`protected static java.lang.String`	`FROM`
`protected static org.apache.commons.logging.Log`	`LOGGER`
`protected static java.lang.String`	`ORDER_BY`
`protected static java.util.regex.Pattern`	`ORDER_BY_PATTERN`
`protected static java.lang.String`	`SELECT`

从类继承的字段 org.hibernate.dialect.Dialect
CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

构造器概要

构造器
构造器和说明

SQLServer2005Dialect()

构造器
构造器和说明
`SQLServer2005Dialect()`

方法概要

所有方法静态方法实例方法具体方法
限定符和类型	方法和说明
`java.lang.String`	`applyLocksToSql(java.lang.String arg0, java.util.Map arg1, java.util.Map arg2)`
`boolean`	`bindLimitParametersFirst()`
`int`	`convertToFirstRowValue(int zeroBasedFirstResult)`
`protected static void`	`doWithRowNumber(java.lang.StringBuilder pagingSelect, java.lang.CharSequence orderByClause)` 使用ROW_NUMBER() 函数处理分页查询 ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP)
`boolean`	`dropTemporaryTableAfterUse()`
`protected static int`	`findIndexOfPattern(java.lang.String querySelect, java.util.regex.Pattern pattern, int fromIndex)`
`java.lang.String`	`generateTemporaryTableName(java.lang.String arg0)`
`java.lang.String`	`getAddColumnString()`
`java.lang.String`	`getForUpdateString()`
`java.lang.String`	`getIdentityColumnString()`
`java.lang.String`	`getIdentitySelectString()`
`java.lang.String`	`getLimitString(java.lang.String querySelect, boolean hasOffset)`
`java.lang.String`	`getLimitString(java.lang.String querySelect, int offset, int limit)` 使用ROW_NUMBER()分页算法重写分页机制
`java.lang.String`	`getNullColumnString()`
`java.sql.ResultSet`	`getResultSet(java.sql.CallableStatement arg0)`
`protected static java.lang.CharSequence`	`getSelectColumnsWithoutAliases(java.lang.StringBuilder pagingSelect)` 返回select语句中的列名
`boolean`	`isCurrentTimestampSelectStringCallable()`
`boolean`	`qualifyIndexName()`
`int`	`registerResultSetOutParameter(java.sql.CallableStatement arg0, int arg1)`
`protected static java.lang.String`	`relaceAllColumnsAliases(java.lang.String str)` 去除查询语句中的别名 columnName [[as] alias]
`protected static void`	`replaceDistinctWithGroupBy(java.lang.StringBuilder pagingSelect)` 使用group by 替换distinct子句
`boolean`	`supportsCurrentTimestampSelection()`
`boolean`	`supportsEmptyInList()`
`boolean`	`supportsExistsInSelect()`
`boolean`	`supportsIdentityColumns()`
`boolean`	`supportsInsertSelectIdentity()`
`boolean`	`supportsLimit()`
`boolean`	`supportsLimitOffset()`
`boolean`	`supportsTemporaryTables()`
`boolean`	`supportsVariableLimit()`
`boolean`	`useMaxForLimit()`

从类继承的方法 org.hibernate.dialect.CTPSQLServerDialect
getModifyColumnString, getTextLimit

从类继承的方法 org.hibernate.dialect.SQLServerDialect
appendIdentitySelectToInsert, appendLockHint, areStringComparisonsCaseInsensitive, closeQuote, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, getCurrentTimestampSelectString, getNoColumnsInsertString, getSelectGUIDString, openQuote, supportsCircularCascadeDeleteConstraints, supportsLobValueChangePropogation, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor

从类继承的方法 org.hibernate.dialect.Dialect
bindLimitParametersInReverseOrder, buildSQLExceptionConverter, createCaseFragment, createOuterJoinFragment, dropConstraints, forceLimitUsage, forUpdateOfColumns, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCurrentTimestampSQLFunctionName, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceString, getDropSequenceStrings, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getKeywords, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNativeIdentifierGeneratorClass, getQuerySequencesString, getSelectClauseNullString, getSelectSequenceNextValString, getSequenceNextValString, getTableComment, getTableTypeString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, performTemporaryTableDDLInIsolation, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, requiresCastingOfParametersInSelectClause, supportsBindAsCallableArgument, supportsCascadeDelete, supportsColumnCheck, supportsCommentOn, supportsExpectedLobUsagePattern, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSequences, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- 字段详细资料
  - LOGGER
```
protected static final org.apache.commons.logging.Log LOGGER
```
  - SELECT
```
protected static final java.lang.String SELECT
```
    另请参阅:
    
    常量字段值
  - FROM
```
protected static final java.lang.String FROM
```
    另请参阅:
    
    常量字段值
  - DISTINCT
```
protected static final java.lang.String DISTINCT
```
    另请参阅:
    
    常量字段值
  - ORDER_BY
```
protected static final java.lang.String ORDER_BY
```
    另请参阅:
    
    常量字段值
  - ORDER_BY_PATTERN
```
protected static final java.util.regex.Pattern ORDER_BY_PATTERN
```
- 构造器详细资料
  - SQLServer2005Dialect
```
public SQLServer2005Dialect()
```
- 方法详细资料
  - getLimitString
```
public java.lang.String getLimitString(java.lang.String querySelect,
                                       int offset,
                                       int limit)
```
    使用ROW_NUMBER()分页算法重写分页机制
    
    覆盖:
    
    getLimitString 在类中 org.hibernate.dialect.SQLServerDialect
    
    参数:
    
    querySelect -
    
    offset -
    
    limit -
    
    返回:
  - getLimitString
```
public java.lang.String getLimitString(java.lang.String querySelect,
                                       boolean hasOffset)
```
    覆盖:
    
    getLimitString 在类中 org.hibernate.dialect.Dialect
  - doWithRowNumber
```
protected static void doWithRowNumber(java.lang.StringBuilder pagingSelect,
                                      java.lang.CharSequence orderByClause)
```
    使用ROW_NUMBER() 函数处理分页查询
    ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP)
    
    参数:
    
    pagingSelect -
    
    orderByClause - order by 子句
  - replaceDistinctWithGroupBy
```
protected static void replaceDistinctWithGroupBy(java.lang.StringBuilder pagingSelect)
```
    使用group by 替换distinct子句
    
    参数:
    
    pagingSelect - sql查询语句
  - getSelectColumnsWithoutAliases
```
protected static java.lang.CharSequence getSelectColumnsWithoutAliases(java.lang.StringBuilder pagingSelect)
```
    返回select语句中的列名
    
    参数:
    
    pagingSelect -
    
    返回:
  - relaceAllColumnsAliases
```
protected static java.lang.String relaceAllColumnsAliases(java.lang.String str)
```
    去除查询语句中的别名
    columnName [[as] alias]
    
    参数:
    
    str -
    
    返回:
    
    没有as子句的sql
  - findIndexOfPattern
```
protected static int findIndexOfPattern(java.lang.String querySelect,
                                        java.util.regex.Pattern pattern,
                                        int fromIndex)
```
  - convertToFirstRowValue
```
public int convertToFirstRowValue(int zeroBasedFirstResult)
```
    覆盖:
    
    convertToFirstRowValue 在类中 org.hibernate.dialect.Dialect
  - supportsLimit
```
public boolean supportsLimit()
```
    覆盖:
    
    supportsLimit 在类中 org.hibernate.dialect.SQLServerDialect
  - supportsLimitOffset
```
public boolean supportsLimitOffset()
```
    覆盖:
    
    supportsLimitOffset 在类中 org.hibernate.dialect.SQLServerDialect
  - supportsVariableLimit
```
public boolean supportsVariableLimit()
```
    覆盖:
    
    supportsVariableLimit 在类中 org.hibernate.dialect.SQLServerDialect
  - bindLimitParametersFirst
```
public boolean bindLimitParametersFirst()
```
    覆盖:
    
    bindLimitParametersFirst 在类中 org.hibernate.dialect.Dialect
  - useMaxForLimit
```
public boolean useMaxForLimit()
```
    覆盖:
    
    useMaxForLimit 在类中 org.hibernate.dialect.SQLServerDialect
  - getAddColumnString
```
public java.lang.String getAddColumnString()
```
    覆盖:
    
    getAddColumnString 在类中 org.hibernate.dialect.Dialect
  - getNullColumnString
```
public java.lang.String getNullColumnString()
```
    覆盖:
    
    getNullColumnString 在类中 org.hibernate.dialect.Dialect
  - qualifyIndexName
```
public boolean qualifyIndexName()
```
    覆盖:
    
    qualifyIndexName 在类中 org.hibernate.dialect.Dialect
  - getForUpdateString
```
public java.lang.String getForUpdateString()
```
    覆盖:
    
    getForUpdateString 在类中 org.hibernate.dialect.Dialect
  - supportsIdentityColumns
```
public boolean supportsIdentityColumns()
```
    覆盖:
    
    supportsIdentityColumns 在类中 org.hibernate.dialect.Dialect
  - getIdentitySelectString
```
public java.lang.String getIdentitySelectString()
```
    覆盖:
    
    getIdentitySelectString 在类中 org.hibernate.dialect.Dialect
  - getIdentityColumnString
```
public java.lang.String getIdentityColumnString()
```
    覆盖:
    
    getIdentityColumnString 在类中 org.hibernate.dialect.Dialect
  - supportsInsertSelectIdentity
```
public boolean supportsInsertSelectIdentity()
```
    覆盖:
    
    supportsInsertSelectIdentity 在类中 org.hibernate.dialect.Dialect
  - applyLocksToSql
```
public java.lang.String applyLocksToSql(java.lang.String arg0,
                                        java.util.Map arg1,
                                        java.util.Map arg2)
```
    覆盖:
    
    applyLocksToSql 在类中 org.hibernate.dialect.Dialect
  - registerResultSetOutParameter
```
public int registerResultSetOutParameter(java.sql.CallableStatement arg0,
                                         int arg1)
                                  throws java.sql.SQLException
```
    覆盖:
    
    registerResultSetOutParameter 在类中 org.hibernate.dialect.Dialect
    
    抛出:
    
    java.sql.SQLException
  - getResultSet
```
public java.sql.ResultSet getResultSet(java.sql.CallableStatement arg0)
                                throws java.sql.SQLException
```
    覆盖:
    
    getResultSet 在类中 org.hibernate.dialect.Dialect
    
    抛出:
    
    java.sql.SQLException
  - supportsCurrentTimestampSelection
```
public boolean supportsCurrentTimestampSelection()
```
    覆盖:
    
    supportsCurrentTimestampSelection 在类中 org.hibernate.dialect.Dialect
  - isCurrentTimestampSelectStringCallable
```
public boolean isCurrentTimestampSelectStringCallable()
```
    覆盖:
    
    isCurrentTimestampSelectStringCallable 在类中 org.hibernate.dialect.Dialect
  - supportsTemporaryTables
```
public boolean supportsTemporaryTables()
```
    覆盖:
    
    supportsTemporaryTables 在类中 org.hibernate.dialect.Dialect
  - generateTemporaryTableName
```
public java.lang.String generateTemporaryTableName(java.lang.String arg0)
```
    覆盖:
    
    generateTemporaryTableName 在类中 org.hibernate.dialect.Dialect
  - dropTemporaryTableAfterUse
```
public boolean dropTemporaryTableAfterUse()
```
    覆盖:
    
    dropTemporaryTableAfterUse 在类中 org.hibernate.dialect.Dialect
  - supportsEmptyInList
```
public boolean supportsEmptyInList()
```
    覆盖:
    
    supportsEmptyInList 在类中 org.hibernate.dialect.Dialect
  - supportsExistsInSelect
```
public boolean supportsExistsInSelect()
```
    覆盖:
    
    supportsExistsInSelect 在类中 org.hibernate.dialect.Dialect

类 SQLServer2005Dialect

字段概要

从类继承的字段 org.hibernate.dialect.Dialect

构造器概要

方法概要

从类继承的方法 org.hibernate.dialect.CTPSQLServerDialect

从类继承的方法 org.hibernate.dialect.SQLServerDialect

从类继承的方法 org.hibernate.dialect.Dialect

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

字段详细资料

LOGGER

SELECT

FROM

DISTINCT

ORDER_BY

ORDER_BY_PATTERN

构造器详细资料

SQLServer2005Dialect

方法详细资料

getLimitString

getLimitString

doWithRowNumber

replaceDistinctWithGroupBy

getSelectColumnsWithoutAliases

relaceAllColumnsAliases

findIndexOfPattern

convertToFirstRowValue

supportsLimit

supportsLimitOffset

supportsVariableLimit

bindLimitParametersFirst

useMaxForLimit

getAddColumnString

getNullColumnString

qualifyIndexName

getForUpdateString

supportsIdentityColumns

getIdentitySelectString

getIdentityColumnString

supportsInsertSelectIdentity

applyLocksToSql

registerResultSetOutParameter

getResultSet

supportsCurrentTimestampSelection

isCurrentTimestampSelectStringCallable

supportsTemporaryTables

generateTemporaryTableName

dropTemporaryTableAfterUse

supportsEmptyInList

supportsExistsInSelect