| java.lang.Object
 org.glasser.sql.DBUtil
| Inner Class :public static class COLUMN | |
| Inner Class :public static class FK | |
| Method Summary | |
| public static void | closeConnection(Connection conn)
| | public static void | closeResultSet(ResultSet rs)
| | public static void | closeStatement(Statement s)
| | public static String | escape(String s)
| | public static Column[] | getColumns(ResultSet rs)
| | public static ForeignKey[] | getForeignKeys(ResultSet fk)
| | public static HashMap | getTableInfoLists(TableInfo[] tables, String defaultSchemaString)
| | public static TableInfo[] | getTableInfos(ResultSet rs)
| | public static boolean | isBinaryType(int sqlType)
| | public static boolean | isCharType(int sqlType)
| | public static boolean | isDateTimeType(int sqlType)
| | public static boolean | isDisplayableType(int sqlType)
| | public static boolean | isNumericType(int sqlType)
| | public static Map[] | readResultSet(ResultSet rs)
This reads each row of a ResultSet and stores it in a HashMap object, with the
column names, force to upper case, used as keys for each value. | | public static Map[] | readResultSet(ResultSet rs, int maxRows)
This reads each row of a ResultSet and stores it in a HashMap object, with the
column names, forced to upper case, used as keys for each value. | | public static List[] | readResultSet2(ResultSet rs)
This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row. | | public static List[] | readResultSet2(ResultSet rs, int maxRows)
This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row. | | public static Object[] | readResultSet3(ResultSet rs)
This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row. | | public static Object[] | readResultSet3(ResultSet rs, int maxRows)
This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row. | | public static void | rollback(Connection conn)
| | public static void | setAutoCommit(Connection conn, boolean autoCommit)
|
| isBinaryType | | public static boolean isBinaryType(int sqlType)(Code) | | |
| isCharType | | public static boolean isCharType(int sqlType)(Code) | | |
| isDateTimeType | | public static boolean isDateTimeType(int sqlType)(Code) | | |
| isDisplayableType | | public static boolean isDisplayableType(int sqlType)(Code) | | |
| isNumericType | | public static boolean isNumericType(int sqlType)(Code) | | |
| readResultSet | | public static Map[] readResultSet(ResultSet rs) throws SQLException(Code) | | This reads each row of a ResultSet and stores it in a HashMap object, with the
column names, force to upper case, used as keys for each value. This will break
if a ResultSet contains duplicate column names.
|
| readResultSet | | public static Map[] readResultSet(ResultSet rs, int maxRows) throws SQLException(Code) | | This reads each row of a ResultSet and stores it in a HashMap object, with the
column names, forced to upper case, used as keys for each value. This will break
if a ResultSet contains duplicate column names.
Parameters:
rs - the ResultSet that will be read. It will NOT be closed after being read.
Parameters:
maxRows - the maximum number of rows to read; 0 or below indicates no limit. |
| readResultSet2 | | public static List[] readResultSet2(ResultSet rs) throws SQLException(Code) | | This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row.
|
| readResultSet2 | | public static List[] readResultSet2(ResultSet rs, int maxRows) throws SQLException(Code) | | This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row.
Parameters:
rs - the ResultSet that will be read. It will NOT be closed after being read.
Parameters:
maxRows - the maximum number of rows to read; 0 or below indicates no limit. |
| readResultSet3 | | public static Object[] readResultSet3(ResultSet rs) throws SQLException(Code) | | This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row.
|
| readResultSet3 | | public static Object[] readResultSet3(ResultSet rs, int maxRows) throws SQLException(Code) | | This reads each row of a ResultSet and stores it in an List object, with each element
of the list representing the corresponding column from the ResultSet row.
Parameters:
rs - the ResultSet that will be read. It will NOT be closed after being read.
Parameters:
maxRows - the maximum number of rows to read; 0 or below indicates no limit. |
| setAutoCommit | | public static void setAutoCommit(Connection conn, boolean autoCommit)(Code) | | |
|
|