Might want to have a look at JDO or the database package provided by Expresso.
JDO: http://jcp.org/aboutJava/communityprocess/review/jsr012/index.html http://castor.exolab.org/index.html Expresso: http://www.jcorporate.com/econtent/Content.do?state=template&template=2&reso urce=636&db=default http://www.jcorporate.com/html/products/expresso/dbpooling.html HTH, robert > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul > Dlug > Sent: Wednesday, December 12, 2001 10:04 AM > To: [EMAIL PROTECTED] > Subject: Dynamic SQL query library > > > This is somewhat offtopic but definitely related to web development and > I'm sure someone on this list has run up against this issue before. > > I'm looking for a java library to generate dynamic SQL. Basically I want > the ability to do something like: > Query q = new Query(); > q.type(SELECT); > q.add("table1", "username", EQUALS, "john"); > q.add("table1", "added_date", LESS_THAN, new java.util.Date()); > Statement st = conn.createStatement(); > st.executeQuery(q.toString()); > > Or something just as easy to use as this, basically generating queries > without being locked into creating SQL statements by hand since they > could change at any time. I came across the org.apache.turbine.util.db > library from Turbine which seems to have what I'm looking for, but it's > too tightly coupled with Turbine. Ideally I need a library that is > general enough to use in any environment (why isn't there a Jakarta > Commons SQL Utils??), or something that can work hand in hand with > struts. Any advice greatly appreciated. > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
