net.mtu.eggplant.util.sql

Class SQLFunctions

java.lang.Object

net.mtu.eggplant.util.sql.SQLFunctions

public final class SQLFunctions
extends java.lang.Object

Handy functions for SQL

Method Summary

Modifier and Type	Method and Description
static void	close(java.sql.Connection connection) Close connection and ignore SQLExceptions.
static void	close(java.sql.PreparedStatement prep) Close prep and ignore SQLExceptions.
static void	close(java.sql.ResultSet rs) Close rs and ignore SQLExceptions.
static void	close(java.sql.Statement stmt) Close stmt and ignore SQLExceptions.
static java.lang.Class<?>	getClassForType(int type) Do simple mapping from an SQL type to a Java Class.
static java.util.Collection<java.lang.String>	getTablesInDB(java.sql.Connection connection) Get the tables in the database.

Methods inherited from class java.lang.Object

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

Method Detail

getClassForType

public static java.lang.Class<?> getClassForType(int type)

Do simple mapping from an SQL type to a Java Class.

close

public static void close(java.sql.Statement stmt)

Close stmt and ignore SQLExceptions. This is useful in a finally so that all of the finally block gets executed. Handles null.

close

public static void close(java.sql.PreparedStatement prep)

Close prep and ignore SQLExceptions. This is useful in a finally so that all of the finally block gets executed. Handles null.

close

public static void close(java.sql.ResultSet rs)

Close rs and ignore SQLExceptions. This is useful in a finally so that all of the finally block gets executed. Handles null.

close

public static void close(java.sql.Connection connection)

Close connection and ignore SQLExceptions. This is useful in a finally so that all of the finally block gets executed. Handles null.

getTablesInDB

public static java.util.Collection<java.lang.String> getTablesInDB(java.sql.Connection connection)
                                                            throws java.sql.SQLException

Get the tables in the database.

Parameters:

connection - the connection to the database

Returns:

the names of the tables that are of type "TABLE", the names will be all lowercase

Throws:

java.sql.SQLException

See Also:

DatabaseMetaData.getTables(String, String, String, String[])