Class SQLQuery
java.lang.Object
com.dandymadeproductions.ajqvue.utilities.db.SQLQuery
The SQLQuery class provides the means to collect in a generic manner
the characteristics of a SQL query.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionintintexecuteSQL(ConnectionInstance connectionInstance) intexecuteSQL(Connection dbConnection) intintgetRowCount(ConnectionInstance connectionInstance) intgetRowCount(Connection dbConnection, String dataSourceType) static ObjectgetSQLiteDate(ResultSet resultSet, int columnSQLType, String columnName) static ObjectgetSQLiteTime(ResultSet resultSet, int columnSQLType, String columnName) static ObjectgetSQLiteTimestamp(ResultSet resultSet, int columnSQLType, String columnTypeName, String columnName) static ObjectgetSQLiteTimeTZ(ResultSet resultSet, int columnSQLType, String columnName) static intgetSQLiteTypeof(Connection dbConnection, String query, String colNameString) intstatic booleanstatic booleanisNotQuoted(String columnClass, int columnSQLType, String columnTypeName) static booleanstatic booleanisText(String columnClass, int columnSQLType, String columnTypeName, boolean isViewForm, int columnSize)
-
Constructor Details
-
SQLQuery
-
SQLQuery
-
-
Method Details
-
executeSQL
public int executeSQL() -
executeSQL
-
executeSQL
- Throws:
SQLException
-
getSQLiteTypeof
-
getSQLiteDate
public static Object getSQLiteDate(ResultSet resultSet, int columnSQLType, String columnName) throws SQLException - Throws:
SQLException
-
getSQLiteTime
public static Object getSQLiteTime(ResultSet resultSet, int columnSQLType, String columnName) throws SQLException - Throws:
SQLException
-
getSQLiteTimeTZ
public static Object getSQLiteTimeTZ(ResultSet resultSet, int columnSQLType, String columnName) throws SQLException - Throws:
SQLException
-
getSQLiteTimestamp
public static Object getSQLiteTimestamp(ResultSet resultSet, int columnSQLType, String columnTypeName, String columnName) throws SQLException - Throws:
SQLException
-
getColumnNames
-
getColumnClassHashMap
-
getColumnSQLTypeHashMap
-
getColumnTypeNameHashMap
-
getColumnScaleHashMap
-
getColumnPrecisionHashMap
-
getColumnSizeHashMap
-
getColumnIsNullableHashMap
-
getColumnIsAutoIncrementHashMap
-
getSqlColumnNamesString
-
getSqlOrcaleColumnNamesString
-
getRowCount
public int getRowCount() -
getRowCount
-
getRowCount
-
getSQLQuery
-
getValidQuery
public int getValidQuery() -
isBlob
-
isNotQuoted
-
isNumeric
-
isText
-