1 files changed, 127 insertions, 0 deletions
diff --git a/Java-Kompendium/kap15/src/main/java/Marks.java b/Java-Kompendium/kap15/src/main/java/Marks.java
new file mode 100644
index 0000000..6ec6c06
--- /dev/null
+++ b/Java-Kompendium/kap15/src/main/java/Marks.java
@@ -0,0 +1,127 @@
+import javafx.application.Application;
+import javafx.geometry.Pos;
+import javafx.scene.Scene;
+import javafx.scene.control.Button;
+import javafx.scene.control.Label;
+import javafx.scene.control.Separator;
+import javafx.scene.control.TableColumn;
+import javafx.scene.control.TableView;
+import javafx.scene.control.TextField;
+import javafx.scene.control.cell.PropertyValueFactory;
+import javafx.scene.layout.GridPane;
+import javafx.scene.text.Text;
+import javafx.stage.Stage;
+import java.sql.*;
+
+public class Marks extends Application {
+    private GridPane grid;
+    private Text status;
+    private Connection connection;
+
+    @Override
+    public void start(Stage stage) {
+        this.grid = new GridPane();
+        this.createStatus();
+        this.createTable();
+        this.createForm();
+        this.createSearch();
+
+        this.grid.setVgap(5);
+        this.grid.setHgap(5);
+        this.grid.setAlignment(Pos.CENTER);
+
+        var scene = new Scene(this.grid, 500, 400);
+
+        stage.setScene(scene);
+        stage.setTitle("Noten von Schülern");
+        stage.show();
+    }
+
+    private void createStatus() {
+        this.status = new Text();
+
+        this.grid.add(this.status, 0, 0, 2, 1);
+    }
+
+    private void createSearch() {
+        var field = new TextField();
+        var button = new Button("Suchen");
+        var line = new Separator();
+        var table = new TableView<Mark>();
+
+        try {
+            var handler = new SearchAction(this.connection, this.status, field);
+            table.setItems(handler.getMarks());
+
+            var subjectColumn = new TableColumn<Mark, String>("Fach");
+            subjectColumn.setCellValueFactory(
+                new PropertyValueFactory<>("subject" /* handler.getMarks().get(0).subjectProperty().getName() */)
+            );
+
+            var markColumn = new TableColumn<Mark, Integer>("Note");
+            markColumn.setCellValueFactory(
+                new PropertyValueFactory<>("mark" /* handler.getMarks().get(0).markProperty().getName() */)
+            );
+            table.getColumns().setAll(subjectColumn, markColumn);
+
+            button.setOnAction(handler);
+        } catch (SQLException exception) {
+            this.status.setText(exception.getMessage());
+        }
+        line.setMinSize(10, 10);
+
+        this.grid.add(line, 0, 6, 2, 1);
+        this.grid.add(button, 0, 7);
+        this.grid.add(field, 1, 7);
+        this.grid.add(table, 0, 8, 2, 1);
+    }
+
+    private void createForm() {
+        var nameField = new TextField();
+        var nameLabel = new Label("Name");
+        var englishField = new TextField();
+        var englishLabel = new Label("Englisch");
+        var germanField = new TextField();
+        var germanLabel = new Label("Deutsch");
+        var mathField = new TextField();
+        var mathLabel = new Label("Mathematik");
+        var saveButton = new Button("Speichern");
+
+        try {
+            var action = new SaveAction(this.connection, nameField, englishField, germanField, mathField, this.status);
+            saveButton.setOnAction(action);
+        } catch (SQLException exception) {
+            this.status.setText(exception.getMessage());
+        }
+
+        this.grid.add(nameLabel, 0, 1);
+        this.grid.add(nameField, 1, 1);
+        this.grid.add(englishLabel, 0, 2);
+        this.grid.add(englishField, 1, 2);
+        this.grid.add(germanLabel, 0, 3);
+        this.grid.add(germanField, 1, 3);
+        this.grid.add(mathLabel, 0, 4);
+        this.grid.add(mathField, 1, 4);
+        this.grid.add(saveButton, 1, 5);
+    }
+
+    private void createTable() {
+        try {
+            var host = "jdbc:hsqldb:mem:mitarbeiter;shutdown=true";
+            this.connection = DriverManager.getConnection(host);
+            var statement = connection.createStatement();
+
+            statement.executeUpdate("""
+                CREATE TABLE IF NOT EXISTS marks (
+                    mark_id identity PRIMARY KEY,
+                    name VARCHAR,
+                    english integer,
+                    german integer,
+                    math integer
+                )
+            """);
+        } catch (SQLException exception) {
+            this.status.setText(exception.getMessage());
+        }
+    }
+}