Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package GUIAdmin;
- import java.sql.CallableStatement;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javafx.geometry.Insets;
- import javafx.scene.control.Button;
- import javafx.scene.control.Label;
- import javafx.scene.control.ListView;
- import javafx.scene.control.TextField;
- import javafx.scene.layout.GridPane;
- import javafx.scene.text.Font;
- import storage.storage;
- public class InstruktorPane extends GridPane {
- private Button btnOpdaterInstruktor, btnOpretInstruktor, btnHentInstruktor, btnSletInstruktor;
- private final Label lblTextOpret, lblIdOpret, lblNavnOpret, lblAdresseOpret, lblTelefonOpret;
- private final Label lblTextOpdater, lblIdOpdater, lblNavnOpdater, lblAdresseOpdater, lblTelefonOpdater;
- private final Label lblInstruktorListe;
- private TextField txfIdOpret, txfNavnOpret, txfAdresseOpret, txfTelefonOpret;
- private TextField txfIdOpdater, txfNavnOpdater, txfAdresseOpdater, txfTelefonOpdater;
- private ListView<String> lvwInstruktorliste;
- storage storage = new storage();
- public InstruktorPane() {
- setPadding(new Insets(20));
- setHgap(20);
- setVgap(10);
- setGridLinesVisible(false);
- lblTextOpret = new Label("Opret ny instruktør - indtast data");
- lblTextOpret.setFont(Font.font("Verdana", 14));
- this.add(lblTextOpret, 0, 0, 2, 1);
- lblIdOpret = new Label("Id:");
- this.add(lblIdOpret, 0, 1);
- lblNavnOpret = new Label("Navn:");
- lblNavnOpret.setPrefWidth(100);
- this.add(lblNavnOpret, 0, 2);
- lblAdresseOpret = new Label("Adresse:");
- this.add(lblAdresseOpret, 0, 3);
- lblTelefonOpret = new Label("Telefonnummer:");
- this.add(lblTelefonOpret, 0, 4);
- // Knap
- btnOpretInstruktor = new Button("Opret");
- this.add(btnOpretInstruktor, 0, 5);
- btnOpretInstruktor.setOnAction(event -> OpretInstruktor());
- lblInstruktorListe = new Label("Liste over Instruktor");
- lblInstruktorListe.setFont(Font.font("Verdana", 14));
- this.add(lblInstruktorListe, 2, 0, 2, 1);
- lvwInstruktorliste = new ListView<String>();
- this.add(lvwInstruktorliste, 2, 1, 1, 5);
- lvwInstruktorliste.setPrefWidth(200);
- lvwInstruktorliste.setPrefHeight(100);
- // lvwInstruktorliste.getItems().setAll(storage.henInstruktor());
- txfIdOpret = new TextField();
- txfIdOpret.setPrefWidth(150);
- txfIdOpret.setEditable(true);
- this.add(txfIdOpret, 1, 1);
- txfNavnOpret = new TextField();
- txfNavnOpret.setPrefWidth(150);
- txfNavnOpret.setEditable(true);
- this.add(txfNavnOpret, 1, 2);
- txfAdresseOpret = new TextField();
- txfAdresseOpret.setPrefWidth(150);
- txfAdresseOpret.setEditable(true);
- this.add(txfAdresseOpret, 1, 3);
- txfTelefonOpret = new TextField();
- txfTelefonOpret.setPrefWidth(150);
- txfTelefonOpret.setEditable(true);
- this.add(txfTelefonOpret, 1, 4);
- lblTextOpdater = new Label("Opdater instruktør - indtast id og tryk hent");
- lblTextOpdater.setFont(Font.font("Verdana", 14));
- this.add(lblTextOpdater, 3, 0, 2, 1);
- lblIdOpdater = new Label("Id:");
- this.add(lblIdOpdater, 3, 1);
- lblNavnOpdater = new Label("Navn:");
- lblNavnOpdater.setPrefWidth(100);
- this.add(lblNavnOpdater, 3, 2);
- lblAdresseOpdater = new Label("Adresse:");
- this.add(lblAdresseOpdater, 3, 3);
- lblTelefonOpdater = new Label("Telefonnummer:");
- this.add(lblTelefonOpdater, 3, 4);
- // Knap
- btnHentInstruktor = new Button("Hent");
- this.add(btnHentInstruktor, 3, 5);
- btnHentInstruktor.setOnAction(event -> hentInstruktor());
- btnOpdaterInstruktor = new Button("Opdater");
- this.add(btnOpdaterInstruktor, 3, 6);
- btnOpdaterInstruktor.setOnAction(event -> OpdaterInstruktor());
- btnSletInstruktor = new Button("Slet");
- this.add(btnSletInstruktor, 3, 7);
- btnSletInstruktor.setOnAction(event -> sletInstruktor());
- txfIdOpdater = new TextField();
- txfIdOpdater.setPrefWidth(150);
- txfIdOpdater.setEditable(true);
- this.add(txfIdOpdater, 4, 1);
- txfNavnOpdater = new TextField();
- txfNavnOpdater.setPrefWidth(150);
- txfNavnOpdater.setEditable(true);
- this.add(txfNavnOpdater, 4, 2);
- txfAdresseOpdater = new TextField();
- txfAdresseOpdater.setPrefWidth(150);
- txfAdresseOpdater.setEditable(true);
- this.add(txfAdresseOpdater, 4, 3);
- txfTelefonOpdater = new TextField();
- txfTelefonOpdater.setPrefWidth(150);
- txfTelefonOpdater.setEditable(true);
- this.add(txfTelefonOpdater, 4, 4);
- }
- public void updateControls() {
- }
- public void OpretInstruktor() {
- try {
- Connection minConnection;
- minConnection = DriverManager.getConnection(
- "jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=YodaFit;user=sa;password=123123;");
- String id = txfIdOpret.getText();
- String navn = txfNavnOpret.getText();
- String adresse = txfAdresseOpret.getText();
- String telefon = txfTelefonOpret.getText();
- String sqlString = "insert into Instruktør values (?,?,?,?)";
- CallableStatement pre = minConnection.prepareCall(sqlString);
- pre.setString(1, id);
- pre.setString(2, navn);
- pre.setString(3, adresse);
- pre.setString(4, telefon);
- pre.execute();
- System.out.println("Instruktør Oprettet");
- pre.close();
- minConnection.close();
- } catch (SQLException e) {
- e.getMessage();
- e.getStackTrace();
- }
- }
- public void OpdaterInstruktor() {
- try {
- Connection minConnection;
- minConnection = DriverManager
- .getConnection(
- "jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=Yodafit;user=sa;password=123123;");
- Statement stmt = minConnection.createStatement();
- String id = txfIdOpdater.getText();
- String navn = txfNavnOpdater.getText();
- String adresse = txfAdresseOpdater.getText();
- String telefon = txfTelefonOpdater.getText();
- ResultSet res = stmt
- .executeQuery("exec updateInstruktør " + id + ", " + navn + ", " + adresse + ", " + telefon);
- if (res != null)
- res.close();
- if (stmt != null)
- stmt.close();
- if (minConnection != null)
- minConnection.close();
- } catch (SQLException e) {
- System.out.println("fejl: " + e.getMessage());
- }
- }
- public void sletInstruktor() {
- try {
- Connection min;
- min = DriverManager
- .getConnection(
- "jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=Yodafit;user=sa;password=123123;");
- Statement stmt = min.createStatement();
- String id = txfIdOpdater.getText();
- ResultSet res = stmt.executeQuery("exec sletInstruktør " + id);
- res.close();
- stmt.close();
- min.close();
- } catch (Exception e) {
- // TODO: handle exception
- }
- }
- public void hentInstruktor() {
- try {
- Connection minConnection;
- minConnection = DriverManager
- .getConnection(
- "jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=Yodafit;user=sa;password=123123;");
- Statement stmt = minConnection.createStatement();
- ResultSet res = stmt.executeQuery("exec hentInstruktør " + txfIdOpdater.getText());
- while (res.next()) {
- txfNavnOpdater.setText(res.getString(1));
- txfAdresseOpdater.setText(res.getString(2));
- txfTelefonOpdater.setText(res.getString(3));
- }
- } catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- }
- }
Add Comment
Please, Sign In to add comment