A B C D F G H I K L M N O P Q R S T U W

A

AbstractKeyedHandler<K,V> - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that returns a Map.
AbstractKeyedHandler() - Constructor for class org.apache.commons.dbutils.handlers.AbstractKeyedHandler
 
AbstractListHandler<T> - Class in org.apache.commons.dbutils.handlers
Abstract class that simplify development of ResultSetHandler classes that convert ResultSet into List.
AbstractListHandler() - Constructor for class org.apache.commons.dbutils.handlers.AbstractListHandler
 
AbstractQueryRunner - Class in org.apache.commons.dbutils
The base class for QueryRunner & AsyncQueryRunner.
AbstractQueryRunner() - Constructor for class org.apache.commons.dbutils.AbstractQueryRunner
Default constructor, sets pmdKnownBroken to false and ds to null.
AbstractQueryRunner(boolean) - Constructor for class org.apache.commons.dbutils.AbstractQueryRunner
Constructor to allow workaround for Oracle drivers
AbstractQueryRunner(DataSource) - Constructor for class org.apache.commons.dbutils.AbstractQueryRunner
Constructor to provide a DataSource.
AbstractQueryRunner(DataSource, boolean) - Constructor for class org.apache.commons.dbutils.AbstractQueryRunner
Constructor to allow workaround for Oracle drivers.
ArrayHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts a ResultSet into an Object[].
ArrayHandler() - Constructor for class org.apache.commons.dbutils.handlers.ArrayHandler
Creates a new instance of ArrayHandler using a BasicRowProcessor for conversion.
ArrayHandler(RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.ArrayHandler
Creates a new instance of ArrayHandler.
ArrayListHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts the ResultSet into a List of Object[]s.
ArrayListHandler() - Constructor for class org.apache.commons.dbutils.handlers.ArrayListHandler
Creates a new instance of ArrayListHandler using a BasicRowProcessor for conversions.
ArrayListHandler(RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.ArrayListHandler
Creates a new instance of ArrayListHandler.
AsyncQueryRunner - Class in org.apache.commons.dbutils
Executes SQL queries with pluggable strategies for handling ResultSets.
AsyncQueryRunner(ExecutorService) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner
Constructor for AsyncQueryRunner.
AsyncQueryRunner(boolean, ExecutorService) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner
Constructor for AsyncQueryRunner, allows workaround for Oracle drivers
AsyncQueryRunner(DataSource, ExecutorService) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner
Constructor for AsyncQueryRunner which takes a DataSource.
AsyncQueryRunner(DataSource, boolean, ExecutorService) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner
Constructor for QueryRunner, allows workaround for Oracle drivers.
AsyncQueryRunner.BatchCallableStatement - Class in org.apache.commons.dbutils
Class that encapsulates the continuation for batch calls.
AsyncQueryRunner.BatchCallableStatement(String, Object[][], Connection, boolean, PreparedStatement) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner.BatchCallableStatement
Creates a new BatchCallableStatement instance.
AsyncQueryRunner.QueryCallableStatement<T> - Class in org.apache.commons.dbutils
Class that encapsulates the continuation for query calls.
AsyncQueryRunner.QueryCallableStatement(Connection, boolean, PreparedStatement, ResultSetHandler<T>, String, Object...) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner.QueryCallableStatement
Creates a new QueryCallableStatement instance.
AsyncQueryRunner.UpdateCallableStatement - Class in org.apache.commons.dbutils
Class that encapsulates the continuation for update calls.
AsyncQueryRunner.UpdateCallableStatement(Connection, boolean, PreparedStatement, String, Object...) - Constructor for class org.apache.commons.dbutils.AsyncQueryRunner.UpdateCallableStatement
 

B

BasicRowProcessor - Class in org.apache.commons.dbutils
Basic implementation of the RowProcessor interface.
BasicRowProcessor() - Constructor for class org.apache.commons.dbutils.BasicRowProcessor
BasicRowProcessor constructor.
BasicRowProcessor(BeanProcessor) - Constructor for class org.apache.commons.dbutils.BasicRowProcessor
BasicRowProcessor constructor.
batch(Connection, String, Object[][]) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
batch(String, Object[][]) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
batch(Connection, String, Object[][]) - Method in class org.apache.commons.dbutils.QueryRunner
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
batch(String, Object[][]) - Method in class org.apache.commons.dbutils.QueryRunner
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.
BeanHandler<T> - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts the first ResultSet row into a JavaBean.
BeanHandler(Class<T>) - Constructor for class org.apache.commons.dbutils.handlers.BeanHandler
Creates a new instance of BeanHandler.
BeanHandler(Class<T>, RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.BeanHandler
Creates a new instance of BeanHandler.
BeanListHandler<T> - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts a ResultSet into a List of beans.
BeanListHandler(Class<T>) - Constructor for class org.apache.commons.dbutils.handlers.BeanListHandler
Creates a new instance of BeanListHandler.
BeanListHandler(Class<T>, RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.BeanListHandler
Creates a new instance of BeanListHandler.
BeanProcessor - Class in org.apache.commons.dbutils
BeanProcessor matches column names to bean property names and converts ResultSet columns into objects for those bean properties.
BeanProcessor() - Constructor for class org.apache.commons.dbutils.BeanProcessor
Constructor for BeanProcessor.

C

call() - Method in class org.apache.commons.dbutils.AsyncQueryRunner.BatchCallableStatement
The actual call to executeBatch.
call() - Method in class org.apache.commons.dbutils.AsyncQueryRunner.QueryCallableStatement
The actual call to handle() method.
call() - Method in class org.apache.commons.dbutils.AsyncQueryRunner.UpdateCallableStatement
The actual call to executeUpdate() method.
close(Connection) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Close a Connection.
close(Statement) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Close a Statement.
close(ResultSet) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Close a ResultSet.
close(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Close a Connection, avoid closing if null.
close(ResultSet) - Static method in class org.apache.commons.dbutils.DbUtils
Close a ResultSet, avoid closing if null.
close(Statement) - Static method in class org.apache.commons.dbutils.DbUtils
Close a Statement, avoid closing if null.
closeQuietly(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Close a Connection, avoid closing if null and hide any SQLExceptions that occur.
closeQuietly(Connection, Statement, ResultSet) - Static method in class org.apache.commons.dbutils.DbUtils
Close a Connection, Statement and ResultSet.
closeQuietly(ResultSet) - Static method in class org.apache.commons.dbutils.DbUtils
Close a ResultSet, avoid closing if null and hide any SQLExceptions that occur.
closeQuietly(Statement) - Static method in class org.apache.commons.dbutils.DbUtils
Close a Statement, avoid closing if null and hide any SQLExceptions that occur.
columnIndex - Variable in class org.apache.commons.dbutils.handlers.KeyedHandler
The column index to retrieve key values from.
ColumnListHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts one ResultSet column into a List of Objects.
ColumnListHandler() - Constructor for class org.apache.commons.dbutils.handlers.ColumnListHandler
Creates a new instance of ColumnListHandler.
ColumnListHandler(int) - Constructor for class org.apache.commons.dbutils.handlers.ColumnListHandler
Creates a new instance of ColumnListHandler.
ColumnListHandler(String) - Constructor for class org.apache.commons.dbutils.handlers.ColumnListHandler
Creates a new instance of ColumnListHandler.
columnName - Variable in class org.apache.commons.dbutils.handlers.KeyedHandler
The column name to retrieve key values from.
commitAndClose(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Commits a Connection then closes it, avoid closing if null.
commitAndCloseQuietly(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Commits a Connection then closes it, avoid closing if null and hide any SQLExceptions that occur.
convert - Variable in class org.apache.commons.dbutils.handlers.KeyedHandler
The RowProcessor implementation to use when converting rows into Objects.
createCallableStatement(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy CallableStatement object.
createConnection(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy Connection object.
createDriver(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy Driver object.
createKey(ResultSet) - Method in class org.apache.commons.dbutils.handlers.AbstractKeyedHandler
This factory method is called by handle() to retrieve the key value from the current ResultSet row.
createKey(ResultSet) - Method in class org.apache.commons.dbutils.handlers.KeyedHandler
This factory method is called by handle() to retrieve the key value from the current ResultSet row.
createMap() - Method in class org.apache.commons.dbutils.handlers.AbstractKeyedHandler
This factory method is called by handle() to create the Map to store records in.
createPreparedStatement(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy PreparedStatement object.
createResultSet(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy ResultSet object.
createResultSetMetaData(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy ResultSetMetaData object.
createRow(ResultSet) - Method in class org.apache.commons.dbutils.handlers.AbstractKeyedHandler
This factory method is called by handle() to store the current ResultSet row in some object.
createRow(ResultSet) - Method in class org.apache.commons.dbutils.handlers.KeyedHandler
This factory method is called by handle() to store the current ResultSet row in some object.
createStatement(InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Creates a new proxy Statement object.

D

DbUtils - Class in org.apache.commons.dbutils
A collection of JDBC helper methods.
DbUtils() - Constructor for class org.apache.commons.dbutils.DbUtils
Default constructor.
ds - Variable in class org.apache.commons.dbutils.AbstractQueryRunner
The DataSource to retrieve connections from.

F

fillStatement(PreparedStatement, Object...) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Fill the PreparedStatement replacement parameters with the given objects.
fillStatementWithBean(PreparedStatement, Object, PropertyDescriptor[]) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Fill the PreparedStatement replacement parameters with the given object's bean property values.
fillStatementWithBean(PreparedStatement, Object, String...) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Fill the PreparedStatement replacement parameters with the given object's bean property values.

G

getDataSource() - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Returns the DataSource this runner is using.
getNullAsciiStream() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getAsciiStream method.
getNullBigDecimal() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getBigDecimal method.
getNullBinaryStream() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getBinaryStream method.
getNullBlob() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getBlob method.
getNullBoolean() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getBoolean method.
getNullByte() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getByte method.
getNullBytes() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getBytes method.
getNullCharacterStream() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getCharacterStream method.
getNullClob() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getClob method.
getNullDate() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getDate method.
getNullDouble() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getDouble method.
getNullFloat() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getFloat method.
getNullInt() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getInt method.
getNullLong() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getLong method.
getNullObject() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getObject method.
getNullRef() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getRef method.
getNullShort() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getShort method.
getNullString() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getString method.
getNullTime() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getTime method.
getNullTimestamp() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getTimestamp method.
getNullURL() - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Returns the value when a SQL null is encountered as the result of invoking a getURL method.

H

handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.AbstractKeyedHandler
Convert each row's columns into a Map and store then in a Map under ResultSet.getObject(key) key.
handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.AbstractListHandler
Whole ResultSet handler.
handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.ArrayHandler
Places the column values from the first row in an Object[].
handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.BeanHandler
Convert the first row of the ResultSet into a bean with the Class given in the constructor.
handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.BeanListHandler
Convert the whole ResultSet into a List of beans with the Class given in the constructor.
handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.MapHandler
Converts the first row in the ResultSet into a Map.
handle(ResultSet) - Method in class org.apache.commons.dbutils.handlers.ScalarHandler
Returns one ResultSet column as an object via the ResultSet.getObject() method that performs type conversions.
handle(ResultSet) - Method in interface org.apache.commons.dbutils.ResultSetHandler
Turn the ResultSet into an Object.
handleRow(ResultSet) - Method in class org.apache.commons.dbutils.handlers.AbstractListHandler
Row handler.
handleRow(ResultSet) - Method in class org.apache.commons.dbutils.handlers.ArrayListHandler
Convert row's columns into an Object[].
handleRow(ResultSet) - Method in class org.apache.commons.dbutils.handlers.ColumnListHandler
Returns one ResultSet column value as Object.
handleRow(ResultSet) - Method in class org.apache.commons.dbutils.handlers.MapListHandler
Converts the ResultSet row into a Map object.
hasNext() - Method in class org.apache.commons.dbutils.ResultSetIterator
Returns true if there are more rows in the ResultSet.

I

instance() - Static method in class org.apache.commons.dbutils.BasicRowProcessor
Deprecated. Create instances with the constructors instead. This will be removed after DbUtils 1.1.
instance() - Static method in class org.apache.commons.dbutils.ProxyFactory
Returns the Singleton instance of this class.
instance() - Static method in class org.apache.commons.dbutils.QueryLoader
Return an instance of this class.
invoke(Object, Method, Object[]) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Intercepts calls to get* methods and calls the appropriate getNull* method if the ResultSet returned null.
invoke(Object, Method, Object[]) - Method in class org.apache.commons.dbutils.wrappers.StringTrimmedResultSet
Intercept calls to the getString() and getObject() methods and trim any Strings before they're returned.
isPmdKnownBroken() - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Oracle drivers don't support ParameterMetaData.getParameterType(int); if pmdKnownBroken is set to true, we won't even try it; if false, we'll try it, and if it breaks, we'll remember not to use it again.
iterable(ResultSet) - Static method in class org.apache.commons.dbutils.ResultSetIterator
Generates an Iterable, suitable for use in for-each loops.

K

KeyedHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that returns a Map of Maps.
KeyedHandler() - Constructor for class org.apache.commons.dbutils.handlers.KeyedHandler
Creates a new instance of KeyedHandler.
KeyedHandler(RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.KeyedHandler
Creates a new instance of KeyedHandler.
KeyedHandler(int) - Constructor for class org.apache.commons.dbutils.handlers.KeyedHandler
Creates a new instance of KeyedHandler.
KeyedHandler(String) - Constructor for class org.apache.commons.dbutils.handlers.KeyedHandler
Creates a new instance of KeyedHandler.

L

load(String) - Method in class org.apache.commons.dbutils.QueryLoader
Loads a Map of query names to SQL values.
loadDriver(String) - Static method in class org.apache.commons.dbutils.DbUtils
Loads and registers a database driver class.
loadDriver(ClassLoader, String) - Static method in class org.apache.commons.dbutils.DbUtils
Loads and registers a database driver class.
loadQueries(String) - Method in class org.apache.commons.dbutils.QueryLoader
Loads a set of named queries into a Map object.

M

mapColumnsToProperties(ResultSetMetaData, PropertyDescriptor[]) - Method in class org.apache.commons.dbutils.BeanProcessor
The positions in the returned array represent column numbers.
MapHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts the first ResultSet row into a Map.
MapHandler() - Constructor for class org.apache.commons.dbutils.handlers.MapHandler
Creates a new instance of MapHandler using a BasicRowProcessor for conversion.
MapHandler(RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.MapHandler
Creates a new instance of MapHandler.
MapListHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts a ResultSet into a List of Maps.
MapListHandler() - Constructor for class org.apache.commons.dbutils.handlers.MapListHandler
Creates a new instance of MapListHandler using a BasicRowProcessor for conversion.
MapListHandler(RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.MapListHandler
Creates a new instance of MapListHandler.

N

newInstance(Class<T>) - Method in class org.apache.commons.dbutils.BeanProcessor
Factory method that returns a new instance of the given Class.
newProxyInstance(Class<T>, InvocationHandler) - Method in class org.apache.commons.dbutils.ProxyFactory
Convenience method to generate a single-interface proxy using the handler's classloader
next() - Method in class org.apache.commons.dbutils.ResultSetIterator
Returns the next row as an Object[].

O

org.apache.commons.dbutils - package org.apache.commons.dbutils
DbUtils is a small set of classes designed to make working with JDBC easier.
org.apache.commons.dbutils.handlers - package org.apache.commons.dbutils.handlers
Implementations of the org.apache.commons.dbutils.ResultSetHandler interface.
org.apache.commons.dbutils.wrappers - package org.apache.commons.dbutils.wrappers
Wrappers that add functionality to java.sql classes.

P

prepareConnection() - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Factory method that creates and initializes a Connection object.
prepareStatement(Connection, String) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Factory method that creates and initializes a PreparedStatement object for the given SQL.
printStackTrace(SQLException) - Static method in class org.apache.commons.dbutils.DbUtils
Print the stack trace for a SQLException to STDERR.
printStackTrace(SQLException, PrintWriter) - Static method in class org.apache.commons.dbutils.DbUtils
Print the stack trace for a SQLException to a specified PrintWriter.
printWarnings(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Print warnings on a Connection to STDERR.
printWarnings(Connection, PrintWriter) - Static method in class org.apache.commons.dbutils.DbUtils
Print warnings on a Connection to a specified PrintWriter.
processColumn(ResultSet, int, Class<?>) - Method in class org.apache.commons.dbutils.BeanProcessor
Convert a ResultSet column into an object.
PROPERTY_NOT_FOUND - Static variable in class org.apache.commons.dbutils.BeanProcessor
Special array value used by mapColumnsToProperties that indicates there is no bean property that matches a column from a ResultSet.
ProxyFactory - Class in org.apache.commons.dbutils
Creates proxy implementations of JDBC interfaces.
ProxyFactory() - Constructor for class org.apache.commons.dbutils.ProxyFactory
Protected constructor for ProxyFactory subclasses to use.

Q

query(Connection, String, ResultSetHandler<T>, Object...) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute an SQL SELECT query with replacement parameters.
query(Connection, String, ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute an SQL SELECT query without any replacement parameters.
query(String, ResultSetHandler<T>, Object...) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Executes the given SELECT SQL query and returns a result object.
query(String, ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Executes the given SELECT SQL without any replacement parameters.
query(Connection, String, Object, ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.QueryRunner
Deprecated. Use QueryRunner.query(Connection, String, ResultSetHandler, Object...)
query(Connection, String, Object[], ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.QueryRunner
Deprecated. Use QueryRunner.query(Connection,String,ResultSetHandler,Object...) instead
query(Connection, String, ResultSetHandler<T>, Object...) - Method in class org.apache.commons.dbutils.QueryRunner
Execute an SQL SELECT query with replacement parameters.
query(Connection, String, ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.QueryRunner
Execute an SQL SELECT query without any replacement parameters.
query(String, Object, ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.QueryRunner
Deprecated. Use QueryRunner.query(String, ResultSetHandler, Object...)
query(String, Object[], ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.QueryRunner
Deprecated. Use QueryRunner.query(String, ResultSetHandler, Object...)
query(String, ResultSetHandler<T>, Object...) - Method in class org.apache.commons.dbutils.QueryRunner
Executes the given SELECT SQL query and returns a result object.
query(String, ResultSetHandler<T>) - Method in class org.apache.commons.dbutils.QueryRunner
Executes the given SELECT SQL without any replacement parameters.
QueryLoader - Class in org.apache.commons.dbutils
QueryLoader is a registry for sets of queries so that multiple copies of the same queries aren't loaded into memory.
QueryLoader() - Constructor for class org.apache.commons.dbutils.QueryLoader
QueryLoader constructor.
QueryRunner - Class in org.apache.commons.dbutils
Executes SQL queries with pluggable strategies for handling ResultSets.
QueryRunner() - Constructor for class org.apache.commons.dbutils.QueryRunner
Constructor for QueryRunner.
QueryRunner(boolean) - Constructor for class org.apache.commons.dbutils.QueryRunner
Constructor for QueryRunner, allows workaround for Oracle drivers
QueryRunner(DataSource) - Constructor for class org.apache.commons.dbutils.QueryRunner
Constructor for QueryRunner which takes a DataSource.
QueryRunner(DataSource, boolean) - Constructor for class org.apache.commons.dbutils.QueryRunner
Constructor for QueryRunner, allows workaround for Oracle drivers.

R

remove() - Method in class org.apache.commons.dbutils.ResultSetIterator
Deletes the current row from the ResultSet.
ResultSetHandler<T> - Interface in org.apache.commons.dbutils
Implementations of this interface convert ResultSets into other objects.
ResultSetIterator - Class in org.apache.commons.dbutils
Wraps a ResultSet in an Iterator.
ResultSetIterator(ResultSet) - Constructor for class org.apache.commons.dbutils.ResultSetIterator
Constructor for ResultSetIterator.
ResultSetIterator(ResultSet, RowProcessor) - Constructor for class org.apache.commons.dbutils.ResultSetIterator
Constructor for ResultSetIterator.
rethrow(SQLException, String, Object...) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Throws a new exception with a more informative error message.
rethrow(SQLException) - Method in class org.apache.commons.dbutils.ResultSetIterator
Rethrow the SQLException as a RuntimeException.
rollback(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Rollback any changes made on the given connection.
rollbackAndClose(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Performs a rollback on the Connection then closes it, avoid closing if null.
rollbackAndCloseQuietly(Connection) - Static method in class org.apache.commons.dbutils.DbUtils
Performs a rollback on the Connection then closes it, avoid closing if null and hide any SQLExceptions that occur.
RowProcessor - Interface in org.apache.commons.dbutils
RowProcessor implementations convert ResultSet rows into various other objects.

S

ScalarHandler - Class in org.apache.commons.dbutils.handlers
ResultSetHandler implementation that converts one ResultSet column into an Object.
ScalarHandler() - Constructor for class org.apache.commons.dbutils.handlers.ScalarHandler
Creates a new instance of ScalarHandler.
ScalarHandler(int) - Constructor for class org.apache.commons.dbutils.handlers.ScalarHandler
Creates a new instance of ScalarHandler.
ScalarHandler(String) - Constructor for class org.apache.commons.dbutils.handlers.ScalarHandler
Creates a new instance of ScalarHandler.
setNullAsciiStream(InputStream) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getAsciiStream method.
setNullBigDecimal(BigDecimal) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getBigDecimal method.
setNullBinaryStream(InputStream) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getBinaryStream method.
setNullBlob(Blob) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getBlob method.
setNullBoolean(boolean) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getBoolean method.
setNullByte(byte) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getByte method.
setNullBytes(byte[]) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getBytes method.
setNullCharacterStream(Reader) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getCharacterStream method.
setNullClob(Clob) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getClob method.
setNullDate(Date) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getDate method.
setNullDouble(double) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getDouble method.
setNullFloat(float) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getFloat method.
setNullInt(int) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getInt method.
setNullLong(long) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getLong method.
setNullObject(Object) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getObject method.
setNullRef(Ref) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getRef method.
setNullShort(short) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getShort method.
setNullString(String) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getString method.
setNullTime(Time) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getTime method.
setNullTimestamp(Timestamp) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getTimestamp method.
setNullURL(URL) - Method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Sets the value to return when a SQL null is encountered as the result of invoking a getURL method.
SqlNullCheckedResultSet - Class in org.apache.commons.dbutils.wrappers
Decorates a ResultSet with checks for a SQL NULL value on each getXXX method.
SqlNullCheckedResultSet(ResultSet) - Constructor for class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Constructs a new instance of SqlNullCheckedResultSet to wrap the specified ResultSet.
StringTrimmedResultSet - Class in org.apache.commons.dbutils.wrappers
Wraps a ResultSet to trim strings returned by the getString() and getObject() methods.
StringTrimmedResultSet(ResultSet) - Constructor for class org.apache.commons.dbutils.wrappers.StringTrimmedResultSet
Constructs a new instance of StringTrimmedResultSet to wrap the specified ResultSet.

T

toArray(ResultSet) - Method in class org.apache.commons.dbutils.BasicRowProcessor
Convert a ResultSet row into an Object[].
toArray(ResultSet) - Method in interface org.apache.commons.dbutils.RowProcessor
Create an Object[] from the column values in one ResultSet row.
toBean(ResultSet, Class<T>) - Method in class org.apache.commons.dbutils.BasicRowProcessor
Convert a ResultSet row into a JavaBean.
toBean(ResultSet, Class<T>) - Method in class org.apache.commons.dbutils.BeanProcessor
Convert a ResultSet row into a JavaBean.
toBean(ResultSet, Class<T>) - Method in interface org.apache.commons.dbutils.RowProcessor
Create a JavaBean from the column values in one ResultSet row.
toBeanList(ResultSet, Class<T>) - Method in class org.apache.commons.dbutils.BasicRowProcessor
Convert a ResultSet into a List of JavaBeans.
toBeanList(ResultSet, Class<T>) - Method in class org.apache.commons.dbutils.BeanProcessor
Convert a ResultSet into a List of JavaBeans.
toBeanList(ResultSet, Class<T>) - Method in interface org.apache.commons.dbutils.RowProcessor
Create a List of JavaBeans from the column values in all ResultSet rows.
toMap(ResultSet) - Method in class org.apache.commons.dbutils.BasicRowProcessor
Convert a ResultSet row into a Map.
toMap(ResultSet) - Method in interface org.apache.commons.dbutils.RowProcessor
Create a Map from the column values in one ResultSet row.

U

unload(String) - Method in class org.apache.commons.dbutils.QueryLoader
Removes the queries for the given path from the cache.
update(Connection, String) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute an SQL INSERT, UPDATE, or DELETE query without replacement parameters.
update(Connection, String, Object) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute an SQL INSERT, UPDATE, or DELETE query with a single replacement parameter.
update(Connection, String, Object...) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Execute an SQL INSERT, UPDATE, or DELETE query.
update(String) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Executes the given INSERT, UPDATE, or DELETE SQL statement without any replacement parameters.
update(String, Object) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Executes the given INSERT, UPDATE, or DELETE SQL statement with a single replacement parameter.
update(String, Object...) - Method in class org.apache.commons.dbutils.AsyncQueryRunner
Executes the given INSERT, UPDATE, or DELETE SQL statement.
update(Connection, String) - Method in class org.apache.commons.dbutils.QueryRunner
Execute an SQL INSERT, UPDATE, or DELETE query without replacement parameters.
update(Connection, String, Object) - Method in class org.apache.commons.dbutils.QueryRunner
Execute an SQL INSERT, UPDATE, or DELETE query with a single replacement parameter.
update(Connection, String, Object...) - Method in class org.apache.commons.dbutils.QueryRunner
Execute an SQL INSERT, UPDATE, or DELETE query.
update(String) - Method in class org.apache.commons.dbutils.QueryRunner
Executes the given INSERT, UPDATE, or DELETE SQL statement without any replacement parameters.
update(String, Object) - Method in class org.apache.commons.dbutils.QueryRunner
Executes the given INSERT, UPDATE, or DELETE SQL statement with a single replacement parameter.
update(String, Object...) - Method in class org.apache.commons.dbutils.QueryRunner
Executes the given INSERT, UPDATE, or DELETE SQL statement.

W

wrap(ResultSet) - Method in class org.apache.commons.dbutils.AbstractQueryRunner
Wrap the ResultSet in a decorator before processing it.
wrap(ResultSet) - Static method in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
Wraps the ResultSet in an instance of this class.
wrap(ResultSet) - Static method in class org.apache.commons.dbutils.wrappers.StringTrimmedResultSet
Wraps the ResultSet in an instance of this class.

A B C D F G H I K L M N O P Q R S T U W

Copyright © 2002-2011 The Apache Software Foundation. All Rights Reserved.