how can i query different tables using a parameterRow or through other methods?

Thread view:

Marcolm - 18 Jul 2004 20:44 GMT

hi,everyone
I'm new in java.
I want to query a table that depending on jdbTextField1.getText(). Tha
is to say the content of jdbTextField1.getText() is the name of table
want to query. I tried to used these SQL codes:
SELECT *
FROM :table_name;// table_name = jdbTextField1.getText()
But it doesn't work. Help~
-
Marcol
-----------------------------------------------------------------------

Reply to this Message

Roedy Green - 18 Jul 2004 20:56 GMT

>I want to query a table that depending on jdbTextField1.getText(). That
>is to say the content of jdbTextField1.getText() is the name of table i
>want to query. I tried to used these SQL codes:
>SELECT *
>FROM :table_name;// table_name = jdbTextField1.getText()
>But it doesn't work. Help~!

You will need something along this line:

String tableName = whichTable.getText();
String query = "SELECT * FROM " + tableName;

Signature

Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...