Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

PreparedStatement (passing in an Array)  RSS feed

 
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[])
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!