[dbutils] Support bean property to SQL IN parameter mapping

• Key: DBUTILS-29
• Type: Improvement
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Dan Fabulich
• Reporter: David Graham
• Affects Version/s: 1.0
• Fix Version/s: 1.2

Environment

Operating System: other
Platform: Other

Description

This commons-dev message brings up interesting points:
http://www.mail-archive.com/[e-mail]/msg36011.html

Providing a way to map bean properties to SQL IN parameters would round out the
bean functionality. We already have ResultSet columns being transferred to bean
properties; why not transfer the other way as well?

Comments

[Dan Fabulich]

DBUTILS-47 suggests a nice implementation for this using a StatementFiller interface.

DBUTILS-43 goes further and provides an implementation

[Henri Yandell]

svn ci -m "Merging in Dab Fabulich's work on https://svn.apache.org/repos/asf/commons/sandbox/dbutils/bugfixing from -r741987:747723. Resolving DBUTILS-34 - DBUTILS-37 - DBUTILS-29 - DBUTILS-14 - DBUTILS-31 - DBUTILS-39 - DBUTILS-41 - DBUTILS-44 - DBUTILS-33 - DBUTILS-42 - DBUTILS-40"

Sending pom.xml
Sending src/java/org/apache/commons/dbutils/BasicRowProcessor.java
Sending src/java/org/apache/commons/dbutils/BeanProcessor.java
Sending src/java/org/apache/commons/dbutils/QueryRunner.java
Adding src/java/org/apache/commons/dbutils/handlers/AbstractListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/ArrayListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/BeanListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/ColumnListHandler.java
Deleting src/java/org/apache/commons/dbutils/handlers/GenericListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/MapListHandler.java
Sending src/test/org/apache/commons/dbutils/BaseTestCase.java
Adding src/test/org/apache/commons/dbutils/QueryRunnerTest.java
Transmitting file data .........
Committed revision 747724.