That makes sense, and I don't have a strong feeling either way. Just thought it would be worth mentioning. Do we have a consensus that QueryRunner is a reasonable name?
Steven Caswell Sun Certified Java Programmer [EMAIL PROTECTED] a.k.a Mungo Knotwise of Michel Delving "One ring to rule them all, one ring to find them..." > -----Original Message----- > From: David Graham [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 30, 2003 9:07 AM > To: Jakarta Commons Developers List > Subject: RE: [dbutils] better name for QueryRunner? > > > > --- Steven Caswell <[EMAIL PROTECTED]> wrote: > > In the SQL world I grew up in, "query" was used loosely to mean any > > DML. I don't have a problem with QueryRunner, though I > wouldn't oppose > > StatementRunner. > > > > What if we took a different approach and split up the existing > > QueryRunner based on functionality: > > - Rename QueryRunner to StatementRunner, keeping the non-update and > > non-query > > methods > > - Move the query methods to a new QueryRunner class that extends > > StatementRunner > > - Move the update methods to a new UpdateRunner class that extends > > StatementRunner > > > > This gives good separation of concerns and resolves the > question about > > what is a "query". > > Not if you view executing all SQL statements as one concern. > The java.sql.Statement interface supports all kinds of SQL, > why shouldn't QueryRunner? DbUtils should be easy to use; > having to create multiple objects to run certain kinds of > queries is not easy. For example: > > QueryRunner run = new QueryRunner(dataSource); > run.query("SELECT...",handler); run.update("UPDATE..."); > > is much simpler than having to keep track of multiple objects > like this: > > StatementRunner run = new StatementRunner(dataSource); > run.query("SELECT...",handler); > > UpdateRunner run2 = new UpdateRunner(dataSource); > run2.update("UPDATE..."); > > The method names are self-explanatory enough that it's easy > to see what kind of SQL is being executed. > > David > > > > > Quoting "Shapira, Yoav" <[EMAIL PROTECTED]>: > > > > > > > > Howdy, > > > I thought in the SQL world, an update is just a specific type of > > query? > > > In that case QueryRunner is not so bad. StatementRunner > is not bad > > > either. StatementExecutor might be nice. > > > > > > Runner or Executor are too general IMHO. Executor is used by Doug > > Lea's > > > concurrent framework, so in JDK 1.5 there will be a > > > java.util.concurrent.Executor, and I'd like to avoid the small > > > chance > > of > > > name confusion. > > > > > > Yoav Shapira > > > Millennium ChemInformatics > > > > > > > > > >-----Original Message----- > > > >From: __matthewHawthorne [mailto:[EMAIL PROTECTED] > > > >Sent: Wednesday, October 29, 2003 12:44 PM > > > >To: Jakarta Commons Developers List > > > >Subject: [dbutils] better name for QueryRunner? > > > > > > > >Especially since it is such an integral class, could > > > >org.apache.commons.dbutils.QueryRunner use a more accurate name, > > since > > > >it performs both queries and updates? > > > > > > > ><brainstorm> > > > > Executor > > > > Runner > > > > StatementRunner > > > ></brainstorm> > > > > > > > >I can't think of any others. I have a similar class in my own > > > >stash that I named DatabaseHandler, but that doesn't seem to fit. > > > > > > > >Any other thoughts, suggestions? > > > > > > > > > > > > > > > > >------------------------------------------------------------------- > > > >-- > > > >To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > >For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > This e-mail, including any attachments, is a confidential > business > > > communication, and may contain information that is confidential, > > proprietary > > > and/or privileged. This e-mail is intended only for the > > > individual(s) > > to > > > whom it is addressed, and may not be saved, copied, printed, > > > disclosed > > or > > > used by anyone else. If you are not the(an) intended recipient, > > please > > > immediately delete this e-mail from your computer system > and notify > > the > > > sender. Thank you. > > > > > > > > > > -------------------------------------------------------------------- > > > - > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > Steven Caswell > > (Hobbit name Mungo Knotwise of Michel Delving) > [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > __________________________________ > Do you Yahoo!? > Exclusive Video Premiere - Britney Spears > http://launch.yahoo.com/promos/britneyspears/ > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
