// Frederik
public boolean insertOrders(ArrayList<Order> ol, Connection conn) throws SQLException {
int rowsInserted = 0;
String SQLString = "insert into orders values (?,?,?,?)";
PreparedStatement statement = null;
statement = conn.prepareStatement(SQLString);
for (int i = 0; i < ol.size(); i++) {
Order o = ol.get(i);
statement.setInt(1, o.getOID());
statement.setInt(2, o.getCID());
statement.setDate(3, o.getFromDate());
statement.setDate(4, o.getToDate());
rowsInserted += statement.executeUpdate();
}
System.out.println("insertOrders: " + (rowsInserted == ol.size()));
return (rowsInserted == ol.size());
}
