Esempio n. 1
0
  // in this implementation, there is only one order per customer
  // the data model however allows for multiple orders per customer
  public CustomerOrder findByCustomer(int customerID) {
    Customer customer = customerFacade.find(customerID);
    CustomerOrder order = new CustomerOrder();
    Connection con = util.getConnection();
    String sql = "select * from customer_order where customer_id=?";

    PreparedStatement statement = null;
    try {
      statement = con.prepareStatement(sql);
      statement.setInt(1, customerID);

      ResultSet rs = statement.executeQuery();
      while (rs.next()) {
        order.setId(rs.getInt(1));
        order.setAmount(rs.getBigDecimal(2));
        order.setDateCreated(rs.getDate(3));
        order.setConfirmationNumber(rs.getInt(4));
        order.setCustomer(customer);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      if (statement != null) {
        try {
          statement.close();
        } catch (SQLException e) {
          e.printStackTrace();
        }
      }
    }
    return order;
    // return (CustomerOrder)
    // em.createNamedQuery("CustomerOrder.findByCustomer").setParameter("customer",
    // customer).getSingleResult();
  }
Esempio n. 2
0
  // overridden - refresh method called to retrieve order id from database
  public CustomerOrder find(int id) {
    // throw new RuntimeException();
    CustomerOrder order = new CustomerOrder();
    Connection con = util.getConnection();
    String sql = "select * from customer_order where ID=?";

    PreparedStatement statement = null;
    try {
      statement = con.prepareStatement(sql);
      statement.setInt(1, id);

      ResultSet rs = statement.executeQuery();
      while (rs.next()) {
        order.setId(id);
        order.setAmount(rs.getBigDecimal(2));
        order.setDateCreated(rs.getDate(3));
        order.setConfirmationNumber(rs.getInt(4));
        int customerId = rs.getInt(5);
        CustomerFacade customerFacade = new CustomerFacade();
        Customer customer = customerFacade.find(customerId);
        order.setCustomer(customer);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      if (statement != null) {
        try {
          statement.close();
        } catch (SQLException e) {
          e.printStackTrace();
        }
      }
    }
    return order;
    /*CustomerOrder order = em.find(CustomerOrder.class, id);
    em.refresh(order);
    return order;*/
  }