once you create a PreparedStatement you can't change it. So if you have the PreparedStatement of "SELECT * from emp where empid in (?)", you can only substitute one value for the ?. There is no way (as of
jdbc 2.0) to substitute an array of values for a '?'. The only way you could work it would be to dynamically create the sql
String for each query(pretty much like using a Statement).
Probably not what you want to hear
maybe you can make up the performance by batching the Statements?
Jamie