Update on a list of POJOs -- what's the best approach?

[Karen Koch <km...@sbcglobal.net>]

I'm not quite certain how this problem is best approached using SQLMaps:

 

I want to implement a sort of "mass update" feature by which the database
records that correspond to objects in a java.util.List have 3 fields set.
All objects in the list will have the 3 fields set to the same 3 values.

 

Is my best bet in writing the statement itself, to pass the list in as the
parameter and then iterate over it to build a WHERE clause that uses IN ()?

 

Also, I haven't seen one, but is there a way to pass multiple parameters to
a statement?  Ideally, I want to pass the list itself and also a single
integer that will be used to update one of the three fields and look up the
values to update the other two fields.