• Post Reply Bookmark Topic Watch Topic
  • New Topic

PreparedStatement (passing in an Array)

 
keith tyson
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have an array of id's (Integer[] ids)
which I need to pass into the where clause of a prepared statement - but do not know how to match the java data type ([]) to the java SQL data type (Array?)
Any help would be much appreciated.
e.g. "select id, desc, qty
from xyz
where id = ? "
.. and I want to pass in an array of ids (Intger[])
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!