I am looking for a Java applet that can allow my users to build SQL query
without knowing SQL. In other words, I am looking for an applet (commercial
or freeware) that will display table names and their fields and allow the
user to build a SELECT statement without knowing how. For example, a
drop-down menu can display a list of table names, another drop-down may
display table fields whenever the user selects a table from the first
drop-down table names menu. Then user can use the table fields to build the
query. User needs to be able to create query such as:
SELECT * FROM Table1 A Table1 B ... WHERE A.AGE>30 AND B.GENDER=Male
Also the applet needs to able call a back-end application to actually
perform the query via HTTP. For example, it can send the above statement to
an application via HTTP and display the #of row count to the user.
Any ideas if such applet exists? I am willing to pay someone to build
something like this. So quotes welcome.