com.centit.support.database.ddl

Class H2DDLOperations

java.lang.Object

com.centit.support.database.ddl.GeneralDDLOperations

com.centit.support.database.ddl.MySqlDDLOperations

com.centit.support.database.ddl.H2DDLOperations

All Implemented Interfaces:

DDLOperations

public class H2DDLOperations
extends MySqlDDLOperations

使用H2数据库时请打开MySql兼容模式 jdbc:h2: <url>;MODE=<databaseType> MODE=MySQL：兼容模式，H2兼容多种数据库， 该值可以为：DB2、Derby、HSQLDB、MSSQLServer、MySQL、Oracle、PostgreSQL

http://www.h2database.com/html/features.html#compatibility

Field Summary

Fields inherited from class com.centit.support.database.ddl.GeneralDDLOperations

conn

Constructor Summary

Constructors

Constructor and Description
H2DDLOperations()
H2DDLOperations(Connection conn)

Method Summary

Modifier and Type	Method and Description
String	makeCreateSequenceSql(String sequenceName) 创建序列 用表来模拟sequence create table simulate_sequence (seqname varchar(100) not null primary key, currvalue integer, increment integer);

Methods inherited from class com.centit.support.database.ddl.MySqlDDLOperations

appendColumnSQL, appendPkSql, makeModifyColumnSql, makeReconfigurationColumnSqls, makeRenameColumnSql

Methods inherited from class com.centit.support.database.ddl.GeneralDDLOperations

addColumn, appendColumnsSQL, appendColumnTypeSQL, appendPkColumnSql, checkTableWellDefined, checkViewWellDefined, createDDLOperations, createDDLOperations, createSequence, createTable, dropColumn, dropTable, makeAddColumnSql, makeCreateTableSql, makeCreateViewSql, makeDropColumnSql, makeDropTableSql, modifyColumn, parseDDL, reconfigurationColumn, renameColumn, setConnect

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.centit.support.database.ddl.DDLOperations

makeCreateTableSql

Constructor Detail

H2DDLOperations

public H2DDLOperations()

H2DDLOperations

public H2DDLOperations(Connection conn)

Method Detail

makeCreateSequenceSql

public String makeCreateSequenceSql(String sequenceName)

Description copied from class: GeneralDDLOperations

创建序列 用表来模拟sequence create table simulate_sequence (seqname varchar(100) not null primary key, currvalue integer, increment integer);

Specified by:

makeCreateSequenceSql in interface DDLOperations

Overrides:

makeCreateSequenceSql in class GeneralDDLOperations

Parameters:

sequenceName - 序列

Returns:

sql语句