import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Insets;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.ScrollPane;
import javafx.scene.layout.BorderPane;
import javafx.scene.layout.VBox;
import javafx.scene.text.Font;
import javafx.scene.text.FontWeight;
import javafx.scene.text.Text;
import javafx.stage.Stage;
import javafx.stage.Modality;
import java.sql.*;

public class ButtonAnzeigen extends Button {
    public ButtonAnzeigen(String text) {
        super(text);
    }

    public void neuesFenster(Stage hauptfenster) {
        String host = "jdbc:hsqldb:mem:mitarbeiter";
        String inhalt = "";

        try {
            Connection verbindung = DriverManager.getConnection(host);
            Statement befehl = verbindung.createStatement();

            String SQL = "SELECT * FROM Mitarbeiter";
            ResultSet rs = befehl.executeQuery(SQL);
            int zaehler = 0;
            while (rs.next()) {
                zaehler++;
                inhalt += "Personalnummer: " + rs.getString("persnr") + "\n";
                inhalt += "Nachname: " + rs.getString("name") + "\n";
                inhalt += "Vorname: " + rs.getString("vorname") + "\n";
                inhalt += "Gehalt: " + rs.getString("gehalt") + "\n\n";
            }
            if (zaehler == 0) {
                inhalt = "Keine Mitarbeiter vorhanden.";
            }
        } catch (SQLException err) {
            inhalt = err.getMessage();
        }
        VBox vbox = new VBox();
        Text titel = new Text("Ihr Personal:\n");
        titel.setFont(Font.font("Arial", FontWeight.NORMAL, 14));
        vbox.getChildren().add(titel);
        Text ausgabe = new Text(inhalt);
        vbox.getChildren().add(ausgabe);

        ScrollPane scrollPane = new ScrollPane(vbox);
        scrollPane.setFitToWidth(true);
        scrollPane.setPadding(new Insets(10));

        BorderPane root = new BorderPane(scrollPane);
        root.setPadding(new Insets(30));

        Button btn = new Button("OK");
        btn.setPadding(new Insets(5));
        VBox vbox2 = new VBox();
        vbox2.getChildren().add(btn);
        vbox2.setPadding(new Insets(0, 0, 0, 0));
        root.setBottom(vbox2);

        Stage neuesFenster = new Stage();
        neuesFenster.setTitle("Personal anzeigen");
        neuesFenster.initModality(Modality.WINDOW_MODAL);
        neuesFenster.initOwner(hauptfenster);
        neuesFenster.setX(hauptfenster.getX() + 50);
        neuesFenster.setY(hauptfenster.getY() + 50);
        Scene scene = new Scene(root, 400, 300);
        neuesFenster.setScene(scene);
        neuesFenster.show();

        btn.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent e) {
                neuesFenster.close();
            }
        });
    }
}