@ Robat
die Variablen habe ich in der Klasse deklariert. Ich baue diese Tabelle:
[code=Java]
Object [][] werteL = new Object [][] {{"ka","bb","bw","sh","by","ni","nw","mv","rp","sn","st","th"}};
Object [] laender = new Object [] {"kA","BB","BW","SH","BY","NI","NW","MV","RP","SN","ST","TH"};
tblLand = new JTable();
tblml = new DefaultTableModel(werteL,laender);tblLand.setShowGrid(false);
tblLand.setModel(tblml);;
[/code]
und nach Klick auf einen Button soll sich das TableModel aktualisieren:
[code=Java]tblml = new DefaultTableModel(ladenAuswertung(),new String [] {"kA","BB","BW","SH","BY","NI","NW","MV","RP","SN","ST","TH"});[/code]
die Methode "ladenAuswertung()" die die Daten aktualisieren und in die Tabellenspalten setzen soll ist diese:
[code=Java]
private String [][] ladenAuswertung() {
Connection con = null;
try {
String dozent = boxDozentM.getSelectedItem().toString();
String kurs = boxKursM.getSelectedItem().toString();
String ort = boxOrtM.getSelectedItem().toString();
String datum = boxDatumM.getSelectedItem().toString();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/schulaus?user=root&password=#Patrick1");
// PreparedStatement pst = con.prepareStatement("select land, a1, a2, a3, a4, b1, b2, b3, c1, c1_txt, c2, c3, c4, c5, d1, d2, d3, d4_txt, d5_txt from fragen where dozent=? AND kurs=? AND ort=? AND datum=?");
PreparedStatement pst = con.prepareStatement("SELECT count(land) FROM fragen where dozent=? AND kurs=? AND ort=? AND datum =? ");
pst.setString(1, dozent);
pst.setString(2, kurs);
pst.setString(3, ort);
pst.setString(4, datum);
ResultSet rs1 = pst.executeQuery();
while (rs1.next()) {
ka = rs1.getString(1);
bb = rs1.getString(1);
bw = rs1.getString(1);
sh = rs1.getString(1);
by = rs1.getString(1);
ni = rs1.getString(1);
nw = rs1.getString(1);
mv = rs1.getString(1);
rp = rs1.getString(1);
sn = rs1.getString(1);
st = rs1.getString(1);
th = rs1.getString(1);
System.out.println(rs1.getString(1));
}
} catch (SQLException e) {
System.out.println(e);
e.printStackTrace();
}
return null;
}
[/code]
die Aufzählung [code=Java] ka = rs1.getString(1); bb = rs1.getString(1);[/code] etc. soll die ermittelten DB Werte in die JTable setzen
