xyz.calvinwilliams.sqlaction

类 SqlActionColumn

java.lang.Object

xyz.calvinwilliams.sqlaction.SqlActionColumn

public class SqlActionColumn
extends java.lang.Object

构造器概要

构造器

构造器和说明
SqlActionColumn()

方法概要

限定符和类型	方法和说明
static java.lang.String	columnToJavaProperty(java.lang.String columnName)
static int	dumpDefineProperty(SqlActionColumn c, java.lang.StringBuilder out)
static int	dumpSelectOutputColumn(java.lang.String tabs, int columnIndex, SqlActionColumn column, java.lang.String javaObjectNameAndPropertyName, java.lang.StringBuilder out)
static int	dumpSetInputColumn(int columnIndex, SqlActionColumn column, java.lang.String columnValue, java.lang.StringBuilder out)
static int	dumpWhereInputColumn(int columnIndex, SqlActionColumn column, java.lang.String columnValue, java.lang.StringBuilder out)
static int	fetchAllColumnsMetadataInTable(DbServerConf dbserverConf, SqlActionConf sqlactionConf, java.sql.Connection conn, SqlActionDatabase database, SqlActionTable table)
static SqlActionColumn	findColumn(java.util.List<SqlActionColumn> sqlactionColumnList, java.lang.String columnName)
static SqlActionColumn	findColumnByJavaPropertyName(java.util.List<SqlActionColumn> sqlactionColumnList, java.lang.String javaPropertyName)
static int	getColumnMetadataFromResultSet_for_MYSQL(DbServerConf dbserverConf, SqlActionConf sqlactionConf, SqlActionDatabase database, SqlActionTable table, SqlActionColumn column, java.sql.ResultSet rs)
static int	getColumnMetadataFromResultSet_for_ORACLE(DbServerConf dbserverConf, SqlActionConf sqlactionConf, SqlActionDatabase database, SqlActionTable table, SqlActionColumn column, java.sql.ResultSet rs)
static int	getColumnMetadataFromResultSet_for_POSTGRESQL(DbServerConf dbserverConf, SqlActionConf sqlactionConf, SqlActionDatabase database, SqlActionTable table, SqlActionColumn column, java.sql.ResultSet rs)
static int	getColumnMetadataFromResultSet_for_SQLITE(DbServerConf dbserverConf, SqlActionConf sqlactionConf, SqlActionDatabase database, SqlActionTable table, SqlActionColumn column, java.sql.ResultSet rs)
static int	getColumnMetadataFromResultSet_for_SQLSERVER(DbServerConf dbserverConf, SqlActionConf sqlactionConf, SqlActionDatabase database, SqlActionTable table, SqlActionColumn column, java.sql.ResultSet rs)
static java.lang.String	getUserDefineDataType(DbServerConf dbserverConf, java.lang.String sourceDataTypeAndLength)
static int	travelAllColumnsMetadata(DbServerConf dbserverConf, SqlActionConf sqlactionConf, java.util.List<SqlActionColumn> sqlactionColumnList, int depth)

从类继承的方法 java.lang.Object

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

构造器详细资料

SqlActionColumn

public SqlActionColumn()

方法详细资料

getUserDefineDataType

public static java.lang.String getUserDefineDataType(DbServerConf dbserverConf,
                                                     java.lang.String sourceDataTypeAndLength)

getColumnMetadataFromResultSet_for_MYSQL

public static int getColumnMetadataFromResultSet_for_MYSQL(DbServerConf dbserverConf,
                                                           SqlActionConf sqlactionConf,
                                                           SqlActionDatabase database,
                                                           SqlActionTable table,
                                                           SqlActionColumn column,
                                                           java.sql.ResultSet rs)
                                                    throws java.lang.Exception

抛出:

java.lang.Exception

getColumnMetadataFromResultSet_for_POSTGRESQL

public static int getColumnMetadataFromResultSet_for_POSTGRESQL(DbServerConf dbserverConf,
                                                                SqlActionConf sqlactionConf,
                                                                SqlActionDatabase database,
                                                                SqlActionTable table,
                                                                SqlActionColumn column,
                                                                java.sql.ResultSet rs)
                                                         throws java.lang.Exception

抛出:

java.lang.Exception

getColumnMetadataFromResultSet_for_ORACLE

public static int getColumnMetadataFromResultSet_for_ORACLE(DbServerConf dbserverConf,
                                                            SqlActionConf sqlactionConf,
                                                            SqlActionDatabase database,
                                                            SqlActionTable table,
                                                            SqlActionColumn column,
                                                            java.sql.ResultSet rs)
                                                     throws java.lang.Exception

抛出:

java.lang.Exception

getColumnMetadataFromResultSet_for_SQLITE

public static int getColumnMetadataFromResultSet_for_SQLITE(DbServerConf dbserverConf,
                                                            SqlActionConf sqlactionConf,
                                                            SqlActionDatabase database,
                                                            SqlActionTable table,
                                                            SqlActionColumn column,
                                                            java.sql.ResultSet rs)
                                                     throws java.lang.Exception

抛出:

java.lang.Exception

getColumnMetadataFromResultSet_for_SQLSERVER

public static int getColumnMetadataFromResultSet_for_SQLSERVER(DbServerConf dbserverConf,
                                                               SqlActionConf sqlactionConf,
                                                               SqlActionDatabase database,
                                                               SqlActionTable table,
                                                               SqlActionColumn column,
                                                               java.sql.ResultSet rs)
                                                        throws java.lang.Exception

抛出:

java.lang.Exception

fetchAllColumnsMetadataInTable

public static int fetchAllColumnsMetadataInTable(DbServerConf dbserverConf,
                                                 SqlActionConf sqlactionConf,
                                                 java.sql.Connection conn,
                                                 SqlActionDatabase database,
                                                 SqlActionTable table)
                                          throws java.lang.Exception

抛出:

java.lang.Exception

findColumn

public static SqlActionColumn findColumn(java.util.List<SqlActionColumn> sqlactionColumnList,
                                         java.lang.String columnName)

findColumnByJavaPropertyName

public static SqlActionColumn findColumnByJavaPropertyName(java.util.List<SqlActionColumn> sqlactionColumnList,
                                                           java.lang.String javaPropertyName)

columnToJavaProperty

public static java.lang.String columnToJavaProperty(java.lang.String columnName)

travelAllColumnsMetadata

public static int travelAllColumnsMetadata(DbServerConf dbserverConf,
                                           SqlActionConf sqlactionConf,
                                           java.util.List<SqlActionColumn> sqlactionColumnList,
                                           int depth)

dumpDefineProperty

public static int dumpDefineProperty(SqlActionColumn c,
                                     java.lang.StringBuilder out)

dumpSelectOutputColumn

public static int dumpSelectOutputColumn(java.lang.String tabs,
                                         int columnIndex,
                                         SqlActionColumn column,
                                         java.lang.String javaObjectNameAndPropertyName,
                                         java.lang.StringBuilder out)

dumpSetInputColumn

public static int dumpSetInputColumn(int columnIndex,
                                     SqlActionColumn column,
                                     java.lang.String columnValue,
                                     java.lang.StringBuilder out)

dumpWhereInputColumn

public static int dumpWhereInputColumn(int columnIndex,
                                       SqlActionColumn column,
                                       java.lang.String columnValue,
                                       java.lang.StringBuilder out)