sf.database.dialect.sqlserver

Class SqlServerDialect

java.lang.Object

sf.database.dialect.DBDialect

sf.database.dialect.sqlserver.SqlServerDialect

All Implemented Interfaces:

IDBDialect

Direct Known Subclasses:

SQLServer2005Dialect

public class SqlServerDialect
extends DBDialect

Field Summary

Fields inherited from class sf.database.dialect.DBDialect

caseHandler, features, keywords, quoteChar

Constructor Summary

Constructors

Constructor and Description
SqlServerDialect()

Method Summary

Modifier and Type	Method and Description
void	addComment(Connection con, TableMapping en)
boolean	createEntity(Connection conn, TableMapping en) 根据实体信息，返回某实体的建表语句
boolean	dropEntity(Connection conn, TableMapping en)
String	evalFieldType(ColumnMapping mf)
String	getDefaultSchema() 不同数据库登录后，所在的默认schema是不一样的 Oracle是以登录的用户名作为schema的。 mysql是只有catlog不区分schema的。 derby支持匿名访问，此时好像是位于APP这个schema下。 SQL Server默认是在dbo这个schema下 因此对于无法确定当前schema的场合，使用这里提供的schema名称作为当前schema
String	getHibernateDialect() 返回对应的 Hibernate 的 Dialect
String	getJooqDialect()
String	getName()
String	getQueryDslDialect()
List<SequenceInfo>	getSequenceInfo(Connection conn, String schema, String seqName)
String	getSqlStatmentSeparator() 批量运行多个SQL语句之间的分隔符。
String	sqlColumnAdd(String table, String column_definition, String column_position)
String	sqlColumnDrop(String table, String column)
String	sqlColumnModify(String table, String column_definition, String column_position)
String	sqlPageList(String sql, long offset, int limit) 生成分页sql
String	sqlTableDrop(String table)
String	sqlTableRename(String oldName, String newName)
String	uniqueSql(String tableName, String name, String[] columnNames) 生成unique 语句.
protected String	unwrapper(String name) 去除包含的符号和getQuotedIdentifier相反

Methods inherited from class sf.database.dialect.DBDialect

accept, containKeyword, createAddColumnSql, createIndexSql, createRelation, createRelation, createResultSetMetaSql, createUniqueSql, dropRelation, escapeSqlValue, execute, execute, existsTables, getCatalog, getColumnAutoIncreamentValue, getColumnDefinition, getColumnLength, getColumnNameToUse, getColumnPrecision, getColumnScale, getDriverClass, getIndexNames, getNvlFunction, getObjectNameToUse, getPrimaryKeySql, getProperty, getProperty, getPropertyInt, getPropertyLong, getQuoteChar, getSchema, getSeqNextValSql, gSQL, has, isCaseSensitive, notHas, setProperty, setupEntityField, supportsColumnPosition, wrapKeyword, wrapKeyword

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlServerDialect

public SqlServerDialect()

Method Detail

getName

public String getName()

Specified by:

getName in interface IDBDialect

Specified by:

getName in class DBDialect

Returns:

当前数据库类型，名称参见 DB 这个枚举类型

See Also:

RDBMS

unwrapper

protected String unwrapper(String name)

Description copied from class: DBDialect

去除包含的符号和getQuotedIdentifier相反

Overrides:

unwrapper in class DBDialect

Returns:

getDefaultSchema

public String getDefaultSchema()

Description copied from interface: IDBDialect

不同数据库登录后，所在的默认schema是不一样的

• Oracle是以登录的用户名作为schema的。
• mysql是只有catlog不区分schema的。
• derby支持匿名访问，此时好像是位于APP这个schema下。
• SQL Server默认是在dbo这个schema下

因此对于无法确定当前schema的场合，使用这里提供的schema名称作为当前schema

Specified by:

getDefaultSchema in interface IDBDialect

Overrides:

getDefaultSchema in class DBDialect

Returns:

当前RDBMS的缺省Schema

getSqlStatmentSeparator

public String getSqlStatmentSeparator()

Description copied from class: DBDialect

批量运行多个SQL语句之间的分隔符。

Overrides:

getSqlStatmentSeparator in class DBDialect

sqlTableDrop

public String sqlTableDrop(String table)

Specified by:

sqlTableDrop in class DBDialect

sqlTableRename

public String sqlTableRename(String oldName,
                             String newName)

Specified by:

sqlTableRename in class DBDialect

sqlColumnAdd

public String sqlColumnAdd(String table,
                           String column_definition,
                           String column_position)

Specified by:

sqlColumnAdd in class DBDialect

sqlColumnModify

public String sqlColumnModify(String table,
                              String column_definition,
                              String column_position)

Specified by:

sqlColumnModify in class DBDialect

sqlColumnDrop

public String sqlColumnDrop(String table,
                            String column)

Specified by:

sqlColumnDrop in class DBDialect

sqlPageList

public String sqlPageList(String sql,
                          long offset,
                          int limit)

Description copied from class: DBDialect

生成分页sql

Overrides:

sqlPageList in class DBDialect

Parameters:

sql - 原始sql

offset - 开始位置，从0开始 （= (Page-1)*PageSize）

limit - 返回的限制大小（= 分页大小 PageSize）

Returns:

如果不支持，返回 null

getHibernateDialect

public String getHibernateDialect()

Description copied from class: DBDialect

返回对应的 Hibernate 的 Dialect

Specified by:

getHibernateDialect in class DBDialect

createEntity

public boolean createEntity(Connection conn,
                            TableMapping en)

Description copied from class: DBDialect

根据实体信息，返回某实体的建表语句

Specified by:

createEntity in class DBDialect

en - 实体

Returns:

是否创建成功

evalFieldType

public String evalFieldType(ColumnMapping mf)

Overrides:

evalFieldType in class DBDialect

dropEntity

public boolean dropEntity(Connection conn,
                          TableMapping en)

Overrides:

dropEntity in class DBDialect

addComment

public void addComment(Connection con,
                       TableMapping en)

Overrides:

addComment in class DBDialect

uniqueSql

public String uniqueSql(String tableName,
                        String name,
                        String[] columnNames)

Description copied from class: DBDialect

生成unique 语句.

Specified by:

uniqueSql in class DBDialect

Parameters:

tableName - 表名

name - 名称

columnNames - 表的列名,

Returns:

getSequenceInfo

public List<SequenceInfo> getSequenceInfo(Connection conn,
                                          String schema,
                                          String seqName)

Overrides:

getSequenceInfo in class DBDialect

getQueryDslDialect

public String getQueryDslDialect()

getJooqDialect

public String getJooqDialect()