net.sohelp.boot.engine.db.table.script.interfaces

接口 TableScriptInterface

所有已知实现类:

BaseTableScriptCreator, Mssql2000TableScriptCreator, MysqlTableScriptCreator

public interface TableScriptInterface

表脚本接口

从以下版本开始:

2016/03/16

作者:

AaronFung

方法概要

限定符和类型	方法和说明
String	alterField(PropertyVO propertyVO)
String	createField(PropertyVO propertyVO) 创建字段
String	createPrimaryKey(PropertyVO propertyVO)
String	createTable(EntityVO entityVO)
String	createUnique(EntityVO entityVO)
String	dropField(PropertyVO propertyVO)
String	dropPrimaryKey(String tableName)
String	droptable(String tableName)
String	dropUnique(EntityVO entityVO)
boolean	exist(String tableName)
boolean	exist(String tableName, String fieldName)
List<EntityVO>	getEntities()
EntityVO	getEntity(String tableName) 获取真实数据字段列表
List<String>	getEntityNames()
String	getMappingType(PropertyVO propertyVO)
Map<String,PropertyVO>	getProperties(String tableName)
PropertyVO	getProperty(String tableName, String fieldName) 获取数据字表字段
int	getTableFieldLength(String tableName, String fieldName) 获取数据库字段长度
String	getTableFieldType(String tableName, String fieldName) 获取数据库字段类型
boolean	isEqualsProperty(PropertyVO propertyVO) 判断字段类型、长度是否一致
boolean	isEqualsProperty(PropertyVO xmlProperty, PropertyVO fieldPropertyVO)
boolean	isExistPrimaryKey(String tableName)
String	saveTable(EntityVO entityVO)

方法详细资料

getProperties

Map<String,PropertyVO> getProperties(String tableName)
                              throws SQLException

抛出:

SQLException

getProperty

PropertyVO getProperty(String tableName,
                       String fieldName)
                throws SQLException

获取数据字表字段

参数:

tableName -

fieldName -

返回:

抛出:

SQLException

isEqualsProperty

boolean isEqualsProperty(PropertyVO xmlProperty,
                         PropertyVO fieldPropertyVO)
                  throws SQLException

抛出:

SQLException

exist

boolean exist(String tableName,
              String fieldName)
       throws SQLException

抛出:

SQLException

exist

boolean exist(String tableName)
       throws SQLException

抛出:

SQLException

createTable

String createTable(EntityVO entityVO)
            throws SQLException

抛出:

SQLException

droptable

String droptable(String tableName)

dropField

String dropField(PropertyVO propertyVO)

getMappingType

String getMappingType(PropertyVO propertyVO)
               throws SQLException

抛出:

SQLException

createField

String createField(PropertyVO propertyVO)
            throws SQLException

创建字段

参数:

propertyVO -

返回:

抛出:

SQLException

isExistPrimaryKey

boolean isExistPrimaryKey(String tableName)
                   throws SQLException

抛出:

SQLException

dropPrimaryKey

String dropPrimaryKey(String tableName)

createPrimaryKey

String createPrimaryKey(PropertyVO propertyVO)

getTableFieldType

String getTableFieldType(String tableName,
                         String fieldName)
                  throws SQLException

获取数据库字段类型

参数:

tableName -

fieldName -

返回:

抛出:

SQLException

getTableFieldLength

int getTableFieldLength(String tableName,
                        String fieldName)
                 throws SQLException

获取数据库字段长度

参数:

tableName -

fieldName -

返回:

抛出:

SQLException

getEntity

EntityVO getEntity(String tableName)
            throws SQLException

获取真实数据字段列表

参数:

tableName -

返回:

抛出:

SQLException

getEntities

List<EntityVO> getEntities()
                    throws SQLException

抛出:

SQLException

getEntityNames

List<String> getEntityNames()
                     throws SQLException

抛出:

SQLException

isEqualsProperty

boolean isEqualsProperty(PropertyVO propertyVO)
                  throws SQLException

判断字段类型、长度是否一致

参数:

propertyVO -

返回:

抛出:

SQLException

createUnique

String createUnique(EntityVO entityVO)

dropUnique

String dropUnique(EntityVO entityVO)

alterField

String alterField(PropertyVO propertyVO)
           throws SQLException

抛出:

SQLException

saveTable

String saveTable(EntityVO entityVO)
          throws SQLException

抛出:

SQLException