blob: 5dff7da93808990af7173e89147c8c42cea0c087 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
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();
}
});
}
}
|
