Dynamic sql - table name, column name unknown

[Raj Puri]

Is there a way I can execute an insert like
insert into table_name(filed1, field2 ...)
values (vf1, vf2 ..)
Here everthing is variable. L like to pass table names, column names along with values to be inserted at runtime. I am writing a SQL that fits all table designs with primitive datatypes.

Any idea how to do it in JDBC?

[Avi Abrami]

Raj,
You need to build the [SQL] string in your java code.

If I understand your question correctly, you need to do something like the following:
[NOTE: Uncompiled and untested.]

String table_name = "MY_TABLE";
String columns = "field1,field2";
String sql = "insert into " + table_name + "(" + columns + ") values (?,?)";
Connection dbConn = // However you get it.
PreparedStatement ps = dbConn.prepareStatement(sql);
String vf1 = "Foo";
String vf2 = "Bar";
ps.setString(1, vf1);
ps.setString(2, vf2);
ps.executeUpdate();

Hope this helps clarify things for you.

Good Luck,
Avi.

[Raj Puri]

Thanks. I intend to use JSTL - c:query tag etc. Does that support this kind of dynamic sql, wher tablenames, colnames are unknown?

[Avi Abrami]

Raj,
You asked:

Does [JSTL] support this kind of dynamic sql

I don't know. I don't use JSTL. Try the JSP forum.

Good Luck,
Avi.