org.tinygroup.database.util

Class DataBaseUtil

java.lang.Object

org.tinygroup.database.util.DataBaseUtil

public class DataBaseUtil
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static String	CUSTOMESQL_BEAN
static String	DATABASE_XSTREAM
static String	DB_TYPE_DB2
static String	DB_TYPE_DERBY
static String	DB_TYPE_INFORMIX
static String	DB_TYPE_MYSQL
static String	DB_TYPE_ORACLE
static String	DB_TYPE_SQLSERVER
static String	DB_TYPE_SYBASE
static String	DIALECT_FUNCTION_PROCESSOR_BEAN
static ThreadLocal<String>	fromSourceLocal
static String	FUNCTION_BEAN
static String	INITDATA_BEAN
static String	INITDATA_XSTREAM
protected static Pattern	pattern
static String	PROCEDURE_BEAN
static String	PROCESSOR_XSTREAM
static String	PROCESSORMANAGER_BEAN
static String	SEQUENCE_BEAN
static String	TABLE_SPACE_PROCESSOR_BEAN
static String	TABLEPROCESSOR_BEAN
static String	TRIGGER_BEAN
static String	VIEW_BEAN

Constructor Summary

Constructors

Constructor and Description
DataBaseUtil()

Method Summary

Modifier and Type	Method and Description
static void	closeResultSet(ResultSet r)
static String	formatByColumnType(String value, StandardField standardField, String dbType, SqlValueProcessor sqlValueProcessor, ClassLoader classLoader)
static String	formatSqlForFunction(String originalSql, String databaseType, ClassLoader classLoader) 为函数自定义函数进行format
static String	getDataBaseName(String name)
static NameStrategy	getNameStrategy()
static TableField	getPrimaryField(Table table)
static String	getSchema(Table table, DatabaseMetaData metadata)
static StandardField	getStandardField(String tableFieldId, Table table, ClassLoader loader)
static Table	getTableById(String id, ClassLoader loader)
static TableProcessor	getTableProcessor(ClassLoader loader)
static List<Table>	getTables(ClassLoader loader)
static TableSpace	getTableSpace(ClassLoader loader, String spaceId)
static View	getViewById(String id, ClassLoader loader)
static boolean	isNeedCache()

Methods inherited from class java.lang.Object

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

Field Detail

DB_TYPE_ORACLE

public static final String DB_TYPE_ORACLE

See Also:

Constant Field Values

DB_TYPE_DB2

public static final String DB_TYPE_DB2

See Also:

Constant Field Values

DB_TYPE_MYSQL

public static final String DB_TYPE_MYSQL

See Also:

Constant Field Values

DB_TYPE_SQLSERVER

public static final String DB_TYPE_SQLSERVER

See Also:

Constant Field Values

DB_TYPE_INFORMIX

public static final String DB_TYPE_INFORMIX

See Also:

Constant Field Values

DB_TYPE_SYBASE

public static final String DB_TYPE_SYBASE

See Also:

Constant Field Values

DB_TYPE_DERBY

public static final String DB_TYPE_DERBY

See Also:

Constant Field Values

DIALECT_FUNCTION_PROCESSOR_BEAN

public static final String DIALECT_FUNCTION_PROCESSOR_BEAN

See Also:

Constant Field Values

pattern

protected static final Pattern pattern

DATABASE_XSTREAM

public static String DATABASE_XSTREAM

INITDATA_XSTREAM

public static String INITDATA_XSTREAM

PROCESSOR_XSTREAM

public static String PROCESSOR_XSTREAM

PROCESSORMANAGER_BEAN

public static String PROCESSORMANAGER_BEAN

TABLEPROCESSOR_BEAN

public static String TABLEPROCESSOR_BEAN

CUSTOMESQL_BEAN

public static String CUSTOMESQL_BEAN

FUNCTION_BEAN

public static String FUNCTION_BEAN

INITDATA_BEAN

public static String INITDATA_BEAN

PROCEDURE_BEAN

public static String PROCEDURE_BEAN

VIEW_BEAN

public static String VIEW_BEAN

TRIGGER_BEAN

public static String TRIGGER_BEAN

SEQUENCE_BEAN

public static String SEQUENCE_BEAN

TABLE_SPACE_PROCESSOR_BEAN

public static String TABLE_SPACE_PROCESSOR_BEAN

fromSourceLocal

public static ThreadLocal<String> fromSourceLocal

Constructor Detail

DataBaseUtil

public DataBaseUtil()

Method Detail

getStandardField

public static StandardField getStandardField(String tableFieldId,
                                             Table table,
                                             ClassLoader loader)

getTableById

public static Table getTableById(String id,
                                 ClassLoader loader)

getTables

public static List<Table> getTables(ClassLoader loader)

getTableProcessor

public static TableProcessor getTableProcessor(ClassLoader loader)

getTableSpace

public static TableSpace getTableSpace(ClassLoader loader,
                                       String spaceId)

getViewById

public static View getViewById(String id,
                               ClassLoader loader)

getPrimaryField

public static TableField getPrimaryField(Table table)

getNameStrategy

public static NameStrategy getNameStrategy()

getDataBaseName

public static String getDataBaseName(String name)

getSchema

public static String getSchema(Table table,
                               DatabaseMetaData metadata)
                        throws SQLException

Throws:

SQLException

closeResultSet

public static void closeResultSet(ResultSet r)

isNeedCache

public static boolean isNeedCache()

formatSqlForFunction

public static String formatSqlForFunction(String originalSql,
                                          String databaseType,
                                          ClassLoader classLoader)

为函数自定义函数进行format

Parameters:

originalSql -

databaseType -

classLoader -

Returns:

formatByColumnType

public static String formatByColumnType(String value,
                                        StandardField standardField,
                                        String dbType,
                                        SqlValueProcessor sqlValueProcessor,
                                        ClassLoader classLoader)