put Data from Vector into DB.

[tom1978]

Hi,
for my current application i want to add Data to a Database. This data is stored in a Vector. Does anyone have an idea, how to do with (eg. loop).
I would be very happy about a code sample.
Greetings tom

[tom1978]

Vector or Object[][] ( is as well possible)

[Chandresh Patel]

You can use Batch Inserts.

[Bill White]

// Create Connection and Statement object
Iterator iter = myVector.iterator();
while(iter.hasNext())
{
myObject = (MyObject)iter.next();
String sql = "whatever type of sql you need";
statement.addBatch(sql);
}
statement.executeBatch();