I've looked at these actually, but at this time I don't really want to delve into an Object -> Database mapping or object persistance. I just want a utility class to generate raw SQL statements. My biggest problem is not mapping the object to and from the database but generating 'search' type queries (letting the user specified a number of parameters and dynamically generating the query from them). The mapping is the easy part.
Robert Taylor wrote: > > 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
