Suggestion - simplify Layout a JSP page using radio buttons (Or's) and CheckBoxes (AND's) that coincide with the fields/values/whatever. If you can layout the page and make it simple, logical and functional, then you can write the qualifier class(es) to build your WHERE clauses. Swing is likely overkill.
Only a suggestion based on the K-I-S-S principle. :o) B ----- Original Message ----- From: "Howard Miller" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 12:57 PM Subject: RE: SQL Query Builder [Off Topic] > Mmm... I actually just need to build the "where" clause part. But I > need to give my users only the possible fields and values that are > available, yet let them have the opportunity in construction fairly > complex filters with multiple AND and OR and parenthesis. > > A general expression builder might do it with some modification. > > Howard > > > On 17 Sep 2002 at 12:29, Galbreath, Mark wrote: > > > yep - but I'd be willing to bet someone has written a Swing query engine. > > > > -----Original Message----- > > From: James Mitchell [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, September 17, 2002 12:10 PM > > To: Struts Users Mailing List > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > Isn't that only for Oracle? > > > > I was hoping to find an Open Source Swing alternative myself. > > > > > > > > James Mitchell > > Software Engineer\Struts Evangelist > > Struts-Atlanta, the "Open Minded Developer Network" > > http://www.open-tools.org/struts-atlanta > > > > > > > > > > > -----Original Message----- > > > From: Galbreath, Mark [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, September 17, 2002 12:01 PM > > > To: 'Struts Users Mailing List' > > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > > > > I use PL/SQL Developer 5.0. > > > > > > -----Original Message----- > > > From: James Mitchell [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, September 17, 2002 12:00 PM > > > To: Struts Users Mailing List > > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > > > > Well, I'm pretty proficient in sql. But for extremely complex > > > queries that > > > require multiple outer joins (like more than 8 tables), I rely on > > > the visual > > > query building capabilities of Visual Interdev (ya ya ya M$ sucks). > > > > > > I'd love to hear about any open source project that can do what Interdev > > > does: > > > > > > It gives you 4 panes. > > > 1. Tables > > > 2. Fields selected > > > 3. Sql used > > > 4. Results of query (if you run it) > > > > > > Truly wysiwyg, drop a new table in the table pane, and all panes are > > > updated. Modify the sql pane and all the other panes are updated as well. > > > > > > When you connect to an ODBC source (yes, this requires ODBC, but the sql > > > generated works regardless) you can just drag in all the tables you want. > > > Add filter params and order by, do grouping, sum, count, whatever. > > > > > > This also requires that you know your database relationships (to a certain > > > extent). Interdev will read the metadata off the connection and do a best > > > guess based on > > > > > > The reason I use Interdev is that it creates the vendor specific > > > sql syntax, > > > which can be different for Oracle vs. DB2 vs. MySql > > > > > > Then I just copy from the sql pane into my application (be it a resource > > > file or into the code) and I'm done. > > > > > > > > > > > > James Mitchell > > > Software Engineer\Struts Evangelist > > > Struts-Atlanta, the "Open Minded Developer Network" > > > http://www.open-tools.org/struts-atlanta > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Howard Miller [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, September 17, 2002 11:15 AM > > > > To: '[EMAIL PROTECTED]' > > > > Subject: SQL Query Builder [Off Topic] > > > > > > > > > > > > Hi, > > > > > > > > This is completely off-topic, and I'm sorry in advance, but > > > this is where > > > > all the usefull people live!!! > > > > > > > > Has anybody come accross a SQL query builder, or even query-by-example > > > > builder in java. That is something to visually put together a query for > > > > non-sql-savy users. Its to live in a Struts application, so must be > > > > Servlet/JSP/Applet based. > > > > > > > > Trying to save myself some work!! > > > > > > > > Howard Miller > > > > > > > > > > > > > > > > -- > > > > 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]> > > > > > > > > -- > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
