by Hi.
I'm looking for a Java Query Builder component to use in an application I'm
developing at work. I expect it to cost some $, but it needs to be
royalty-free redistributable (i.e. we pay once but our customers don't.)
I'm hoping for the following, but would be willing to settle for less if
necessary. If you know of such a component, can you please let me know?
(remove the nospam. if you reply directly to me) Thanks much!
We'd like a graphical Query Builder component, written in Java, which allows
simple SQL select statements to be built for any JDBC data source. We're
hoping to see each table graphically with the ability to select columns to
include in the query. We'd like the user to be able to specify WHERE and
ORDER BY clauses in a Query By Example style. Joins may or may not be
necessary -- if the Query Builder happens to support them, great. Another
very-nice-to-have (borderline requirement) would be the ability to switch
between SQL view and Design view, with roundtrip modification (edit the
SQL -- the visual view changes accordingly, edit the visual view -- the SQL
changes accordingly.) Obviously, we'd need the ability to extract the SQL
statement when the query is built (if necessary, serialization to a file
which we can find would be okay.)
We could provide the JDBC connection to the Query Builder, or it could
capture the necessary information, load the driver and make the connection
itself.
Thanks for any help you can provide,
--Joe