public String reportVendorsByOrder(Integer orderId) {
StringBuilder report = new StringBuilder();
try {
List vendors =
em.createNamedQuery("findVendorByOrder").setParameter("id", orderId).getResultList();
for (Iterator iterator = vendors.iterator(); iterator.hasNext(); ) {
Vendor vendor = (Vendor) iterator.next();
report
.append(vendor.getVendorId())
.append(' ')
.append(vendor.getName())
.append(' ')
.append(vendor.getContact())
.append('\n');
}
} catch (Exception e) {
throw new EJBException(e);
}
return report.toString();
}
