How to refresh a TableView after updating it from another scene (and another controller)?

Question

I have a TableView that contains entries from a database and a separate window for entering a new entry with a separate controller. The problem is that when I add a record to the database, the table scene controller doesn't know that there has been a change and the TableView is only updated after the application is restarted. How to create this connection between the controllers so that the TableView is updated immediately?

Main class.

public class ExampleApplication extends Application {

    @Override
    public void start(Stage stage) throws IOException {
        FXMLLoader fxmlLoader = new FXMLLoader(HelloApplication.class.getResource("tableView.fxml"));
        Scene scene = new Scene(fxmlLoader.load(), 700, 400);
        stage.setTitle("ExampleApp");
        stage.setScene(scene);
        stage.show();
    }

    public static void main(String[] args) {
        launch();

    }
}

Scene controller with a table where entries are displayed.

public class TableController {

    @FXML
    private Button addEntryButton;

    @FXML
    private TableColumn entryColumn;

    @FXML
    private TableView table;

    ObservableList userEntries = FXCollections.observableArrayList();

    @FXML
    private void initialize() {
        table.getItems().clear();
        getAllEntriesFromDbToList();
        entryColumn.setCellValueFactory(new PropertyValueFactory("entryName"));
        table.setItems(userEntries);

        addEntryButton.setOnAction(event -> {
            openNewScene("/com/example/addNewEntryDialogue.fxml");
        });
    }

    private void getAllEntriesFromDbToList() {
        ResultSet rs = new DatabaseHandler().getEntriesTableFromDb();
        try {
            while (rs.next()) {
                userEntries.add(new userEntry(rs.getString("entryName")
                ));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }


    private void openNewScene(String window) {
        FXMLLoader loader = new FXMLLoader();
        loader.setLocation(getClass().getResource(window));

        try {
            loader.load();
        } catch (IOException e) {
            e.printStackTrace();
        }

        Parent root = loader.getRoot();
        Stage stage = new Stage();
        stage.setScene(new Scene(root));
        stage.show();
    }

}

Dialog window controller for adding a new entry.

public class DialogueController {

    @FXML
    private Button inputNewEntryCancelButton;

    @FXML
    private Button inputNewEntryOkButton;

    @FXML
    private TextField inputNewEntryTextField;

    @FXML
    void initialize() {
        inputNewEntryOkButton.setOnAction(event -> {
            addNewEntryToDbTable(inputNewEntryTextField.getText());
            ((Node) event.getSource()).getScene().getWindow().hide();
        });

        inputNewEntryCancelButton.setOnAction(event -> {
            ((Node) event.getSource()).getScene().getWindow().hide();
        });
    }

    private void addNewEntryToDbTable(String entryName) {
        DatabaseHandler dbHandler = new DatabaseHandler();
        userEntry newEntry = new userEntry(entryName);
        dbHandler.addEntryToDb(newEntry);
    }
}

Model. Entry class.

public class userEntry {

    private String entryName;

    public userEntry(String entryName) {
        this.entryName = entryName;
    }
    
    public String getEntryName() {
        return entryName;
    }

    public void setEntryName(String entryName) {
        this.entryName = entryName;
    }
}

Model. Data base handler class.

public class DatabaseHandler extends Configs {

    Connection dbConnection;

    public Connection getDbConnection() throws ClassNotFoundException, SQLException {
        String connectionString = "jdbc:mysql://" + dbHost + ":" + dbPort + "/" + dbName;
        Class.forName("com.mysql.cj.jdbc.Driver");
        dbConnection = DriverManager.getConnection(connectionString, dbUser, dbPass);

        return dbConnection;
    }

    public void addEntryToDb(userEntry task) {
        String insert = "INSERT INTO " + Const.ENTRIES_TABLE + "(" +
                Const.ENTRIES_ENTRY_NAME + ")" +
                "VALUES(?)";
        try {
            PreparedStatement prSt = getDbConnection().prepareStatement(insert);
            prSt.setString(1, task.getEntryName());

            prSt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }


    public ResultSet getEntriesTableFromDb() {
        ResultSet resSet = null;
        String select = "SELECT * FROM " + Const.ENTRIES_TABLE;
        try {
            resSet = getDbConnection().createStatement().executeQuery(select);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        return resSet;
    }
}

View. Table scene FXML. (tableView.fxml)

View. Dialog scene FXML. (addNewEntryDialogue.fxml)

How to refresh a TableView after updating it from another scene (and another controller)?

Answers (1)

Related Questions