how to bind array to a prepared statement in JDBC
Posted on 2008-06-23
I have a SQL statement as such:
select * from User where usder_id IN (?)
I'm using the PreparedStatement class and I dont see an obvious wat to bind my java.util.List of ids.
The closest I found is PreparedStatement.setArray(index, java.sql.Array)
But it is not clear what implementation class I can use for that call (since java.sql.Arrayis an interface)
Please advise. thanks!