Apache Commons DbUtils

Apache Commons DbUtils is a library designed to facilitate easy usage of JDBC (as it is mentioned on its official website).

Apache Commons DBUtils

Developer(s)	Apache Software Foundation
Stable release	1.7 / July 2017, 20 (20-07-2017)
Repository	https://github.com/apache/commons-dbutils
Written in	Java
Engine
Operating system	Cross-platform
License	Apache License 2.0
Website	commons.apache.org/proper/commons-dbutils/changes-report.html

Search Apache Commons DbUtils on Amazon.

Advantages

Some advantages are given below (as mentioned on its official website):

• Less possibility for resource leaks.
• Cleaner, clearer persistence code.
• Automatically populate JavaBean properties from ResultSets.

Scope

DbUtils is designed to cover the following scopes:

• Small - user should be able to understand the whole package in a short amount of time.
• Transparent - user gives it a query, it executes it, and cleans up.
• Fast - user doesn't need to create many temporary objects to work with DbUtils.

Example

Sample code may look like the following:

// Create a ResultSetHandler implementation to convert the
// first row into an Object[].
ResultSetHandler<Object[]> h = new ResultSetHandler<Object[]>() {
    public Object[] handle(ResultSet rs) throws SQLException {
        if (!rs.next()) {
            return null;
        }
    
        ResultSetMetaData meta = rs.getMetaData();
        int cols = meta.getColumnCount();
        Object[] result = new Object[cols];

        for (int i = 0; i < cols; i++) {
            result[i] = rs.getObject(i + 1);
        }

        return result;
    }
};

// Create a QueryRunner that will use connections from
// the given DataSource
QueryRunner run = new QueryRunner(dataSource);

// Execute the query and get the results back from the handler
Object[] result = run.query(
    "SELECT * FROM Person WHERE name=?", h, "John Doe");

See also

• commons-io on GitHub

External links

• Official website

This article "Apache Commons DbUtils" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Apache Commons DbUtils. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.

📰 Article(s) of the same category(ies)

• HomerHEVC
• Microsoft Reflect
• Clutter (software)
• NL5 Circuit Simulator
• GuardianKey
• Sobi2
• Bareos

---