Package org.apache.commons.dbutils
Class DbUtils
java.lang.Object
org.apache.commons.dbutils.DbUtils
A collection of JDBC helper methods. This class is thread safe.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidclose(Connection conn) Close aConnection, avoid closing if null.static voidClose aResultSet, avoid closing if null.static voidClose aStatement, avoid closing if null.static voidcloseQuietly(Connection conn) Close aConnection, avoid closing if null and hide any SQLExceptions that occur.static voidcloseQuietly(Connection conn, Statement stmt, ResultSet rs) Close aConnection,StatementandResultSet.static voidcloseQuietly(ResultSet resultSet) Close aResultSet, avoid closing if null and hide any SQLExceptions that occur.static voidcloseQuietly(Statement stmt) Close aStatement, avoid closing if null and hide any SQLExceptions that occur.static voidcommitAndClose(Connection conn) Commits aConnectionthen closes it, avoid closing if null.static voidCommits aConnectionthen closes it, avoid closing if null and hide any SQLExceptions that occur.static booleanloadDriver(ClassLoader classLoader, String driverClassName) Loads and registers a database driver class.static booleanloadDriver(String driverClassName) Loads and registers a database driver class.static voidPrint the stack trace for a SQLException to STDERR.static voidPrint the stack trace for a SQLException to a specified PrintWriter.static voidprintWarnings(Connection conn) Print warnings on a Connection to STDERR.static voidprintWarnings(Connection conn, PrintWriter pw) Print warnings on a Connection to a specified PrintWriter.static voidrollback(Connection conn) Rollback any changes made on the given connection.static voidrollbackAndClose(Connection conn) Performs a rollback on theConnectionthen closes it, avoid closing if null.static voidPerforms a rollback on theConnectionthen closes it, avoid closing if null and hide any SQLExceptions that occur.static voidrollbackQuietly(Connection conn) Performs a rollback on theConnection, avoid closing if null and hide any SQLExceptions that occur.
-
Constructor Details
-
DbUtils
public DbUtils()Default constructor. Utility classes should not have a public or default constructor, but this one preserves retro-compatibility.- Since:
- 1.4
-
-
Method Details
-
close
Close aConnection, avoid closing if null.- Parameters:
conn- Connection to close.- Throws:
SQLException- if a database access error occurs
-
close
Close aResultSet, avoid closing if null.- Parameters:
resultSet- ResultSet to close.- Throws:
SQLException- if a database access error occurs
-
close
Close aStatement, avoid closing if null.- Parameters:
stmt- Statement to close.- Throws:
SQLException- if a database access error occurs
-
closeQuietly
Close aConnection, avoid closing if null and hide any SQLExceptions that occur.- Parameters:
conn- Connection to close.
-
closeQuietly
Close aConnection,StatementandResultSet. Avoid closing if null and hide any SQLExceptions that occur.- Parameters:
conn- Connection to close.stmt- Statement to close.rs- ResultSet to close.
-
closeQuietly
Close aResultSet, avoid closing if null and hide any SQLExceptions that occur.- Parameters:
resultSet- ResultSet to close.
-
closeQuietly
Close aStatement, avoid closing if null and hide any SQLExceptions that occur.- Parameters:
stmt- Statement to close.
-
commitAndClose
Commits aConnectionthen closes it, avoid closing if null.- Parameters:
conn- Connection to close.- Throws:
SQLException- if a database access error occurs
-
commitAndCloseQuietly
Commits aConnectionthen closes it, avoid closing if null and hide any SQLExceptions that occur.- Parameters:
conn- Connection to close.
-
loadDriver
Loads and registers a database driver class. If this succeeds, it returns true, else it returns false.- Parameters:
classLoader- the class loader used to load the driver classdriverClassName- of driver to load- Returns:
- boolean
trueif the driver was found, otherwisefalse - Since:
- 1.4
-
loadDriver
Loads and registers a database driver class. If this succeeds, it returns true, else it returns false.- Parameters:
driverClassName- of driver to load- Returns:
- boolean
trueif the driver was found, otherwisefalse
-
printStackTrace
Print the stack trace for a SQLException to STDERR.- Parameters:
e- SQLException to print stack trace of
-
printStackTrace
Print the stack trace for a SQLException to a specified PrintWriter.- Parameters:
e- SQLException to print stack trace ofpw- PrintWriter to print to
-
printWarnings
Print warnings on a Connection to STDERR.- Parameters:
conn- Connection to print warnings from
-
printWarnings
Print warnings on a Connection to a specified PrintWriter.- Parameters:
conn- Connection to print warnings frompw- PrintWriter to print to
-
rollback
Rollback any changes made on the given connection.- Parameters:
conn- Connection to rollback. A null value is legal.- Throws:
SQLException- if a database access error occurs
-
rollbackAndClose
Performs a rollback on theConnectionthen closes it, avoid closing if null.- Parameters:
conn- Connection to rollback. A null value is legal.- Throws:
SQLException- if a database access error occurs- Since:
- 1.1
-
rollbackAndCloseQuietly
Performs a rollback on theConnectionthen closes it, avoid closing if null and hide any SQLExceptions that occur.- Parameters:
conn- Connection to rollback. A null value is legal.- Since:
- 1.1
-
rollbackQuietly
Performs a rollback on theConnection, avoid closing if null and hide any SQLExceptions that occur.- Parameters:
conn- Connection to rollback. A null value is legal.- Since:
- DbUtils 2.0
-