[
https://issues.apache.org/jira/browse/DBUTILS-124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16326934#comment-16326934
]
ASF GitHub Bot commented on DBUTILS-124:
----------------------------------------
Github user objectboy2016 commented on the issue:
https://github.com/apache/commons-dbutils/pull/3
**Why not design a named parameter**
such as:
string sql="select * from user where name=:name";
.......
runquery.addParameter("name","paul");
So simple and straightforward
No problem with the number, but the parameters of many will be a disaster
such as:
insert into a (a, b, c, d, f, g, i, e, g, k) values (?,?,?,?,?,?,?,?,?)
My eyes have been spent
> Introduce SPI to add more column, property handlers
> ---------------------------------------------------
>
> Key: DBUTILS-124
> URL: https://issues.apache.org/jira/browse/DBUTILS-124
> Project: Commons DbUtils
> Issue Type: New Feature
> Reporter: Carl Hall
> Assignee: Carl Hall
> Priority: Major
> Fix For: 1.7
>
>
> The column types and property types handled by {{BeanProcessor}} are hard
> coded to the processor. We already use a common return type, so we could add
> a services approach using the spi built into the jdk. This should also allow
> other types to be handled outside of {{commons-dbutils}}.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
