//add the object to the list
ResultSet rs = ps.executeQuery();
while (rs.next()) {
DVD dvd = fetchEjb.GetSingleDvd(dbUrl, dbUsername, dbPassword, rs.getInt("itemId"));
Integer quantity = rs.getInt("quantity");
dvdList.add(new OrderLine(dvd, quantity));
}
}
return dvdList; //return the results
}
}