Tag: Builder

I am doing an application in Java and I used Scene Builder to create the graphical user interface.

My application saves employees. The new buttons for editing and deleting do their job. However, you save the changes in an XML file. I want you to connect to a database and save those changes to that database by inserting, changing, or deleting people in the application (using hibernation).

Next, I leave the interface controller code:

  package controlador.vista;

import javafx.collections.transformation.FilteredList;
import javafx.collections.transformation.SortedList;
import javafx.fxml.FXML;
import javafx.scene.control.Alert;
import javafx.scene.control.Alert.AlertType;
import javafx.scene.control.Label;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;

import controlador.MainApp;
import controlador.modelo.Persona;
import controlador.util.Fecha;

public class PersonaOverviewController {
    @FXML
    private TableView personTable;
    @FXML
    private TableColumn firstNameColumn;
    @FXML
    private TableColumn lastNameColumn;
    @FXML
    private Label firstNameLabel;
    @FXML
    private Label lastNameLabel;
    @FXML
    private Label hireDateLabel;
    @FXML
    private Label dniLabel;
    @FXML
    private Label diasLabel;
    @FXML
    private TextField buscar;

    // Reference to the main application.
    private MainApp mainApp;

    /**
     * The constructor.
     * The constructor is called before the initialize() method.
     */
    public PersonaOverviewController() {
    }

    /**
     * Initializes the controller class. This method is automatically called
     * after the fxml file has been loaded.
     */
    @FXML
    private void initialize() {
        // Initialize the person table with the two columns.
        firstNameColumn.setCellValueFactory(
                cellData -> cellData.getValue().firstNameProperty());
        lastNameColumn.setCellValueFactory(
                cellData -> cellData.getValue().lastNameProperty());

        // Clear person details.
        showPersonDetails(null);

        // Listen for selection changes and show the person details when changed.
        personTable.getSelectionModel().selectedItemProperty().addListener(
                (observable, oldValue, newValue) -> showPersonDetails(newValue));
    }

    /**
     * Is called by the main application to give a reference back to itself.
     *
     * @param mainApp
     */
    public void setMainApp(MainApp mainApp) {
        this.mainApp = mainApp;

        // Add observable list data to the table
        personTable.setItems(mainApp.getPersonData());
    }

    /**
     * Fills all text fields to show details about the person.
     * If the specified person is null, all text fields are cleared.
     *
     * @param persona the person or null
     */
    private void showPersonDetails(Persona persona) {
        if (persona != null) {
            // Fill the labels with info from the person object.
            firstNameLabel.setText(persona.getFirstName());
            lastNameLabel.setText(persona.getLastName());
            hireDateLabel.setText(Fecha.format(persona.getHireDate()));
            dniLabel.setText(persona.getDni());
            persona.diasVacaciones();
            diasLabel.setText(Double.toString(persona.getDias()));

        } else {
            // Person is null, remove all the text.
            firstNameLabel.setText("");
            lastNameLabel.setText("");
            hireDateLabel.setText("");
            dniLabel.setText("");
            diasLabel.setText("");
        }
    }


    /**
     * Called when the user clicks the new button. Opens a dialog to edit
     * details for a new person.
     */
    @FXML
    private void handleNewPerson() {
        Persona tempPerson = new Persona();
        boolean okClicked = mainApp.showPersonEditDialog(tempPerson);
        if (okClicked) {
            mainApp.getPersonData().add(tempPerson);
        }

    }

    /**
     * Called when the user clicks the edit button. Opens a dialog to edit
     * details for the selected person.
     */
    @FXML
    private void handleEditPerson() {

        Persona selectedPerson = personTable.getSelectionModel().getSelectedItem();
        if (selectedPerson != null) {
            boolean okClicked = mainApp.showPersonEditDialog(selectedPerson);
            if (okClicked) {
                showPersonDetails(selectedPerson);

            }

        } else {
            // Nothing selected.
            Alert alert = new Alert(AlertType.WARNING);
            alert.initOwner(mainApp.getPrimaryStage());
            alert.setTitle("Sin selección");
            alert.setHeaderText("Sin persona seleccionada");
            alert.setContentText("Por favor, selecciona una persona de la tabla.");

            alert.showAndWait();
        }

    }

    /**
     * Called when the user clicks on the delete button.
     */
    @FXML
    private void handleDeletePerson() {
        int selectedIndex = personTable.getSelectionModel().getSelectedIndex();
        if (selectedIndex >= 0) {
            personTable.getItems().remove(selectedIndex);

        } else {
            // Nothing selected.
            Alert alert = new Alert(AlertType.WARNING);
            alert.initOwner(mainApp.getPrimaryStage());
            alert.setTitle("Error de selecion");
            alert.setHeaderText("No se ha seleccionado ningun registro");
            alert.setContentText("Por favor, seleccione una persona de la tabla.");
            alert.showAndWait();
        }
    }
    @FXML
    private void handleGastarVacaciones() {
         Persona selectedPerson = personTable.getSelectionModel().getSelectedItem();
         if (selectedPerson != null) {
             boolean okClicked = mainApp.showPersonDiasDialog(selectedPerson);
             if (okClicked) {
                 showPersonDetails(selectedPerson);
             }

         } else {
             // Nothing selected.
             Alert alert = new Alert(AlertType.WARNING);
             alert.initOwner(mainApp.getPrimaryStage());
             alert.setTitle("Sin selección");
             alert.setHeaderText("Sin persona seleccionada");
             alert.setContentText("Por favor, selecciona una persona de la tabla.");

             alert.showAndWait();
         }
    }

    @FXML
    private void buscarDatos() {

        personTable.setItems(mainApp.getPersonData());

        FilteredList filteredData = new FilteredList<>(mainApp.getPersonData(), p -> true);

        buscar.textProperty().addListener((observable, oldValue, newValue) -> {
            filteredData.setPredicate(person -> {
                if (newValue == null || newValue.isEmpty()) {
                    return true;
                }

                String filtroMinuscula = newValue.toLowerCase();

                if (person.getFirstName().toLowerCase().indexOf(filtroMinuscula) != -1){
                    return true;
                }else if (person.getLastName().toLowerCase().indexOf(filtroMinuscula) != -1){
                    return true;
                }else if (person.getDni().toLowerCase().indexOf(filtroMinuscula) != -1){
                    return true;
                }else
                    return false;
            });
        });

        SortedList sortedData = new SortedList<>(filteredData);

        sortedData.comparatorProperty().bind(personTable.comparatorProperty());

        personTable.setItems(sortedData);
    }

}

I understand that in the new edit and delete buttons, I have to implement this change to the database with a type code:

SessionFactory factory = HibernateUtils.getSessionFactory();
                Session session = factory.openSession();

                   session.getTransaction().begin();
                   session.delete();
                   session.getTransaction().commit();

I've managed to put some occurrences of Persona in the database, but I do it when I initialize the app so that it contains some content when it starts. However, I want the changes to be made again, edited and deleted to affect the database, but I don't give the key on how to do it, can someone help me?

Thank you so much! If necessary, I can post more code if it helps.