Пример #1
0
  public int positionOfBlackcardardID(int id) {

    for (int i = 0; i < pnlEditBlackcards.getTable().getTable().getRowCount(); i++) {
      if (id
          == Integer.parseInt(
              pnlEditBlackcards.getTable().getTable().getModel().getValueAt(i, 0).toString())) {
        return i;
      }
    }

    //		System.out.println("positionOfBlackcardardID: KartenId nicht in DB -1 wird zurückgegeben um
    // fehler zu erzeugen");

    return -1;
  }
Пример #2
0
  private void displayPanel(MouseEvent e) { // steruunt anzeige der panles
    hidePanels(); // alle pnl ausblenen
    disselectRdbtn(); // alle rbtn zurücksetzen

    if (cardtypeFlag) { // true = Whitecard false = Blackcard
      if (e.getSource().equals(rdbtnAdd)) {
        pnlAddWhitecards.setVisible(true);
        rdbtnAdd.setSelected(true);
        setBounds(100, 100, 440, 300);
      } else if (e.getSource().equals(rdbtnEdit)) {
        pnlEditWhitecards.setVisible(true);
        rdbtnEdit.setSelected(true);
        setBounds(100, 100, 440, 600);
      } else if (e.getSource().equals(rdbtnDel)) {
        pnlDelWhitecards.setVisible(true);
        rdbtnDel.setSelected(true);
        setBounds(100, 100, 440, 600);
      }
    } else {
      if (e.getSource().equals(rdbtnAdd)) {
        pnlAddBlackcards.setVisible(true);
        rdbtnAdd.setSelected(true);
        setBounds(100, 100, 440, 300);
      } else if (e.getSource().equals(rdbtnEdit)) {
        pnlEditBlackcards.setVisible(true);
        rdbtnEdit.setSelected(true);
        setBounds(100, 100, 440, 600);
      } else if (e.getSource().equals(rdbtnDel)) {
        pnlDelBlackcards.setVisible(true);
        rdbtnDel.setSelected(true);
        setBounds(100, 100, 440, 600);
      }
    }
  }
Пример #3
0
 private void hidePanels() { // alle pnls ausblenen
   pnlAddWhitecards.setVisible(false);
   pnlAddBlackcards.setVisible(false);
   pnlEditWhitecards.setVisible(false);
   pnlEditBlackcards.setVisible(false);
   pnlDelWhitecards.setVisible(false);
   pnlDelBlackcards.setVisible(false);
 }
Пример #4
0
  public DBModify() {
    setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
    setBounds(100, 100, 440, 300);
    setVisible(true);
    setResizable(false);

    bg = new JPanel();
    setContentPane(bg);
    bg.setLayout(null);

    pnlOperation = new JPanel();
    pnlOperation.setBounds(10, 10, 415, 30);
    bg.add(pnlOperation);
    pnlOperation.setLayout(null);

    rdbtnAdd = new JRadioButton("ADD");
    rdbtnAdd.setBounds(5, 5, 55, 20);
    rdbtnAdd.addMouseListener(this);
    pnlOperation.add(rdbtnAdd);

    rdbtnDel = new JRadioButton("DEL");
    rdbtnDel.setBounds(200, 5, 55, 20);
    rdbtnDel.addMouseListener(this);
    pnlOperation.add(rdbtnDel);

    rdbtnEdit = new JRadioButton("EDIT");
    rdbtnEdit.setBounds(100, 5, 55, 20);
    rdbtnEdit.addMouseListener(this);
    pnlOperation.add(rdbtnEdit);

    tglbtnCards = new JToggleButton("Blackcard");
    tglbtnCards.setBounds(285, 5, 120, 25);
    tglbtnCards.addMouseListener(this);
    pnlOperation.add(tglbtnCards);

    btnConfirm = new JButton("Confirm Changes");
    btnConfirm.setBounds(10, 45, 415, 25);
    btnConfirm.addMouseListener(this);
    bg.add(btnConfirm);

    getContentPane().add(pnlAddWhitecards);
    pnlAddWhitecards.setVisible(false);
    getContentPane().add(pnlAddBlackcards);
    pnlAddBlackcards.setVisible(false);

    getContentPane().add(pnlEditWhitecards);
    pnlEditWhitecards.setVisible(false);
    getContentPane().add(pnlEditBlackcards);
    pnlEditBlackcards.setVisible(false);

    getContentPane().add(pnlDelWhitecards);
    pnlDelWhitecards.setVisible(false);
    getContentPane().add(pnlDelBlackcards);
    pnlDelBlackcards.setVisible(false);

    // listener auf objekte seteztebn
    pnlAddBlackcards.getBtnAdd().addMouseListener(this);
    pnlAddWhitecards.getBtnAdd().addMouseListener(this);
    pnlDelBlackcards.getBtnDelete().addMouseListener(this);
    pnlDelBlackcards.getTxtCardID().addKeyListener(this);
    pnlDelWhitecards.getBtnDelete().addMouseListener(this);
    pnlDelWhitecards.getTxtCardID().addKeyListener(this);
    pnlEditBlackcards.getBtnChange().addMouseListener(this);
    pnlEditBlackcards.getTxtCardID().addKeyListener(this);
    pnlEditWhitecards.getBtnChange().addMouseListener(this);
    pnlEditWhitecards.getTxtCardID().addKeyListener(this);
  }
Пример #5
0
  @Override
  public void keyReleased(
      KeyEvent e) { // listerner um in tablle selektierbe karte anzuzeuhen und hervor zu heben
    if (e.getSource().equals(pnlDelBlackcards.getTxtCardID())) {
      if (pnlDelBlackcards.getTxtCardID().getText().equals("") == false) {
        int tmp =
            positionOfBlackcardardID(Integer.parseInt(pnlDelBlackcards.getTxtCardID().getText()));

        pnlDelBlackcards.getTable().getTable().setRowSelectionInterval(tmp, tmp);
        pnlDelBlackcards
            .getTable()
            .getTable()
            .scrollRectToVisible(
                new Rectangle(
                    pnlDelBlackcards.getTable().getTable().getCellRect(tmp + 3, 0, false)));
      }
    } else if (e.getSource().equals(pnlDelWhitecards.getTxtCardID())) {
      if (pnlDelWhitecards.getTxtCardID().getText().equals("") == false) {
        int tmp =
            positionOfWhitecardardID(Integer.parseInt(pnlDelWhitecards.getTxtCardID().getText()));

        pnlDelWhitecards.getTable().getTable().setRowSelectionInterval(tmp, tmp);
        pnlDelWhitecards
            .getTable()
            .getTable()
            .scrollRectToVisible(
                new Rectangle(
                    pnlDelWhitecards.getTable().getTable().getCellRect(tmp + 3, 0, false)));
      }
    } else if (e.getSource().equals(pnlEditBlackcards.getTxtCardID())) {
      if (pnlEditBlackcards.getTxtCardID().getText().equals("") == false) {
        int tmp =
            positionOfBlackcardardID(Integer.parseInt(pnlEditBlackcards.getTxtCardID().getText()));

        pnlEditBlackcards.getTable().getTable().setRowSelectionInterval(tmp, tmp);
        pnlEditBlackcards
            .getTable()
            .getTable()
            .scrollRectToVisible(
                new Rectangle(
                    pnlEditBlackcards.getTable().getTable().getCellRect(tmp + 1, 0, false)));

        pnlEditBlackcards
            .getTxtFieldNewText()
            .setText(
                db.executeCommandArray(
                        "SELECT Text FROM Blackcards WHERE ID = "
                            + pnlEditBlackcards.getTxtCardID().getText())[0][0]);
        pnlEditBlackcards
            .getTxtCardsToSet()
            .setText(
                db.executeCommandArray(
                        "SELECT CardsToSet FROM Blackcards WHERE ID = "
                            + pnlEditBlackcards.getTxtCardID().getText())[0][0]);
        pnlEditBlackcards
            .getTxtChangeExpansion()
            .setText(
                db.executeCommandArray(
                        "SELECT Expansion FROM Blackcards WHERE ID = "
                            + pnlEditBlackcards.getTxtCardID().getText())[0][0]);
      }
    } else if (e.getSource().equals(pnlEditWhitecards.getTxtCardID())) {
      if (pnlEditWhitecards.getTxtCardID().getText().equals("") == false) {
        int tmp =
            positionOfWhitecardardID(Integer.parseInt(pnlEditWhitecards.getTxtCardID().getText()));

        pnlEditWhitecards.getTable().getTable().setRowSelectionInterval(tmp, tmp);
        pnlEditWhitecards
            .getTable()
            .getTable()
            .scrollRectToVisible(
                new Rectangle(
                    pnlEditWhitecards.getTable().getTable().getCellRect(tmp + 1, 0, false)));
        pnlEditWhitecards
            .getTxtFieldNewText()
            .setText(
                db.executeCommandArray(
                        "SELECT Text FROM Whitecards WHERE ID = "
                            + pnlEditWhitecards.getTxtCardID().getText())[0][0]);
        pnlEditWhitecards
            .getTxtChangeExpansion()
            .setText(
                db.executeCommandArray(
                        "SELECT Expansion FROM Whitecards WHERE ID = "
                            + pnlEditWhitecards.getTxtCardID().getText())[0][0]);
      }
    }
  }
Пример #6
0
  @Override
  public void mouseClicked(MouseEvent e) {
    if (e.getSource().equals(btnConfirm)) {
      try {
        int confirm =
            JOptionPane.showConfirmDialog(
                null,
                "WARNING: You can damage the GameDB!\nDo you want to continue? This can not be undone! ",
                "Confirm Changes to GameDB",
                JOptionPane
                    .YES_NO_OPTION); // bestätigungs dialog wenn änderungen gespeichernt werden
                                     // sollen
        if (confirm == JOptionPane.YES_OPTION) {
          db.getCon().commit(); //  änderungen in db spichern
        }

        dispose(); // fenster löscne
        new DBInterface(); // neues db interface öffnen

      } catch (SQLException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
      }
    } else if (e.getSource().equals(tglbtnCards)) { // tglbtn state ändern
      if (cardtypeFlag) {
        cardtypeFlag = false;
        tglbtnCards.setText("Blackcard");
      } else {
        cardtypeFlag = true;
        tglbtnCards.setText("Whitecard");
      }
      displayPanel(e);
    } else if (e.getSource().equals(rdbtnAdd)
        || e.getSource().equals(rdbtnEdit)
        || e.getSource()
            .equals(rdbtnDel)) { // wenn einer der dem rdbtn gedrückt pnl steuerung aufrufen
      displayPanel(e);
    } else if (e.getSource()
        .equals(
            pnlAddBlackcards
                .getBtnAdd())) { // prüfung auf btn in verschienden pnls und entprechenden befehle
                                 // ausfühen. änderungen erst nach commit dauerhaft gespeicert
      db.executeCommandNoReturn(
          "INSERT INTO Blackcards(Text , IsPlayable , CardsToSet, Expansion) VALUES ('"
              + pnlAddBlackcards.getTxtFieldText().getText()
              + "' ,  1 , "
              + pnlAddBlackcards.getTxtCardsToSet().getText()
              + ",'"
              + pnlAddBlackcards.getTxtExpansion().getText()
              + "'"
              + ");");
      //			System.out.println("pnlAddBlackcards.btnAdd");
    } else if (e.getSource().equals(pnlAddWhitecards.getBtnAdd())) {
      db.executeCommandNoReturn(
          "INSERT INTO Whitecards(Text , IsPlayable, Expansion) VALUES ('"
              + pnlAddWhitecards.getTxtFieldText().getText()
              + "' ,  1"
              + ",'"
              + pnlAddWhitecards.getTxtExpansion().getText()
              + "'"
              + ");");
      //			System.out.println("pnlAddWhitecards.btnAdd");
    } else if (e.getSource().equals(pnlDelBlackcards.getBtnDelete())) {
      db.executeCommandNoReturn(
          "DELETE FROM Blackcards WHERE ID = " + pnlDelBlackcards.getTxtCardID().getText());
      //			System.out.println("pnlDelBlackcards.btnDelete");
    } else if (e.getSource().equals(pnlDelWhitecards.getBtnDelete())) {
      db.executeCommandNoReturn(
          "DELETE FROM Whitecards WHERE ID = " + pnlDelWhitecards.getTxtCardID().getText());
      //			System.out.println("pnlDelWhitecards.btnDelete");
    } else if (e.getSource().equals(pnlEditBlackcards.getBtnChange())) {
      db.executeCommandNoReturn(
          "UPDATE Blackcards SET Text = '"
              + pnlEditBlackcards.getTxtFieldNewText().getText()
              + "', CardsToSet = "
              + pnlEditBlackcards.getTxtCardsToSet().getText()
              + ", Expansion = '"
              + pnlEditBlackcards.getTxtChangeExpansion().getText()
              + "' WHERE ID = "
              + pnlEditBlackcards.getTxtCardID().getText());
      //			System.out.println("pnlEditBlackcards.btnChange)");
    } else if (e.getSource().equals(pnlEditWhitecards.getBtnChange())) {
      db.executeCommandNoReturn(
          "UPDATE Whitecards SET Text = '"
              + pnlEditWhitecards.getTxtFieldNewText().getText()
              + "', Expansion = '"
              + pnlEditWhitecards.getTxtChangeExpansion().getText()
              + "' WHERE ID = "
              + pnlEditWhitecards.getTxtCardID().getText());
      //			System.out.println("pnlEditWhitecards.btnChange");
    }
  }