- 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.
- BasicRowProcessor.CaseInsensitiveHashMap - Class in org.apache.commons.dbutils
-
A Map that converts all keys to lowercase Strings for case insensitive
lookups.
- BasicRowProcessor.CaseInsensitiveHashMap() - Constructor for class org.apache.commons.dbutils.BasicRowProcessor.CaseInsensitiveHashMap
-
- 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 - Class in org.apache.commons.dbutils.handlers
-
ResultSetHandler
implementation that converts the first
ResultSet
row into a JavaBean.
- BeanHandler(Class) - Constructor for class org.apache.commons.dbutils.handlers.BeanHandler
-
Creates a new instance of BeanHandler.
- BeanHandler(Class, RowProcessor) - Constructor for class org.apache.commons.dbutils.handlers.BeanHandler
-
Creates a new instance of BeanHandler.
- BeanListHandler - Class in org.apache.commons.dbutils.handlers
-
ResultSetHandler
implementation that converts a
ResultSet
into a List
of beans.
- BeanListHandler(Class) - Constructor for class org.apache.commons.dbutils.handlers.BeanListHandler
-
Creates a new instance of BeanListHandler.
- BeanListHandler(Class, 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.
- callableStatementClass - Static variable in class org.apache.commons.dbutils.ProxyFactory
-
Class[] for CallableStatement interface.
- callSetter(Object, PropertyDescriptor, Object) - Method in class org.apache.commons.dbutils.BeanProcessor
-
Calls the setter method on the target object for the given property.
- 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.
- close(Connection) - Method in class org.apache.commons.dbutils.QueryRunner
-
Close a Connection
.
- close(Statement) - Method in class org.apache.commons.dbutils.QueryRunner
-
Close a Statement
.
- close(ResultSet) - Method in class org.apache.commons.dbutils.QueryRunner
-
Close a ResultSet
.
- 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.ColumnListHandler
-
The column number to retrieve.
- columnIndex - Variable in class org.apache.commons.dbutils.handlers.KeyedHandler
-
The column index to retrieve key values from.
- columnIndex - Variable in class org.apache.commons.dbutils.handlers.ScalarHandler
-
The column number to retrieve.
- ColumnListHandler - Class in org.apache.commons.dbutils.handlers
-
ResultSetHandler
implementation that converts one
ResultSet
column into a List
of
Object
s.
- 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.ColumnListHandler
-
The column name to retrieve.
- columnName - Variable in class org.apache.commons.dbutils.handlers.KeyedHandler
-
The column name to retrieve key values from.
- columnName - Variable in class org.apache.commons.dbutils.handlers.ScalarHandler
-
The column name to retrieve.
- 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.
- connectionClass - Static variable in class org.apache.commons.dbutils.ProxyFactory
-
Class[] for Connection interface.
- containsKey(Object) - Method in class org.apache.commons.dbutils.BasicRowProcessor.CaseInsensitiveHashMap
-
- convert - Variable in class org.apache.commons.dbutils.BasicRowProcessor
-
Use this to process beans.
- convert - Variable in class org.apache.commons.dbutils.handlers.ArrayHandler
-
The RowProcessor implementation to use when converting rows
into arrays.
- convert - Variable in class org.apache.commons.dbutils.handlers.ArrayListHandler
-
The RowProcessor implementation to use when converting rows
into Object[]s.
- convert - Variable in class org.apache.commons.dbutils.handlers.BeanHandler
-
The RowProcessor implementation to use when converting rows
into beans.
- convert - Variable in class org.apache.commons.dbutils.handlers.BeanListHandler
-
The RowProcessor implementation to use when converting rows
into beans.
- convert - Variable in class org.apache.commons.dbutils.handlers.KeyedHandler
-
The RowProcessor implementation to use when converting rows
into Objects.
- convert - Variable in class org.apache.commons.dbutils.handlers.MapHandler
-
The RowProcessor implementation to use when converting rows
into Maps.
- convert - Variable in class org.apache.commons.dbutils.handlers.MapListHandler
-
The RowProcessor implementation to use when converting rows
into Maps.
- convert - Variable in class org.apache.commons.dbutils.ResultSetIterator
-
The processor to use when converting a row into an Object[].
- createBean(ResultSet, Class, PropertyDescriptor[], int[]) - Method in class org.apache.commons.dbutils.BeanProcessor
-
Creates a new object and initializes its fields from the ResultSet.
- 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.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.KeyedHandler
-
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.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.
- GenericListHandler - Class in org.apache.commons.dbutils.handlers
-
Abstract class that simplify development of ResultSetHandler
classes that convert ResultSet
into List
.
- GenericListHandler() - Constructor for class org.apache.commons.dbutils.handlers.GenericListHandler
-
- get(Object) - Method in class org.apache.commons.dbutils.BasicRowProcessor.CaseInsensitiveHashMap
-
- getDataSource() - Method in class org.apache.commons.dbutils.QueryRunner
-
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.
- prepareConnection() - Method in class org.apache.commons.dbutils.QueryRunner
-
Factory method that creates and initializes a
Connection
object.
- preparedStatementClass - Static variable in class org.apache.commons.dbutils.ProxyFactory
-
Class[] for PreparedStatement interface.
- prepareStatement(Connection, String) - Method in class org.apache.commons.dbutils.QueryRunner
-
Factory method that creates and initializes a
PreparedStatement
object for the given SQL.
- primitiveDefaults - Static variable in class org.apache.commons.dbutils.BeanProcessor
-
Set a bean's primitive properties to these defaults when SQL NULL
is returned.
- 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
.
- propertyDescriptors(Class) - Method in class org.apache.commons.dbutils.BeanProcessor
-
Returns a PropertyDescriptor[] for the given Class.
- 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.
- put(Object, Object) - Method in class org.apache.commons.dbutils.BasicRowProcessor.CaseInsensitiveHashMap
-
- putAll(Map) - Method in class org.apache.commons.dbutils.BasicRowProcessor.CaseInsensitiveHashMap
-
- remove(Object) - Method in class org.apache.commons.dbutils.BasicRowProcessor.CaseInsensitiveHashMap
-
- remove() - Method in class org.apache.commons.dbutils.ResultSetIterator
-
Deletes the current row from the ResultSet
.
- resultSetClass - Static variable in class org.apache.commons.dbutils.ProxyFactory
-
Class[] for ResultSet interface.
- ResultSetHandler - 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.QueryRunner
-
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.
- ROW_PROCESSOR - Static variable in class org.apache.commons.dbutils.handlers.ArrayHandler
-
Singleton processor instance that handlers share to save memory.
- RowProcessor - Interface in org.apache.commons.dbutils
-
RowProcessor
implementations convert
ResultSet
rows into various other objects.
- rs - Variable in class org.apache.commons.dbutils.ResultSetIterator
-
The wrapped ResultSet
.
- rs - Variable in class org.apache.commons.dbutils.wrappers.SqlNullCheckedResultSet
-
The wrapped result.
- rs - Variable in class org.apache.commons.dbutils.wrappers.StringTrimmedResultSet
-
The wrapped result.
- 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.
- setDataSource(DataSource) - Method in class org.apache.commons.dbutils.QueryRunner
-
Sets the DataSource
this runner will use to get
database connections from.
- 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
.
- statementClass - Static variable in class org.apache.commons.dbutils.ProxyFactory
-
Class[] for Statement interface.
- 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
.