[DBUTILS-27] [dbutils] QueryRunner.count(String, ...) methods for SELECT COUNT(...) sql

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix

Environment

Operating System: All
Platform: All

• Bugzilla Id: 36822
• Assignee: Unassigned
• Reporter: Michael Heuer
• Created: 27/Sep/05 07:43
• Updated: 07/Mar/09 06:04
• Resolved: 31/Jan/07 06:21

Description

Found that I was repeating the same bit of code over and over again when executing SELECT COUNT(...)
sql queries with QueryRunner, so I thought I might code this up into a set of static methods for possible
inclusion in commons-dbutils.

e.g.

Connection conn;
String sql = "select count from tablename where column0 = ? and column1 = ?";

from:

int count = 0;
Object result = QueryRunner.query(conn, sql, new Object[]

{ "foo", "bar" }, new ScalarHandler());
if (result != null) {
count = ((Integer) result).intValue();
}

to:

int count = QueryRunner.count(conn, sql, new Object[] { "foo", "bar" }

);

See attached diff.txt.