This might help get you started:
It's a little hard to tell if this will satisfy your request, since you indicate that the SKU (int) and other values (
String) all come from an ArrayList, but in the method you show that the int values is being passed in separately from the ArrayList.
If the int value is being passed in via the ArrayList, it must either be coming across as a String (i.e., "123"), or an Integer (i.e., new Integer(123)).
Also, does the ArrayList contain information for only one entry, or does it contain multiple sets? If you have multiple sets, you'll need some sort of a "for" loop to process them all.
In either case, what I've given should help you get started. Whatever you put into an ArrayList will come out as an "Object" instance, and so much be cast to appropriate data type.
When setting the parameters of a PreparedStatement, the column values are 1-based, but the ArrayList indexes are 0-based.
[ March 31, 2004: Message edited by: Wayne L Johnson ]