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]); } } }