QueryRunner has a protected prepareStatement method that can be overridden with custom handling:
http://jakarta.apache.org/commons/dbutils/xref/org/apache/commons/dbutils/QueryRunner.html#140 DbUtils isn't about modeling various SQL components as objects. IMO, the real benefit of using DbUtils is the automatic resource cleanup. Since you are handling Connection and Statement objects outside of DbUtils, the library can't clean them up for you. You could handle the resource cleanup yourself (not use QueryRunner) and still use BasicRowProcessor to process ResultSets into objects. David --- Oliver Heger <[EMAIL PROTECTED]> wrote: > Hello, > > I am working on a kind of SQL SELECT generator library. The basic idea > is that you have an object representing the query to be performed. You > add objects for the fields to be retrieved and feed it with condition > objects. Finally it returns a fully initialized PreparedStatement > object. > > I would now like to use [dbutils] to execute the queries, but I have the > > problem that none of the query() methods of QueryRunner really fits my > needs because I have already a PreparedStatement. To solve this, would > it be possible to introduce a Query interface in [dbutils], which could > look as follows: > > public interface Query { > PreparedStatement getStatement(Connection conn) throws SQLException; > } > > Then there could be an additional query() method in QueryRunner that > expects such a Query object as argument. It would fetch the statement > from this object and execute it. > > I know that you try to keep [dbutils] small. This interface would not > really add new functionality to this component, but may extent its > usage. What do you think? > > If there is interest, I can try to provide a patch. > > Regards > Oli > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
