Hi,

I'm reading a all files one after the other in a directory in java. storing the values in an array of string each time. Now I'm trying to execute a query to insert those values into an oracle DB. But I'm trying hard to figure out syntax for inserting into a table using variables. I'm trying to execute following command. Though I use executeQuery or udate Query it is not accepting as the format for them is executeQuery(String). My goal is to insert into Names Table values stored in temp[0] and temp[1]. In short I read values in array of temp, and I need to insert into DB using those variables, please give me proper syntax with quotation marks as I'm finding hard to make it. even the code i wrote below has some error with quotation marks. but i donno where to place them.


while((s3=reader.readLine())!=null){
String [] temp = null;
temp = s3.split(",");
statement.updateQuery("insert into Names values"+temp[0],""+temp[1]);

thanks,