com.jn.sqlhelper.dialect.internal

类 SQLServerDialect

java.lang.Object

com.jn.sqlhelper.dialect.internal.AbstractDialect

com.jn.sqlhelper.dialect.internal.AbstractTransactSQLDialect

com.jn.sqlhelper.dialect.internal.SQLServerDialect

所有已实现的接口:

com.jn.langx.escape.Escaper, Dialect, LikeEscaper

public class SQLServerDialect
extends AbstractTransactSQLDialect

SQLServer 版本说明

     version      |   Year    |       Release Name
     1.0              1989            SQL Server 1.0 (16-bit)
     1.1              1991            SQL Server 1.1 (16-bit)
     4.2A             1992            SQL Server 4.2A (16-bit)
     4.2B             1993            SQL Server 4.2B (16-bit)
     4.21a            1993            SQL Server 4.21a
     6.0              1995            SQL Server 6.0
     6.5              1996            SQL Server 6.5
     7.0              1998            SQL Server 7.0
     8.0              2000            SQL Server 2000
     8.0              2003            SQL Server 2000 64-bit
     9.0              2005            SQL Server 2005
     10.0             2008            SQL Server 2008
     10.25            2010            Azure SQL database
     10.50            2010            SQL Server 2008 R2
     11.0             2012            SQL Server 2012
     12.0             2014            SQL Server 2014
     13.0             2016            SQL Server 2016
     14.0             2017            SQL Server 2017
 

嵌套类概要

嵌套类

限定符和类型	类和说明
static class	SQLServerDialect.SQLServer2000Dialect
static class	SQLServerDialect.SQLServer2005Dialect
static class	SQLServerDialect.SQLServer2008Dialect
static class	SQLServerDialect.SQLServer2012Dialect
static class	SQLServerDialect.SQLServer2014Dialect
static class	SQLServerDialect.SQLServer2016Dialect
static class	SQLServerDialect.SQLServer2017Dialect

构造器概要

构造器

构造器和说明
SQLServerDialect()

方法概要

限定符和类型	方法和说明
char	getAfterQuote() Get quote for symbol (e.g. table name, field name)
char	getBeforeQuote() Get quote for symbol (e.g. table name, field name)
static String	guessDatabaseId(String productionVersion)
boolean	isBindLimitParametersFirst() limit parameter will be bind in the first or not, if first ,the Dialect.bindLimitParametersAtStartOfQuery(RowSelection, PreparedStatement, int) will be execute else the Dialect.bindLimitParametersAtEndOfQuery(RowSelection, PreparedStatement, int) will be execute

从类继承的方法 com.jn.sqlhelper.dialect.internal.AbstractTransactSQLDialect

registerResultSetOutParameter

从类继承的方法 com.jn.sqlhelper.dialect.internal.AbstractDialect

appendmentAfterLikeClause, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, createTableGenerator, escape, generateTableDDL, getDatabaseId, getDefaultProperties, getLikeKeyChars, getLimitHandler, getLimitSql, getQuotedIdentifier, getRealDialect, getUrlParser, isBindLimitParametersInReverseOrder, isForceLimitUsage, isSupportsBatchSql, isSupportsBatchUpdates, isSupportsDistinct, isSupportsLimit, isSupportsLimitOffset, isSupportsVariableLimit, isUseLimitInVariableMode, isUseMaxForLimit, setDelegate, setLikeEscaper, setLimitHandler, setMaxRows, setUrlParser, setUseLimitInVariableMode, toString

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

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

构造器详细资料

SQLServerDialect

public SQLServerDialect()

方法详细资料

guessDatabaseId

public static String guessDatabaseId(String productionVersion)

参数:

productionVersion - databaseMeta.getProductionVersion

返回:

isBindLimitParametersFirst

public boolean isBindLimitParametersFirst()

从接口复制的说明: Dialect

limit parameter will be bind in the first or not, if first ,the Dialect.bindLimitParametersAtStartOfQuery(RowSelection, PreparedStatement, int) will be execute else the Dialect.bindLimitParametersAtEndOfQuery(RowSelection, PreparedStatement, int) will be execute

指定者:

isBindLimitParametersFirst 在接口中 Dialect

覆盖:

isBindLimitParametersFirst 在类中 AbstractDialect

getBeforeQuote

public char getBeforeQuote()

从接口复制的说明: Dialect

Get quote for symbol (e.g. table name, field name)

指定者:

getBeforeQuote 在接口中 Dialect

覆盖:

getBeforeQuote 在类中 AbstractDialect

返回:

the quote

getAfterQuote

public char getAfterQuote()

从接口复制的说明: Dialect

Get quote for symbol (e.g. table name, field name)

指定者:

getAfterQuote 在接口中 Dialect

覆盖:

getAfterQuote 在类中 AbstractDialect

返回:

the quote