public static void main(String[] args) {
Datenbank db = new Datenbank();
String tmp[][] = db.executeCommandArray("SELECT * FROM Blackcards");
for (int i = 0; i < tmp.length; i++) {
for (int j = 0; j < tmp[i].length; j++) {
System.out.print(tmp[i][j] + " | ");
}
System.out.println();
}
// for (int i = 0; i < 275; i++) {
//
// System.out.println("ALT: " + db.executeCommandRAW("SELECT Text FROM Blackcards WHERE ID =
// " + i, 1));
//
// db.executeCommandNoReturn("UPDATE Blackcards SET Text = '" + (db.executeCommandRAW("SELECT
// Text FROM Blackcards WHERE ID = " + i, 1)) + "' WHERE ID = " + i);
//
// System.out.println("NEU: " + db.executeCommandRAW("SELECT Text FROM Blackcards WHERE ID =
// " + i, 1));
// }
// try {
// db.con.commit();
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
}
private void fillTable(String command) {
String content[][] = db.executeCommandArray(command);
String title[] = new String[content[0].length];
JOptionPane.showMessageDialog(
null,
command + " returned\n " + content.length + " results",
"Result",
JOptionPane.WARNING_MESSAGE); // warung das nur 8 custom tabellen möglich sind
for (int i = 0; i < title.length; i++) {
title[i] = "C" + i;
}
table = new JTable(content, title);
table.setEnabled(false);
}
@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]);
}
}
}
