com.centit.support.database.ddl

Class GeneralDDLOperations

java.lang.Object

com.centit.support.database.ddl.GeneralDDLOperations

All Implemented Interfaces:

DDLOperations

Direct Known Subclasses:

DB2DDLOperations, MySqlDDLOperations, OracleDDLOperations, PostgreSqlDDLOperations, SqlSvrDDLOperations

public abstract class GeneralDDLOperations
extends Object
implements DDLOperations

Field Summary

Fields

Modifier and Type	Field and Description
protected Connection	conn

Constructor Summary

Constructors

Constructor and Description
GeneralDDLOperations()
GeneralDDLOperations(Connection conn)

Method Summary

Modifier and Type	Method and Description
void	addColumn(String tableCode, TableField column) 添加列
protected void	appendColumnSQL(TableField field, StringBuilder sbCreate)
protected void	appendColumnsSQL(TableInfo tableInfo, StringBuilder sbCreate, boolean fieldStartNewLine)
protected void	appendColumnTypeSQL(TableField field, StringBuilder sbCreate)
protected void	appendPkColumnSql(TableInfo tableInfo, StringBuilder sbCreate)
protected void	appendPkSql(TableInfo tableInfo, StringBuilder sbCreate)
static org.apache.commons.lang3.tuple.Pair<Integer,String>	checkTableWellDefined(TableInfo tableInfo) 返回格式检查结果
static org.apache.commons.lang3.tuple.Pair<Integer,String>	checkViewWellDefined(TableInfo tableInfo)
static GeneralDDLOperations	createDDLOperations(Connection conn)
static GeneralDDLOperations	createDDLOperations(DBType dbtype)
void	createSequence(String sequenceName) 创建sequence
void	createTable(TableInfo tableInfo) 创建表
void	dropColumn(String tableCode, String columnCode) 删除列
void	dropTable(String tableCode) 删除表
String	makeAddColumnSql(String tableCode, TableField column) 添加列
String	makeCreateSequenceSql(String sequenceName) 创建序列 用表来模拟sequence create table simulate_sequence (seqname varchar(100) not null primary key, currvalue integer, increment integer);
String	makeCreateTableSql(TableInfo tableInfo, boolean fieldStartNewLine) 创建表
String	makeCreateViewSql(String selectSql, String viewName) 创建视图
String	makeDropColumnSql(String tableCode, String columnCode) 删除列
String	makeDropTableSql(String tableCode) 删除表
List<String>	makeReconfigurationColumnSqls(String tableCode, String columnCode, TableField column) 重构列，涉及到内容格式的转换，需要新建一个列，将旧列中的数据转换到新列中，然后在删除旧列
String	makeRenameColumnSql(String tableCode, String columnCode, TableField column) 重命名列
void	modifyColumn(String tableCode, TableField oldColumn, TableField column) 修改列定义 ，比如 修改 varchar 的长度
static SimpleTableInfo	parseDDL(String createSql)
void	reconfigurationColumn(String tableCode, String columnCode, TableField column) 重构列，涉及到内容格式的转换，需要新建一个列，将旧列中的数据转换到新列中，然后在删除旧列
void	renameColumn(String tableCode, String columnCode, TableField column) 重命名列
void	setConnect(Connection conn)

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, makeModifyColumnSql

Field Detail

conn

protected Connection conn

Constructor Detail

GeneralDDLOperations

public GeneralDDLOperations()

GeneralDDLOperations

public GeneralDDLOperations(Connection conn)

Method Detail

createDDLOperations

public static GeneralDDLOperations createDDLOperations(DBType dbtype)

createDDLOperations

public static GeneralDDLOperations createDDLOperations(Connection conn)
                                                throws SQLException

Throws:

SQLException

checkTableWellDefined

public static final org.apache.commons.lang3.tuple.Pair<Integer,String> checkTableWellDefined(TableInfo tableInfo)

返回格式检查结果

Parameters:

tableInfo - 表

Returns:

Pair

checkViewWellDefined

public static final org.apache.commons.lang3.tuple.Pair<Integer,String> checkViewWellDefined(TableInfo tableInfo)

parseDDL

public static final SimpleTableInfo parseDDL(String createSql)

setConnect

public void setConnect(Connection conn)

makeCreateSequenceSql

public String makeCreateSequenceSql(String sequenceName)

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

Specified by:

makeCreateSequenceSql in interface DDLOperations

Parameters:

sequenceName - 序列

Returns:

sql语句

makeCreateTableSql

public String makeCreateTableSql(TableInfo tableInfo,
                                 boolean fieldStartNewLine)

Description copied from interface: DDLOperations

创建表

Specified by:

makeCreateTableSql in interface DDLOperations

Parameters:

tableInfo - 表

fieldStartNewLine - 是否每个字段单独一行

Returns:

sql语句

appendPkSql

protected void appendPkSql(TableInfo tableInfo,
                           StringBuilder sbCreate)

appendPkColumnSql

protected void appendPkColumnSql(TableInfo tableInfo,
                                 StringBuilder sbCreate)

appendColumnsSQL

protected void appendColumnsSQL(TableInfo tableInfo,
                                StringBuilder sbCreate,
                                boolean fieldStartNewLine)

appendColumnTypeSQL

protected void appendColumnTypeSQL(TableField field,
                                   StringBuilder sbCreate)

appendColumnSQL

protected void appendColumnSQL(TableField field,
                               StringBuilder sbCreate)

makeDropTableSql

public String makeDropTableSql(String tableCode)

Description copied from interface: DDLOperations

删除表

Specified by:

makeDropTableSql in interface DDLOperations

Parameters:

tableCode - 表

Returns:

sql语句

makeAddColumnSql

public String makeAddColumnSql(String tableCode,
                               TableField column)

Description copied from interface: DDLOperations

添加列

Specified by:

makeAddColumnSql in interface DDLOperations

Parameters:

tableCode - 表

column - 字段

Returns:

sql语句

makeDropColumnSql

public String makeDropColumnSql(String tableCode,
                                String columnCode)

Description copied from interface: DDLOperations

删除列

Specified by:

makeDropColumnSql in interface DDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

Returns:

sql语句

makeRenameColumnSql

public String makeRenameColumnSql(String tableCode,
                                  String columnCode,
                                  TableField column)

Description copied from interface: DDLOperations

重命名列

Specified by:

makeRenameColumnSql in interface DDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

column - 字段

Returns:

sql语句

makeReconfigurationColumnSqls

public List<String> makeReconfigurationColumnSqls(String tableCode,
                                                  String columnCode,
                                                  TableField column)

Description copied from interface: DDLOperations

重构列，涉及到内容格式的转换，需要新建一个列，将旧列中的数据转换到新列中，然后在删除旧列

Specified by:

makeReconfigurationColumnSqls in interface DDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

column - 字段

Returns:

sql语句列表

createSequence

public void createSequence(String sequenceName)
                    throws SQLException

Description copied from interface: DDLOperations

创建sequence

Specified by:

createSequence in interface DDLOperations

Parameters:

sequenceName - sequenceName

Throws:

SQLException - SQLException

createTable

public void createTable(TableInfo tableInfo)
                 throws SQLException

Description copied from interface: DDLOperations

创建表

Specified by:

createTable in interface DDLOperations

Parameters:

tableInfo - 表

Throws:

SQLException - SQLException

dropTable

public void dropTable(String tableCode)
               throws SQLException

Description copied from interface: DDLOperations

删除表

Specified by:

dropTable in interface DDLOperations

Parameters:

tableCode - 表代码

Throws:

SQLException - SQLException

addColumn

public void addColumn(String tableCode,
                      TableField column)
               throws SQLException

Description copied from interface: DDLOperations

添加列

Specified by:

addColumn in interface DDLOperations

Parameters:

tableCode - 表代码

column - 字段

Throws:

SQLException - SQLException

modifyColumn

public void modifyColumn(String tableCode,
                         TableField oldColumn,
                         TableField column)
                  throws SQLException

Description copied from interface: DDLOperations

修改列定义 ，比如 修改 varchar 的长度

Specified by:

modifyColumn in interface DDLOperations

Parameters:

tableCode - 表代码

oldColumn - 老的字段

column - 字段

Throws:

SQLException - SQLException

dropColumn

public void dropColumn(String tableCode,
                       String columnCode)
                throws SQLException

Description copied from interface: DDLOperations

删除列

Specified by:

dropColumn in interface DDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

Throws:

SQLException - SQLException

renameColumn

public void renameColumn(String tableCode,
                         String columnCode,
                         TableField column)
                  throws SQLException

Description copied from interface: DDLOperations

重命名列

Specified by:

renameColumn in interface DDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

column - 字段

Throws:

SQLException - SQLException

reconfigurationColumn

public void reconfigurationColumn(String tableCode,
                                  String columnCode,
                                  TableField column)
                           throws SQLException

Description copied from interface: DDLOperations

重构列，涉及到内容格式的转换，需要新建一个列，将旧列中的数据转换到新列中，然后在删除旧列

Specified by:

reconfigurationColumn in interface DDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

column - 字段

Throws:

SQLException - SQLException

makeCreateViewSql

public String makeCreateViewSql(String selectSql,
                                String viewName)

Description copied from interface: DDLOperations

创建视图

Specified by:

makeCreateViewSql in interface DDLOperations

Parameters:

selectSql - select语句

viewName - 视图名称

Returns:

创建视图语句