Habe die Methode jetzt wie folgt ergänzt:
[code=JAVA]
public void initialize(URL url, ResourceBundle rb) {
Connection c = null;
try {
Class.forName("org.sqlite.JDBC");
c = DriverManager.getConnection("jdbc:sqlite:test.db");
stat = con.createStatement();
//stat.executeUpdate("drop table if exists user");
stat.executeUpdate("create table if not exists user(ID varchar(50),Name varchar(50),Alter varchar(50),Addresse varchar(50),Gehalt varchar(50));");
data = FXCollections.observableArrayList();
ResultSet rs = con.createStatement().executeQuery("select * from user");
while (rs.next()) {
data.add(new UserData(rs.getString("ID"), rs.getString("Name"), rs.getString("Alter"), rs.getString("Addresse"), rs.getString("Gehalt")));
}
tableID.setCellValueFactory(new PropertyValueFactory("ID"));
tableName.setCellValueFactory(new PropertyValueFactory("Name"));
tableAlter.setCellValueFactory(new PropertyValueFactory("Alter"));
tableAddresse.setCellValueFactory(new PropertyValueFactory("Addresse"));
tableGehalt.setCellValueFactory(new PropertyValueFactory("Gehalt"));
tabelle.setItems(null);
tabelle.setItems(data);
} catch (Exception e) {
e.printStackTrace();
System.out.println("Error on Building Data");
}
}
[/code]
Leider bleibt die NullPointerException bei "stat = con.createStatement();" bestehen.
