コード例 #1
0
ファイル: CreditCardDAO.java プロジェクト: Sameow/simplyTECH
  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;
  }
コード例 #2
0
ファイル: CreditCardDAO.java プロジェクト: Sameow/simplyTECH
  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;
  }
コード例 #3
0
ファイル: LobbySuite.java プロジェクト: Sameow/simplyTECH
  /**
   * 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());
  }