org.tinygroup.database.table

Interface TableSqlProcessor

All Known Implementing Classes:

Db2SqlProcessorImpl, DerbySqlProcessorImpl, H2SqlProcessorImpl, InformixSqlProcessorImpl, MysqlSqlProcessorImpl, OracleSqlProcessorImpl, SqlProcessorImpl, SqlserverSqlProcessorImpl, SybaseSqlProcessorImpl

public interface TableSqlProcessor

Field Summary

Fields

Modifier and Type	Field and Description
static String	COLUMN_DEF
static String	COLUMN_NAME
static String	COLUMN_SIZE
static String	DATA_TYPE
static String	DECIMAL_DIGITS
static String	INDEX_NON_UNIQUE
static String	NULLABLE
static String	REMARKS
static String	TYPE_NAME

Method Summary

Modifier and Type	Method and Description
boolean	checkTableExist(Table table, Connection connection)
List<String>	getClearTableSql(Table table, Connection connection)
List<String>	getCreateSql(Table table, String packageName) 获得创建表格的语句(包含index)
String	getDropSql(Table table, String packageName)
List<String>	getForeignKeySqls(Table table, String packageName)
List<String>	getIndexCreateSql(Table table, String packageName) 获得创建索引的语句
List<String>	getTableCreateSql(Table table, String packageName) 获得创建表格的语句(不包含index)
TableProcessor	getTableProcessor()
List<String>	getUpdateSql(Table table, String packageName, Connection connection) 获得(正向)Update表格的语句
void	initChar2Byte(String language)
void	setTableProcessor(TableProcessor tableProcessor)

Field Detail

NULLABLE

static final String NULLABLE

See Also:

Constant Field Values

TYPE_NAME

static final String TYPE_NAME

See Also:

Constant Field Values

DATA_TYPE

static final String DATA_TYPE

See Also:

Constant Field Values

COLUMN_SIZE

static final String COLUMN_SIZE

See Also:

Constant Field Values

DECIMAL_DIGITS

static final String DECIMAL_DIGITS

See Also:

Constant Field Values

COLUMN_NAME

static final String COLUMN_NAME

See Also:

Constant Field Values

COLUMN_DEF

static final String COLUMN_DEF

See Also:

Constant Field Values

REMARKS

static final String REMARKS

See Also:

Constant Field Values

INDEX_NON_UNIQUE

static final String INDEX_NON_UNIQUE

See Also:

Constant Field Values

Method Detail

getCreateSql

List<String> getCreateSql(Table table,
                          String packageName)

获得创建表格的语句(包含index)

Parameters:

table -

packageName -

Returns:

getTableCreateSql

List<String> getTableCreateSql(Table table,
                               String packageName)

获得创建表格的语句(不包含index)

Parameters:

table -

packageName -

Returns:

getIndexCreateSql

List<String> getIndexCreateSql(Table table,
                               String packageName)

获得创建索引的语句

Parameters:

table -

packageName -

Returns:

getForeignKeySqls

List<String> getForeignKeySqls(Table table,
                               String packageName)

getUpdateSql

List<String> getUpdateSql(Table table,
                          String packageName,
                          Connection connection)
                   throws SQLException

获得(正向)Update表格的语句

Parameters:

table -

packageName -

connection -

Returns:

Throws:

SQLException

getDropSql

String getDropSql(Table table,
                  String packageName)

checkTableExist

boolean checkTableExist(Table table,
                        Connection connection)
                 throws SQLException

Throws:

SQLException

getTableProcessor

TableProcessor getTableProcessor()

setTableProcessor

void setTableProcessor(TableProcessor tableProcessor)

getClearTableSql

List<String> getClearTableSql(Table table,
                              Connection connection)
                       throws SQLException

Throws:

SQLException

initChar2Byte

void initChar2Byte(String language)