Esempio n. 1
0
  public static boolean updateCreditCard(CreditCard cc, int ID) throws SQLException {
    String cardNumber = cc.getCardNumber();
    int expiryMonth = cc.getExpiryMonth();
    int expiryYear = cc.getExpiryYear();
    String expiryDate = cc.getExpiryDate();
    String cardHolderName = cc.getCardHolderName();
    String country = cc.getCountry();
    int CVC = cc.getCVC();
    String streetAddress = cc.getStreetAddress();
    String cardType = cc.getCardType();
    boolean success = false;
    DBController db = new DBController();
    String dbQuery =
        "UPDATE creditcard set CardNumber = '"
            + cardNumber
            + "',"
            + "ExpiryMonth='"
            + expiryMonth
            + "',ExpiryYear='"
            + expiryYear
            + "',"
            + "ExpiryDate='"
            + expiryDate
            + "',CardHolderName='"
            + cardHolderName
            + "',"
            + "Country='"
            + country
            + "',CVC='"
            + CVC
            + "',StreetAddress='"
            + streetAddress
            + "',"
            + "cardType='"
            + cardType
            + "'WHERE ID = '"
            + ID
            + "'";
    db.getConnection();

    if (db.updateRequest(dbQuery) == 1) {
      success = true;
    }
    db.terminate();
    return success;
  }
Esempio n. 2
0
  public static CreditCard searchById(int Id) {
    // Person person = null;
    Statement stmt = null;
    CreditCard creditCard = null;
    String searchQuery = "select * from creditcard where ID ='" + Id + "' ";

    try {
      // connect to DB
      currentCon = DBConnectionManager.getConnection();
      stmt = currentCon.createStatement();
      rs = stmt.executeQuery(searchQuery);
      boolean more = rs.next();

      // if user does not exist set the isValid variable to false
      if (!more) {
        System.out.println("member with the ID = " + Id + " does not exst");
      }

      // if user exists set the isValid variable to true
      else if (more) {

        int id = rs.getInt("id");
        String cardNumber = rs.getString("cardNumber");
        int expiryMonth = rs.getInt("expiryMonth");
        int expiryYear = rs.getInt("expiryYear");
        String expiryDate = rs.getString("expiryDate");
        String cardHolderName = rs.getString("cardHolderName");
        String country = rs.getString("country");
        int CVC = rs.getInt("CVC");
        String streetAddress = rs.getString("streetAddress");
        String cardType = rs.getString("cardType");

        creditCard = new CreditCard();
        creditCard.setId(id);
        creditCard.setCardNumber(cardNumber);
        creditCard.setExpiryMonth(expiryMonth);
        creditCard.setExpiryYear(expiryYear);
        creditCard.setExpiryDate(expiryDate);
        creditCard.setCountry(country);
        creditCard.setCVC(CVC);
        creditCard.setStreetAddress(streetAddress);
        creditCard.setCardType(cardType);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      if (rs != null) {
        try {
          rs.close();
        } catch (Exception e) {
        }
        rs = null;
      }

      if (stmt != null) {
        try {
          stmt.close();
        } catch (Exception e) {
        }
        stmt = null;
      }

      if (currentCon != null) {
        try {
          currentCon.close();
        } catch (Exception e) {
        }

        currentCon = null;
      }
    }

    return creditCard;
  }
Esempio n. 3
0
  public static boolean createCreditCard(CreditCard cc) throws SQLException {
    int id = 0;
    Statement stmt = null;
    Connection con = null;
    con =
        DriverManager.getConnection(
            "jdbc:mysql://localhost:8888/simplytech", "simplyTECH", "hahaudie");
    stmt = con.createStatement();
    String query = "SELECT MAX(ID) FROM person";
    ResultSet rs = stmt.executeQuery(query);
    while (rs.next()) {
      id = rs.getInt("MAX(ID)");
    }
    String cardNumber = cc.getCardNumber();
    int expiryMonth = cc.getExpiryMonth();
    int expiryYear = cc.getExpiryYear();
    String expiryDate = cc.getExpiryDate();
    String cardHolderName = cc.getCardHolderName();
    String country = cc.getCountry();
    int CVC = cc.getCVC();
    String streetAddress = cc.getStreetAddress();
    String cardType = cc.getCardType();

    boolean success = false;
    DBController db = new DBController();

    String dbQuery =
        "INSERT INTO creditcard (ID,CardNumber,ExpiryMonth,ExpiryYear,ExpiryDate,CardHolderName,Country,"
            + "CVC,StreetAddress,CardType) VALUES ('"
            + id
            + "','"
            + cardNumber
            + "','"
            + expiryMonth
            + "','"
            + expiryYear
            + "','"
            + expiryDate
            + "','"
            + cardHolderName
            + "','"
            + country
            + "','"
            + CVC
            + "','"
            + streetAddress
            + "','"
            + cardType
            + "')";
    if (db.updateRequest(dbQuery) == 1) {
      success = true;
    }
    if (rs != null) {
      try {
        rs.close();
      } catch (Exception e) {
      }
      rs = null;
    }

    if (stmt != null) {
      try {
        stmt.close();
      } catch (Exception e) {
      }
      stmt = null;
    }

    if (currentCon != null) {
      try {
        currentCon.close();
      } catch (Exception e) {
      }

      currentCon = null;
    }
    return success;
  }
Esempio n. 4
0
  /**
   * This method initializes this
   *
   * @return void
   */
  private void initialize() {
    card = CreditCardDAO.searchById(MainFrame.getPersonWhoLogin().getId());
    cardNumber = card.getCardNumber() + "";
    cardType = card.getCardType();
    membership = MainFrame.getPersonWhoLogin().getMembership();
    points = MainFrame.getPersonWhoLogin().getPoints();
    jLabelCard = new JLabel();
    jLabelCard.setText("Card:");
    jLabelCard.setPreferredSize(new Dimension(80, 24));
    jLabelCard.setBounds(new Rectangle(30, 190, 80, 24));
    jLabelCard.setFont(new Font("Arial", Font.BOLD, 18));
    jLabelPoints = new JLabel();
    jLabelPoints.setFont(new Font("Arial", Font.BOLD, 18));
    jLabelPoints.setBounds(new Rectangle(30, 280, 120, 24));
    jLabelPoints.setText("Points:");
    jLabelMembership = new JLabel();
    jLabelMembership.setText("Membership:");
    jLabelMembership.setFont(new Font("Arial", Font.BOLD, 18));
    jLabelMembership.setBounds(new Rectangle(30, 370, 160, 23));
    jLabelMembership.setPreferredSize(new Dimension(200, 29));
    jLabelName = new JLabel();
    jLabelName.setFont(new Font("Arial", Font.BOLD, 18));
    jLabelName.setBounds(new Rectangle(30, 100, 80, 20));
    jLabelName.setText("Name:");
    jLabelHowMayIServeYou = new JLabel();
    jLabelHowMayIServeYou.setText("How May I Serve You?");
    jLabelHowMayIServeYou.setFont(new Font("Arial", Font.PLAIN, 18));
    jLabelHowMayIServeYou.setFont(new Font("Arial", Font.BOLD, 24));
    jLabelHowMayIServeYou.setBounds(new Rectangle(98, 45, 280, 32));
    this.setSize(1024, 600);
    this.setLayout(null);
    this.setBackground(new Color(227, 228, 250));
    this.setFont(new Font("Dialog", Font.PLAIN, 12));
    this.add(getJButtonLogout(), null);
    this.add(getPanel1(), null);
    this.add(jLabelHowMayIServeYou, null);
    this.add(jLabelName, null);
    this.add(jLabelMembership, null);
    this.add(jLabelPoints, null);
    this.add(jLabelCard, null);
    this.add(getJButtonOrchid(), null);
    this.add(getJButtonGold(), null);
    this.add(getJButtonSands(), null);
    this.add(getJButtonDeluxe(), null);
    this.add(getJButtonPresidential(), null);
    this.add(getJButtonMembership1(), null);

    JLabel displayName = new JLabel("");
    displayName.setFont(new Font("Calibri", Font.PLAIN, 24));
    displayName.setBounds(53, 131, 187, 31);
    displayName.setText(MainFrame.getPersonWhoLogin().getName());
    add(displayName);

    JLabel displayCard = new JLabel("");
    displayCard.setFont(new Font("Calibri", Font.PLAIN, 24));
    displayCard.setBounds(53, 225, 235, 31);
    displayCard.setText(
        cardType
            + " XXX-"
            + cardNumber.charAt(12)
            + cardNumber.charAt(13)
            + cardNumber.charAt(14)
            + cardNumber.charAt(15));
    add(displayCard);
    add(getDisplayPts());
    add(displayMembership());
  }