Package org.apache.commons.dbutils
DbUtils is a small set of classes designed to make working with JDBC easier. JDBC resource cleanup code is mundane,
error prone work so these classes abstract out all of the cleanup tasks from your code leaving you with what you
really wanted to do with JDBC in the first place: query and update data.
This package contains the core classes and interfaces - DbUtils, QueryRunner and the ResultSetHandler interface
should be your first items of interest.
-
Interface Summary Interface Description ColumnHandler Interface to define how implementations can interact with column handling when constructing a bean from aResultSet
.PropertyHandler Interface to define how implementations can interact with property handling when constructing a bean from aResultSet
.ResultSetHandler<T> Implementations of this interface convert ResultSets into other objects.RowProcessor RowProcessor
implementations convertResultSet
rows into various other objects. -
Class Summary Class Description AbstractQueryRunner The base class for QueryRunner & AsyncQueryRunner.AsyncQueryRunner Executes SQL queries with pluggable strategies for handlingResultSet
s.BaseResultSetHandler<T> Extensions of this class convert ResultSets into other objects.BasicRowProcessor Basic implementation of theRowProcessor
interface.BasicRowProcessor.CaseInsensitiveHashMap A Map that converts all keys to lowercase Strings for case insensitive lookups.BeanProcessor BeanProcessor
matches column names to bean property names and convertsResultSet
columns into objects for those bean properties.DbUtils A collection of JDBC helper methods.DbUtils.DriverProxy SimpleDriver
proxy class that proxies a JDBC Driver loaded dynamically.GenerousBeanProcessor Provides generous name matching (e.g.OutParameter<T> Represents an OUT parameter for a stored procedure.ProxyFactory Creates proxy implementations of JDBC interfaces.QueryLoader QueryLoader
is a registry for sets of queries so that multiple copies of the same queries aren't loaded into memory.QueryRunner Executes SQL queries with pluggable strategies for handlingResultSet
s.ResultSetIterator Wraps aResultSet
in anIterator<Object[]>
.StatementConfiguration Configuration options for aStatement
when preparing statements inQueryRunner
.StatementConfiguration.Builder Builder class forStatementConfiguration
for more flexible construction.