[DBUTILS-25] [dbutils] Proposal for a set of new ResultSetHandlers

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.0
• Fix Version/s: 1.1

Environment

Operating System: All
Platform: All

• Bugzilla Id: 31446
• Assignee: Unassigned
• Reporter: Piotr Lakomy
• Created: 28/Sep/04 11:07
• Updated: 02/Jan/08 07:29
• Resolved: 02/Jan/08 07:29

Description

Add set of ResultSetHandlers that return a Map instead of List.

For each row, key is determined (default is first column, user can specify
column index/name in constructor). Next the row is converted to scalar,
Array, Map or bean and stored in the Map under key.

object Array Map Bean
----------------- ---------------- -------------- ---------------
ColumnMapHandler ArrayMapHandler MapMapHandler BeanListHandler

Examples:

String; sql = "select user_id, user_name, last_login from passwd";
Map users = (Map)run.query(
"select user_id, user_name from passwd",
new ColumnMapHandler());
System.out.println(users.get("usr007"));

Map users = (Map)run.query(sql, new ArrayMapArray());
System.out.println(users.get("usr007")[2]);

Map users = (Map)run.query(sql, new MapMapArray());
System.out.println(users.get("usr007").get("last_login"));

Map users = (Map)run.query(sql, new MapBeanArray(TestBean.class));
System.out.println(users.get("usr007").getLastLogin());

Implementation note:
Map implementation is LinkedHashMap. This class does preserve order of
insertions, thus, the sorting can be done in sql. However this
class is @since 1.4.

Attached is source code (based on HEAD) and test cases.