ControllerMain, Java

Language: Layout:

package Main;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.*;

import Edit.ControllerEdit;
import Storage.Storage;
import Storages.impls.CollectionStorages;
import TableLiterature.ControllerTableLiterature;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.scene.control.*;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.stage.Modality;
import javafx.stage.Stage;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ControllerMain {

private static final String url = "jdbc:mysql://localhost:3306/library";
    private static final String user = "root";
    private static final String password = "root";
    private static Connection con;
    private static Statement stmt;
    private static ResultSet rs;

private Stage mainStage;

private CollectionStorages collectionStorages = new CollectionStorages();

public static boolean crutch;
    public static boolean crutch2 = false;

@FXML
    private TableView main;

@FXML
    private MenuBar menu;

@FXML
    private TableColumn<Storage, Integer> columnId;

@FXML
    private TableColumn<Storage, String> columnLiterature;

@FXML
    private TableColumn<Storage, String> columnLibrary;

@FXML
    private Parent fxmlEdit;
    private Parent fxmlLiterature;
    private FXMLLoader fxmlLoader = new FXMLLoader();
    private FXMLLoader fxmlLoader2 = new FXMLLoader();
    private ControllerEdit controllerEdit;
    private ControllerTableLiterature controllerTableLiterature;
    private Stage editDialogStage;
    private Stage literatureDialogStage;

public void setMainStage(Stage mainStage) {this.mainStage = mainStage; }

@FXML
    public void initialize(){

String query ="SELECT * FROM storage, literature, libraries where Литература = id_Литературы AND Библиотека = id_Библиотеки";

try {
            // opening database connection to MySQL server
            con = DriverManager.getConnection(url, user, password);
            // getting Statement object to execute query
            stmt = con.createStatement();
            rs = stmt.executeQuery(query);
            while (rs.next()){
                Storage storage = new Storage();
                storage.setid(rs.getInt(1));
                storage.setLiterature(rs.getString(5));
                storage.setLibrary(rs.getString(8));
                collectionStorages.add(storage);
            }
        } catch (SQLException sqlEx) {
            sqlEx.printStackTrace();
        } finally {
            //close connection ,stmt and resultset here
            try { con.close(); } catch(SQLException se) { /*can't do anything */ }
            try { stmt.close(); } catch(SQLException se) { /*can't do anything */ }
            try { rs.close(); } catch(SQLException se) { /*can't do anything */ }
        }

columnId.setCellValueFactory(new PropertyValueFactory<Storage, Integer>("id"));
        columnLiterature.setCellValueFactory(new PropertyValueFactory<Storage, String>("Literature"));
        columnLibrary.setCellValueFactory(new PropertyValueFactory<Storage, String>("Library"));
        main.setItems(collectionStorages.getStorageList());

try {
            fxmlLoader.setLocation(getClass().getResource("../Edit/edit.fxml"));
            fxmlEdit = fxmlLoader.load();
            controllerEdit = fxmlLoader.getController();

} catch (IOException e) {
            e.printStackTrace();
        }
        try {
            fxmlLoader2.setLocation(getClass().getResource("../TableLiterature/tableLiterature.fxml"));
            fxmlLiterature = fxmlLoader2.load(); // ТУТ ОШИБКА
            controllerTableLiterature = fxmlLoader2.getController();
        } catch (IOException e) {
            e.printStackTrace();
        }

}

public void openLiterature(ActionEvent actionEvent){
        Stage stage = (Stage) menu.getScene().getWindow();
        stage.close();
        showLiterature();
    }

public void actionButtonPressed(ActionEvent actionEvent) throws IOException{
        Object source = actionEvent.getSource();

if (!(source instanceof Button)){
            return;
        }

Button clickedButton = (Button) source;

Storage selectedStorage = (Storage) main.getSelectionModel().getSelectedItem();

switch (clickedButton.getId()){

case "btnAdd":
                crutch = true;
                controllerEdit.setStorage(new Storage());
                collectionStorages.add(controllerEdit.getStorage());
                showDialog();
                break;

case "btnEdit":
                crutch = false;
                controllerEdit.setStorage(selectedStorage);
                controllerEdit.setStorage((Storage)main.getSelectionModel().getSelectedItem());
                showDialog();
                break;

case "btnDelete":
                try {
                    con = DriverManager.getConnection(url, user, password);
                    controllerEdit.setStorage(selectedStorage);
                    Storage storage = controllerEdit.getStorage();
                    String query2 = "DELETE FROM хранение WHERE Номер = " + storage.getid();
                    stmt = con.prepareStatement(query2);
                    stmt.executeUpdate(query2);
                } catch (SQLException e) {
                    e.printStackTrace();
                }

collectionStorages.delete((Storage)main.getSelectionModel().getSelectedItem());
                break;

case "btnExport":
                try {
                    con = DriverManager.getConnection(url, user, password);
                    String query = "SELECT * FROM хранение";
                    stmt = con.prepareStatement(query);
                    rs = stmt.executeQuery(query);

XSSFWorkbook wb = new XSSFWorkbook();
                    XSSFSheet sheet = wb.createSheet("Storages");
                    XSSFRow header = sheet.createRow(0);
                    header.createCell(0).setCellValue("Номенклатурный номер");
                    header.createCell(1).setCellValue("Название литературы");
                    header.createCell(2).setCellValue("Название библиотеки");
                    int index = 1;

while (rs.next()){
                        XSSFRow row = sheet.createRow(index);
                        row.createCell(0).setCellValue(rs.getInt("id"));
                        row.createCell(1).setCellValue(rs.getString("FIO"));
                        row.createCell(2).setCellValue(rs.getString("Phone"));
                        index++;
                    }

FileOutputStream fileOut = new FileOutputStream("Storages.xlsx");
                    wb.write(fileOut);
                    fileOut.close();

stmt.close();
                    rs.close();

} catch (SQLException e1) {
                    e1.printStackTrace();
                } catch (FileNotFoundException e1) {
                    e1.printStackTrace();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }

break;
        }

}

public void showDialog (){

if(editDialogStage==null){
            editDialogStage = new Stage();
            editDialogStage.setTitle("Редактировать");
            editDialogStage.setMinHeight(150.0D);
            editDialogStage.setMinWidth(300.0D);
            editDialogStage.setResizable(false);
            editDialogStage.setScene(new Scene(fxmlEdit));
            editDialogStage.initModality(Modality.WINDOW_MODAL);
            editDialogStage.initOwner(mainStage);
        }
        editDialogStage.showAndWait();
        main.refresh();
    }

public void showLiterature (){

if(literatureDialogStage==null){
            literatureDialogStage = new Stage();
            literatureDialogStage.setTitle("Список Литературы");
            literatureDialogStage.setMinHeight(450);
            literatureDialogStage.setMinWidth(500);
            literatureDialogStage.setResizable(true);
            literatureDialogStage.setScene(new Scene(fxmlLiterature, 1000, 500));
            literatureDialogStage.initModality(Modality.WINDOW_MODAL);
            literatureDialogStage.initOwner(mainStage);

}
        literatureDialogStage.show();
        main.refresh();
    }
}

[ + ] Show input
Compilation time: 1.25 sec, absolute service time: 1,31 sec