Hi, I have a query (SELECT * FROM TESTTABLE WHERE ID IN (?)) and I want to pass in parameter a list of values (an array or something like that) to put in my condition IN. How can I do in java ? Is there something special in the PreparedStatement ? Or have I to use another statement or another type of query ? Thanks
posted 15 years ago
You can have an array object hold your variables. You can then use the prepared statement's setObject method to set it to the name of the array.
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley