Overview  Package   Class  Use  Tree  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.jaxfront.core.util.sql
Class SQLHelper

java.lang.Object
  extended by com.jaxfront.core.util.sql.SQLHelper

public class SQLHelper
extends java.lang.Object

Field Summary
static java.lang.String BIND_VAR_SKIP_MARKER
           
 
Constructor Summary
SQLHelper()
           
 
Method Summary
static void addGenericToSQLPreparedStatement(java.sql.PreparedStatement stmnt, java.lang.Object[] values)
           
static void addSQLFieldValue(java.lang.StringBuffer updateSQL, int i, java.lang.Object aFieldVal)
           
static void addSQLFieldValueSQLTyped(java.lang.StringBuffer updateSQL, int colType, java.lang.Object aFieldVal)
           
static void addToSQLPreparedStatement(java.sql.PreparedStatement stmnt, java.lang.Object[] values)
           
static void addValueToSQLStatement(int dataType, java.sql.PreparedStatement statement, int position, java.lang.Object value)
           
static void closeConnection(java.sql.Connection con)
           
static void closeResultSet(java.sql.ResultSet resultSet)
           
static void closeStatement(java.sql.Statement aStatement)
           
static java.lang.String createIdentityByAutoIncrement(java.sql.Connection con, java.lang.String tableName, java.lang.String uuidFName, java.lang.String id)
           
static java.lang.String createIdentityByHighValue(java.sql.Connection con, java.lang.String tableName, java.lang.String uuidFName, java.lang.String id)
           
static java.lang.String createSQLPreparedInsert(java.lang.String tableName, java.lang.Object[] fields)
           
static java.lang.String[] extractFromToListString(java.lang.String fromTo)
           
static java.lang.String[] extractFromToRangeString(java.lang.String fromTo)
           
static java.lang.String getAdditionalParams(java.lang.String[] columnNames)
           
static java.lang.String getCatalogName(java.sql.ResultSet indexInformation)
           
static void getCatalogs(java.sql.DatabaseMetaData meta)
           
static int[] getColDataTypes(java.sql.ResultSetMetaData meta)
           
static java.lang.String[] getColNames(java.sql.ResultSetMetaData meta)
           
static java.lang.String getColumnName(java.sql.ResultSet indexInformation)
           
static java.lang.String getColumnNamesSQLFormatted(java.lang.String[] columnNames)
           
static java.sql.Connection getConnection(java.lang.String url, java.lang.String dbName, java.lang.String driver, java.lang.String userName, java.lang.String password)
           
static java.util.List getDBSchemas(java.sql.Connection con)
           
static java.lang.String getIndexName(java.sql.ResultSet indexInformation)
           
static java.util.Map getIntDataTypes()
           
static java.lang.String getRangeSQL(java.lang.String qualifiedColName, java.lang.String[] fromToDef)
           
static java.lang.String getSchemaName(java.sql.ResultSet indexInformation)
           
static void getSchemas(java.sql.DatabaseMetaData meta)
           
static java.lang.String getSQLFieldBlocks(java.lang.Object[] fields, java.lang.String cond, java.lang.String sep)
           
static int getSQLIntDataType(java.lang.Class javaClass)
           
static java.lang.String getSQLPreparedDelete(java.lang.String tableName, java.lang.Object[] idFields, java.lang.Object[] idValues)
           
static java.lang.String getSQLPreparedInsert(java.lang.String tableName, java.lang.Object[] fields)
           
static java.lang.String getSQLPreparedUpdate(java.lang.String tableName, java.lang.Object[] idFields, java.lang.Object[] fields)
           
static java.lang.String getSQLPreparedUpdate(java.lang.String tableName, java.lang.Object[] idFields, java.lang.Object[] idValues, java.lang.Object[] fields)
           
static java.lang.String getSQLPreparedUpdateKeyValArray(java.lang.String tableName, java.lang.Object[] idFieldsWithValue, java.lang.Object[] fieldsWithValue)
           
static java.lang.String getTableName(java.sql.ResultSet indexInformation)
           
static java.lang.String[] getTableNames(java.sql.ResultSetMetaData meta)
           
static boolean isBinary(int sqlType)
           
static boolean isDate(int dataType)
           
static boolean isDateTime(int dataType)
           
static boolean isNull(java.lang.Object value)
           
static boolean isNumeric(int dataType)
           
static boolean isText(int dataType)
           
static boolean isTime(int dataType)
           
static void main(java.lang.String[] args)
           
static boolean parseAsBoolean(java.lang.Object value)
           
static byte parseAsByte(java.lang.Object value)
           
static byte[] parseAsByteArray(java.lang.Object value)
           
static java.util.Date parseAsDate(java.lang.Object value)
           
static double parseAsDouble(java.lang.Object value)
           
static float parseAsFloat(java.lang.Object value)
           
static java.io.InputStream parseAsInputStream(java.lang.Object value)
           
static int parseAsInt(java.lang.Object value)
           
static long parseAsLong(java.lang.Object value)
           
static java.io.Reader parseAsStringReader(java.lang.Object value)
           
static java.util.Date parseAsTime(java.lang.Object value)
           
static java.util.Date parseAsTimeStamp(java.lang.Object value)
           
static java.util.Vector parseSQLCommands(java.io.InputStream initStream)
           
static java.util.Vector parseSQLCommands(java.io.Reader input)
           
static void printAllCols(java.sql.ResultSet indexInformation)
           
static java.util.List queryForeignKeys(java.sql.Connection con, java.lang.String schema, java.lang.String tableName)
           
static java.util.List queryFunctions(java.sql.Connection con, java.lang.String schema, java.lang.String tableName)
           
static java.util.List queryImportedKeys(java.sql.Connection con, java.lang.String schema, java.lang.String tableName)
           
static java.util.List queryIndex(java.sql.Connection con, java.lang.String schema, java.lang.String tableName, boolean unique)
           
static java.lang.String[] queryPrimaryKeys(java.lang.String schema, java.lang.String tableName, java.sql.DatabaseMetaData meta)
           
static java.lang.String removeFromPreparedInsertSQL(java.lang.String sql, java.lang.String[] missingCols)
           
static void setBinaryStream(java.sql.PreparedStatement statement, int position, java.lang.Object value)
           
static void setCharacterStream(java.sql.PreparedStatement statement, int position, java.lang.Object value)
           
static void setDate(java.sql.PreparedStatement statement, int position, java.lang.Object value, java.lang.String sVal)
           
static void setTime(java.sql.PreparedStatement statement, int position, java.lang.Object value, java.lang.String sVal)
           
static void setTimestamp(java.sql.PreparedStatement statement, int position, java.lang.Object value, java.lang.String sVal)
           
static java.lang.String toSQLDdate(java.util.Date d)
           
static java.lang.String toSQLTime(java.util.Date d)
           
static java.lang.String toSQLTimestamp(java.util.Date d)
           
static int translateJDBCTypeToXSD(int dataType)
           
static java.lang.String translateVar(java.lang.String query, IResult result, int row)
           
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

BIND_VAR_SKIP_MARKER

public static final java.lang.String BIND_VAR_SKIP_MARKER
See Also:
Constant Field Values
Constructor Detail

SQLHelper

public SQLHelper()
Method Detail

addGenericToSQLPreparedStatement

public static void addGenericToSQLPreparedStatement(java.sql.PreparedStatement stmnt,
                                                    java.lang.Object[] values)
                                             throws java.sql.SQLException
Throws:
java.sql.SQLException

addSQLFieldValue

public static void addSQLFieldValue(java.lang.StringBuffer updateSQL,
                                    int i,
                                    java.lang.Object aFieldVal)

addSQLFieldValueSQLTyped

public static void addSQLFieldValueSQLTyped(java.lang.StringBuffer updateSQL,
                                            int colType,
                                            java.lang.Object aFieldVal)

addToSQLPreparedStatement

public static void addToSQLPreparedStatement(java.sql.PreparedStatement stmnt,
                                             java.lang.Object[] values)
                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

addValueToSQLStatement

public static void addValueToSQLStatement(int dataType,
                                          java.sql.PreparedStatement statement,
                                          int position,
                                          java.lang.Object value)
                                   throws java.sql.SQLException
Throws:
java.sql.SQLException

closeConnection

public static void closeConnection(java.sql.Connection con)

closeResultSet

public static void closeResultSet(java.sql.ResultSet resultSet)

closeStatement

public static void closeStatement(java.sql.Statement aStatement)

createIdentityByAutoIncrement

public static java.lang.String createIdentityByAutoIncrement(java.sql.Connection con,
                                                             java.lang.String tableName,
                                                             java.lang.String uuidFName,
                                                             java.lang.String id)

createIdentityByHighValue

public static java.lang.String createIdentityByHighValue(java.sql.Connection con,
                                                         java.lang.String tableName,
                                                         java.lang.String uuidFName,
                                                         java.lang.String id)

createSQLPreparedInsert

public static java.lang.String createSQLPreparedInsert(java.lang.String tableName,
                                                       java.lang.Object[] fields)

extractFromToListString

public static java.lang.String[] extractFromToListString(java.lang.String fromTo)

extractFromToRangeString

public static java.lang.String[] extractFromToRangeString(java.lang.String fromTo)

getAdditionalParams

public static java.lang.String getAdditionalParams(java.lang.String[] columnNames)

getCatalogName

public static java.lang.String getCatalogName(java.sql.ResultSet indexInformation)
                                       throws java.sql.SQLException
Parameters:
indexInformation -
Returns:
Throws:
java.sql.SQLException

getCatalogs

public static void getCatalogs(java.sql.DatabaseMetaData meta)
                        throws java.lang.Exception
Throws:
java.lang.Exception

getColDataTypes

public static int[] getColDataTypes(java.sql.ResultSetMetaData meta)
                             throws java.sql.SQLException
Throws:
java.sql.SQLException

getColNames

public static java.lang.String[] getColNames(java.sql.ResultSetMetaData meta)
                                      throws java.sql.SQLException
Throws:
java.sql.SQLException

getColumnName

public static java.lang.String getColumnName(java.sql.ResultSet indexInformation)
                                      throws java.sql.SQLException
Parameters:
indexInformation -
Returns:
Throws:
java.sql.SQLException

getColumnNamesSQLFormatted

public static java.lang.String getColumnNamesSQLFormatted(java.lang.String[] columnNames)

getConnection

public static java.sql.Connection getConnection(java.lang.String url,
                                                java.lang.String dbName,
                                                java.lang.String driver,
                                                java.lang.String userName,
                                                java.lang.String password)

getDBSchemas

public static java.util.List getDBSchemas(java.sql.Connection con)
                                   throws java.sql.SQLException
Throws:
java.sql.SQLException

getIndexName

public static java.lang.String getIndexName(java.sql.ResultSet indexInformation)
                                     throws java.sql.SQLException
Parameters:
indexInformation -
Returns:
Throws:
java.sql.SQLException

getIntDataTypes

public static java.util.Map getIntDataTypes()

getRangeSQL

public static java.lang.String getRangeSQL(java.lang.String qualifiedColName,
                                           java.lang.String[] fromToDef)

getSchemaName

public static java.lang.String getSchemaName(java.sql.ResultSet indexInformation)
                                      throws java.sql.SQLException
Parameters:
indexInformation -
Returns:
Throws:
java.sql.SQLException

getSchemas

public static void getSchemas(java.sql.DatabaseMetaData meta)
                       throws java.lang.Exception
Throws:
java.lang.Exception

getSQLFieldBlocks

public static java.lang.String getSQLFieldBlocks(java.lang.Object[] fields,
                                                 java.lang.String cond,
                                                 java.lang.String sep)

getSQLIntDataType

public static int getSQLIntDataType(java.lang.Class javaClass)

getSQLPreparedDelete

public static java.lang.String getSQLPreparedDelete(java.lang.String tableName,
                                                    java.lang.Object[] idFields,
                                                    java.lang.Object[] idValues)

getSQLPreparedInsert

public static java.lang.String getSQLPreparedInsert(java.lang.String tableName,
                                                    java.lang.Object[] fields)

getSQLPreparedUpdate

public static java.lang.String getSQLPreparedUpdate(java.lang.String tableName,
                                                    java.lang.Object[] idFields,
                                                    java.lang.Object[] fields)

getSQLPreparedUpdate

public static java.lang.String getSQLPreparedUpdate(java.lang.String tableName,
                                                    java.lang.Object[] idFields,
                                                    java.lang.Object[] idValues,
                                                    java.lang.Object[] fields)

getSQLPreparedUpdateKeyValArray

public static java.lang.String getSQLPreparedUpdateKeyValArray(java.lang.String tableName,
                                                               java.lang.Object[] idFieldsWithValue,
                                                               java.lang.Object[] fieldsWithValue)

getTableName

public static java.lang.String getTableName(java.sql.ResultSet indexInformation)
                                     throws java.sql.SQLException
Parameters:
indexInformation -
Returns:
Throws:
java.sql.SQLException

getTableNames

public static java.lang.String[] getTableNames(java.sql.ResultSetMetaData meta)
                                        throws java.sql.SQLException
Throws:
java.sql.SQLException

isBinary

public static boolean isBinary(int sqlType)

isDate

public static boolean isDate(int dataType)

isDateTime

public static boolean isDateTime(int dataType)

isNull

public static boolean isNull(java.lang.Object value)

isNumeric

public static boolean isNumeric(int dataType)

isText

public static boolean isText(int dataType)

isTime

public static boolean isTime(int dataType)

main

public static void main(java.lang.String[] args)

parseAsBoolean

public static boolean parseAsBoolean(java.lang.Object value)

parseAsByte

public static byte parseAsByte(java.lang.Object value)

parseAsByteArray

public static byte[] parseAsByteArray(java.lang.Object value)

parseAsDate

public static java.util.Date parseAsDate(java.lang.Object value)
                                  throws java.text.ParseException
Throws:
java.text.ParseException

parseAsDouble

public static double parseAsDouble(java.lang.Object value)

parseAsFloat

public static float parseAsFloat(java.lang.Object value)

parseAsInputStream

public static java.io.InputStream parseAsInputStream(java.lang.Object value)

parseAsInt

public static int parseAsInt(java.lang.Object value)

parseAsLong

public static long parseAsLong(java.lang.Object value)

parseAsStringReader

public static java.io.Reader parseAsStringReader(java.lang.Object value)

parseAsTime

public static java.util.Date parseAsTime(java.lang.Object value)
                                  throws java.text.ParseException
Throws:
java.text.ParseException

parseAsTimeStamp

public static java.util.Date parseAsTimeStamp(java.lang.Object value)
                                       throws java.text.ParseException
Throws:
java.text.ParseException

parseSQLCommands

public static java.util.Vector parseSQLCommands(java.io.InputStream initStream)
                                         throws java.io.IOException
Throws:
java.io.IOException

parseSQLCommands

public static java.util.Vector parseSQLCommands(java.io.Reader input)
                                         throws java.io.IOException
Parameters:
resultBlocks -
initStream -
Throws:
java.io.IOException

printAllCols

public static void printAllCols(java.sql.ResultSet indexInformation)
                         throws java.sql.SQLException
Throws:
java.sql.SQLException

queryForeignKeys

public static java.util.List queryForeignKeys(java.sql.Connection con,
                                              java.lang.String schema,
                                              java.lang.String tableName)
                                       throws java.sql.SQLException
Throws:
java.sql.SQLException

queryFunctions

public static java.util.List queryFunctions(java.sql.Connection con,
                                            java.lang.String schema,
                                            java.lang.String tableName)
                                     throws java.sql.SQLException
Throws:
java.sql.SQLException

queryImportedKeys

public static java.util.List queryImportedKeys(java.sql.Connection con,
                                               java.lang.String schema,
                                               java.lang.String tableName)
                                        throws java.sql.SQLException
Throws:
java.sql.SQLException

queryIndex

public static java.util.List queryIndex(java.sql.Connection con,
                                        java.lang.String schema,
                                        java.lang.String tableName,
                                        boolean unique)
                                 throws java.sql.SQLException
Throws:
java.sql.SQLException

queryPrimaryKeys

public static java.lang.String[] queryPrimaryKeys(java.lang.String schema,
                                                  java.lang.String tableName,
                                                  java.sql.DatabaseMetaData meta)
                                           throws java.sql.SQLException
Throws:
java.sql.SQLException

removeFromPreparedInsertSQL

public static java.lang.String removeFromPreparedInsertSQL(java.lang.String sql,
                                                           java.lang.String[] missingCols)

setBinaryStream

public static void setBinaryStream(java.sql.PreparedStatement statement,
                                   int position,
                                   java.lang.Object value)
                            throws java.sql.SQLException
Parameters:
statement -
position -
value -
Throws:
java.sql.SQLException

setCharacterStream

public static void setCharacterStream(java.sql.PreparedStatement statement,
                                      int position,
                                      java.lang.Object value)
                               throws java.sql.SQLException
Parameters:
statement -
position -
value -
Throws:
java.sql.SQLException

setDate

public static void setDate(java.sql.PreparedStatement statement,
                           int position,
                           java.lang.Object value,
                           java.lang.String sVal)
                    throws java.sql.SQLException
Parameters:
statement -
position -
value -
sVal -
Throws:
java.sql.SQLException

setTime

public static void setTime(java.sql.PreparedStatement statement,
                           int position,
                           java.lang.Object value,
                           java.lang.String sVal)
                    throws java.sql.SQLException
Parameters:
statement -
position -
value -
sVal -
Throws:
java.sql.SQLException

setTimestamp

public static void setTimestamp(java.sql.PreparedStatement statement,
                                int position,
                                java.lang.Object value,
                                java.lang.String sVal)
                         throws java.sql.SQLException
Parameters:
statement -
position -
value -
sVal -
Throws:
java.sql.SQLException

toSQLDdate

public static java.lang.String toSQLDdate(java.util.Date d)
Returns:
a JDBC escaped value with the date portion of the given Date

toSQLTime

public static java.lang.String toSQLTime(java.util.Date d)
Returns:
a JDBC escaped value with the time portion of the given Date

toSQLTimestamp

public static java.lang.String toSQLTimestamp(java.util.Date d)
Returns:
a JDBC escaped value with the date-time portion of the given Date (including milliseconds)

translateJDBCTypeToXSD

public static int translateJDBCTypeToXSD(int dataType)

translateVar

public static java.lang.String translateVar(java.lang.String query,
                                            IResult result,
                                            int row)
Overview  Package   Class  Use  Tree  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD