passing table names at runtime

[Shahabuddin Syed]

Hi,
the name of tables in the My database change at runtime so i want to pass the values of tables as parameters at runtime, i cannot do it with "PreparedStatement", is there any efficient way.
thanks in advance,
regards,
Shahabuddin.

[Avi Abrami]

Hi Shahabuddin,
As you have discovered, you cannot use the "?" parameter place-holders in a "PreparedStatement" for database table names (nor column names, for that matter), only for literal values (like strings, numbers, dates, etc.)
The only way is to build up the SQL string in your java class, for example (note: uncompiled and untested)

String tableName = "MY_TABLE";
String sqlQuery = "SELECT * FROM " + tableName;
Statement stmt = // ...
ResultSet rs = stmt.executeQuery(sqlQuery);

Good Luck,
Avi.