public class DBUtilities
extends java.lang.Object
Constructor and Description |
---|
DBUtilities() |
Modifier and Type | Method and Description |
---|---|
static void |
close(java.sql.Connection conn) |
static void |
close(java.sql.Connection conn,
java.sql.Statement stmt)
Silently close the given connection and statement.
|
static void |
close(java.sql.ResultSet rs) |
static void |
close(java.sql.Statement stmt) |
static java.lang.Object |
getParameterValue(java.sql.CallableStatement stmt,
int index,
int dbType) |
static java.lang.Object |
getParameterValue(java.sql.CallableStatement stmt,
java.lang.String paramName,
int dbType)
This class is necessary because some db connectors don't correctly support CallableStatement.getObject(string)
[MYSQL is one, which always returns byte[2]]
|
static boolean |
isDataManipulationQuery(java.lang.String query)
Returns false if query is SELECT, otherwise true.
|
static void |
rollback(java.sql.Connection conn) |
public static java.lang.Object getParameterValue(java.sql.CallableStatement stmt, java.lang.String paramName, int dbType) throws java.sql.SQLException
stmt
- paramName
- dbType
- java.sql.SQLException
public static java.lang.Object getParameterValue(java.sql.CallableStatement stmt, int index, int dbType) throws java.sql.SQLException
java.sql.SQLException
public static void close(java.sql.Connection conn, java.sql.Statement stmt)
conn
- stmt
- public static void rollback(java.sql.Connection conn)
public static void close(java.sql.Connection conn)
public static void close(java.sql.Statement stmt)
public static void close(java.sql.ResultSet rs)
public static boolean isDataManipulationQuery(java.lang.String query)
query
-