Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Database Connectivity >> Java Database Connectivity (JDBC)

Using variable value inplace of table name

Hi All, i am a newbie for this. Can u please guide?i have to use a value stored in a variable in place of the table name.tName= employee_tableInsert into "+tName+" values( ). Doing this gives an error. Ckeck for right syntax. Please helpThanks
[285 byte] By [javavoyagera] at [2007-11-27 1:56:14]
«« formating a password with special charactres (#$%&) for oracle
»» Verify a String is in the right format
# 1

This is where i want variable value in place of table name

sqlquery =("insert INTO "+tName+" (ASSET_GROUP,SERIAL_NO,SK_SERIALIZED_ITEM_LINK) VALUES('"+(String)new Vector((Vector)hashObj.get(vecKeys.elementAt(0))).elementAt(i)+"','"+(String)new Vector((Vector)hashObj.get(vecKeys.elementAt(1))).elementAt(i)+"','"+(String)new Vector((Vector)hashObj.get(vecKeys.elementAt(2))).elementAt(i)+"')");

st.executeUpdate(sqlquery);

i get the error check MYSQL syntax. Please help

javavoyagera at 2007-7-12 1:30:17 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
So the result of all those concatenations is an SQL statement. And your database tells you it's not valid SQL. So, seems to me that looking at the SQL statement would be a good start. Wouldn't you agree?
DrClapa at 2007-7-12 1:30:18 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
Database Connectivity
Java Database Connectivity (JDBC)

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified