Ejemplo n.º 1
0
  /**
   * Queries the given customer's orders.
   *
   * @param alias the customer alias
   * @param passwordHash the customer password-hash
   * @return the customer's orders
   * @throws IllegalStateException if the login data is invalid
   * @throws SQLException if there is a problem with the underlying JDBC connection
   */
  public SortedSet<Order> queryOrders(final String alias, final byte[] passwordHash)
      throws SQLException {
    final SortedSet<Order> orders = new TreeSet<Order>();
    final Customer customer = this.queryCustomer(alias, passwordHash);

    synchronized (this.connection) {
      try (PreparedStatement statement = this.connection.prepareStatement(SQL_SELECT_PURCHASES)) {
        statement.setLong(1, customer.getIdentity());

        try (ResultSet resultSet = statement.executeQuery()) {
          while (resultSet.next()) {
            final Order purchase = new Order();
            purchase.setIdentity(resultSet.getLong("identity"));
            purchase.setCustomerIdentity(resultSet.getLong("customerIdentity"));
            purchase.setCreationTimestamp(resultSet.getLong("creationTimestamp"));
            purchase.setTaxRate(resultSet.getDouble("taxRate"));
            orders.add(purchase);
          }
        }
      }
    }

    for (final Order purchase : orders) {
      this.populateOrderItems(purchase);
    }

    return orders;
  }
Ejemplo n.º 2
0
  /**
   * Queries the given customer's order with the given identity.
   *
   * @param alias the customer alias
   * @param passwordHash the customer password-hash
   * @param orderIdentity the order identity
   * @return the customer's order
   * @throws IllegalStateException if the login data is invalid
   * @throws SQLException if there is a problem with the underlying JDBC connection
   */
  public Order queryOrder(final String alias, final byte[] passwordHash, final long orderIdentity)
      throws SQLException {
    final Order order = new Order();
    final Customer customer = this.queryCustomer(alias, passwordHash);

    synchronized (this.connection) {
      try (PreparedStatement statement = this.connection.prepareStatement(SQL_SELECT_PURCHASE)) {
        statement.setLong(1, orderIdentity);

        try (ResultSet resultSet = statement.executeQuery()) {
          if (!resultSet.next()) throw new IllegalStateException("purchase doesn't exist.");
          if (customer.getIdentity() != resultSet.getLong("customerIdentity"))
            throw new IllegalStateException("purchase not created by given customer.");

          order.setIdentity(resultSet.getLong("identity"));
          order.setCustomerIdentity(resultSet.getLong("customerIdentity"));
          order.setCreationTimestamp(resultSet.getLong("creationTimestamp"));
          order.setTaxRate(resultSet.getDouble("taxRate"));
        }
      }
    }

    this.populateOrderItems(order);
    return order;
  }