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]>
