@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");
}
}
