Package org.apache.commons.dbutils
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.
-
ClassDescriptionThe base class for QueryRunner & AsyncQueryRunner.Executes SQL queries with pluggable strategies for handling
ResultSet
s.Extensions of this class convert ResultSets into other objects.Basic implementation of theRowProcessor
interface.BeanProcessor
matches column names to bean property names and convertsResultSet
columns into objects for those bean properties.Annotation for BeanProcessor to receive hints of the field name rather than dissecting the method name.Defines how to process columns when constructing a bean from aResultSet
.A collection of JDBC helper methods.Provides generous name matching (e.g.OutParameter<T>Represents an OUT parameter for a stored procedure.Defines how to handle properties when constructing a bean from aResultSet
.Creates proxy implementations of JDBC interfaces.QueryLoader
is a registry for sets of queries so that multiple copies of the same queries aren't loaded into memory.Executes SQL queries with pluggable strategies for handlingResultSet
s.Implementations of this interface convert ResultSets into other objects.Wraps aResultSet
in anIterator<Object[]>
.RowProcessor
implementations convertResultSet
rows into various other objects.Configuration options for aStatement
when preparing statements inQueryRunner
.Builder class forStatementConfiguration
for more flexible construction.