Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package javaapplication30;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javafx.application.Application;
- import static javafx.application.Application.launch;
- import javafx.scene.Scene;
- import javafx.scene.control.Button;
- import javafx.scene.control.Label;
- import javafx.scene.control.TextField;
- import javafx.scene.layout.GridPane;
- import javafx.stage.Stage;
- import javafx.scene.layout.VBox;
- import javafx.geometry.Pos;
- import javafx.scene.layout.HBox;
- import javafx.geometry.Insets;
- public class JavaApplication30 extends Application
- {
- @Override
- public void start(Stage stage)
- {
- GridPane okno= new GridPane();
- //panel lewy
- VBox panel_lewy=new VBox();
- // panel_lewy.setSpacing(50);
- // panel_lewy.setPadding(new Insets(5, 5, 5, 5));
- //
- panel_lewy.setMinWidth(200);
- panel_lewy.setAlignment(Pos.TOP_LEFT);
- panel_lewy.setStyle("-fx-stroke: green;\n" +
- " -fx-stroke-width: 5;\n" +
- " -fx-stroke-dash-array: 12 2 4 2;\n" +
- " -fx-stroke-dash-offset: 6;\n" +
- " -fx-stroke-line-cap: butt;");
- //
- okno.add(panel_lewy, 0, 0, 1, 4);
- HBox prawy= new HBox();
- prawy.setMinWidth(400);
- prawy.setAlignment(Pos.CENTER_LEFT);
- //prawy.setSpacing(50);
- //prawy.setPadding(new Insets(20, 5, 5, 5));
- okno.add(prawy,1,0,1,1);
- VBox pole_spr=new VBox();
- pole_spr.setMinWidth(400);
- pole_spr.setAlignment(Pos.TOP_LEFT);
- okno.add(pole_spr,1,1,1,1);
- //przyciski
- Button testBD2 = new Button("Dane");
- testBD2.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white; -fx-background-size: 1200 900;\n" +
- "-fx-background-radius: 30;\n" +
- "-fx-border-radius: 30;\n" +
- "-fx-border-width:5;\n" +
- "-fx-border-color: #FC3D44;");
- Button testBD1= new Button("Test");
- testBD1.getStyleClass().add("testBD1");
- testBD1.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white; -fx-background-size: 1200 900;\n" +
- "-fx-background-radius: 30;\n" +
- "-fx-border-radius: 30;\n" +
- "-fx-border-width:5;\n" +
- "-fx-border-color: #FC3D44;");
- panel_lewy.getChildren().addAll(testBD2, testBD1);
- //etykiety
- Label wynik=new Label("polaczono z baza danych");
- Label wynik2=new Label("polaczono z bd z pol formularza");
- Label err1= new Label("blad poloczenia");
- Label err2=new Label("blad sterownika");
- //przycisk "Lekarze"
- testBD2.setOnAction(e->
- {
- pole_spr.getChildren().clear();
- prawy.getChildren().clear();
- TextField loginField = new TextField();
- loginField.setMaxWidth(200);
- TextField hasloField = new TextField();
- hasloField.setMaxWidth(200);
- TextField bdField = new TextField();
- bdField.setMaxWidth(200);
- Label login= new Label("Login");
- Label haslo= new Label("Haslo");
- haslo.setPadding(new Insets(10, 0, 0, 0));
- Label bd= new Label("Nazwa bazy danych");
- bd.setPadding(new Insets(10, 0, 0, 0));
- prawy.getChildren().clear();
- VBox etykiety = new VBox();
- etykiety.getChildren().addAll(login,haslo,bd);
- VBox pola_txt = new VBox();
- pola_txt.getChildren().addAll(loginField,hasloField,bdField);
- Button spr=new Button("Sprawdz");
- pole_spr.getChildren().add(spr);
- prawy.getChildren().addAll(etykiety,pola_txt);
- spr.setOnAction(spr1->
- {
- prawy.getChildren().clear();
- pole_spr.getChildren().clear();
- Label loginWynik=new Label();
- loginWynik.setText(loginField.getText());
- String login1=loginWynik.getText();
- Label hasloWynik=new Label();
- hasloWynik.setText(hasloField.getText());
- String haslo1=hasloWynik.getText();
- Label bdWynik=new Label();
- bdWynik.setText(bdField.getText());
- String bd1=bdWynik.getText();
- Connection con;
- try{
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- con = DriverManager.getConnection("jdbc:sqlserver://"+
- "mssql.inf.ug.edu.pl:1401;databaseName=" +bd1+
- ";user="+login1+";password=" + haslo1+";");
- prawy.getChildren().add(wynik2);
- con.close();
- }
- catch(SQLException error_polaczenie) {
- prawy.getChildren().add(err1);
- }
- catch(ClassNotFoundException error_sterownik) {
- prawy.getChildren().add(err2);
- }
- });
- });
- //przycisk "testBD"
- testBD1.setOnAction(e->
- {
- prawy.getChildren().clear();
- pole_spr.getChildren().clear();
- Connection con;
- try{
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- con = DriverManager.getConnection("jdbc:sqlserver://"+
- "mssql.inf.ug.edu.pl:1401;databaseName=mdajnowicz;"+
- "user=mdajnowicz;password=253971;");
- prawy.getChildren().add(wynik);
- con.close();
- }
- catch(SQLException error_polaczenie) {
- okno.add(err1,1,0,1,1);
- }
- catch(ClassNotFoundException error_sterownik) {
- okno.add(err2,1,1,1,1);
- }
- }
- );
- Scene scena = new Scene(okno, 500,150);
- stage.setScene(scena);
- scena.getStylesheets().add("style.css");
- stage.show();
- }
- public static void main(String[] args)
- {
- launch(args);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement