|
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. |
