You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@commons.apache.org by "objectboy (JIRA)" <ji...@apache.org> on 2018/10/17 09:20:00 UTC

[jira] [Created] (DBUTILS-142) Why not design a named parameter?

objectboy created DBUTILS-142:
---------------------------------

             Summary: Why not design a named parameter?
                 Key: DBUTILS-142
                 URL: https://issues.apache.org/jira/browse/DBUTILS-142
             Project: Commons DbUtils
          Issue Type: Improvement
            Reporter: objectboy


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.

eager!!!!!!!!!!!!!!!!!!!!!!!



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)