prepared statement batch insert

List<List<String>> rows = ordered list of values per row.

connection con.setAutoCommit(false);        
  PreparedStatement prepStmt = con.prepareStatement(    
    "insert statement for 1 row with exact ? for place holders");


for row in rows:
    for col_i in row.size:
        prepStmt.setString(col_i, row[col_i])

    prepStmt.addBatch()

int [] numInserts=prepStmt.executeBatch();

assert(numInsets and rows.size)

con.commit() (or rollback ...)