Пример #1
0
  public List<String> locateVendorsByPartialName(String name) {

    List<String> names = new ArrayList<>();
    try {
      List vendors =
          em.createNamedQuery("findVendorsByPartialName")
              .setParameter("name", name)
              .getResultList();
      for (Iterator iterator = vendors.iterator(); iterator.hasNext(); ) {
        Vendor vendor = (Vendor) iterator.next();
        names.add(vendor.getName());
      }
    } catch (Exception e) {
      throw new EJBException(e.getMessage());
    }
    return names;
  }
Пример #2
0
  public void createVendorPart(
      String partNumber, int revision, String description, double price, int vendorId) {
    try {
      PartKey pkey = new PartKey();
      pkey.setPartNumber(partNumber);
      pkey.setRevision(revision);

      Part part = em.find(Part.class, pkey);

      VendorPart vendorPart = new VendorPart(description, price, part);
      em.persist(vendorPart);

      Vendor vendor = em.find(Vendor.class, vendorId);
      vendor.addVendorPart(vendorPart);
      vendorPart.setVendor(vendor);
    } catch (Exception e) {
      throw new EJBException(e.getMessage());
    }
  }
Пример #3
0
  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();
  }