1 files changed, 83 insertions, 0 deletions
diff --git a/Java-Kompendium/kap17/src/main/java/ButtonAnzeigen.java b/Java-Kompendium/kap17/src/main/java/ButtonAnzeigen.java
new file mode 100644
index 0000000..5dff7da
--- /dev/null
+++ b/Java-Kompendium/kap17/src/main/java/ButtonAnzeigen.java
@@ -0,0 +1,83 @@
+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();
+            }
+        });
+    }
+}