Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package sample;
- 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.layout.GridPane;
- import javafx.scene.layout.HBox;
- import javafx.scene.layout.VBox;
- import javafx.stage.Stage;
- import java.sql.*;
- public class Main extends Application {
- Connection con;
- @Override
- public void start(Stage stage) {
- GridPane okno = new GridPane();
- //panel lewy
- VBox panel_lewy = new VBox();
- panel_lewy.setMinWidth(200);
- panel_lewy.setAlignment(Pos.TOP_LEFT);
- okno.add(panel_lewy, 0, 0, 1, 4);
- //panel prawy
- HBox prawy = new HBox();
- prawy.setMinWidth(400);
- prawy.setAlignment(Pos.TOP_LEFT);
- okno.add(prawy, 1, 0, 1, 1);
- //
- VBox kolumna1 = new VBox();
- //
- Label wynik = new Label("Połączono z bazą danych");
- Label err1 = new Label("Błąd połączenia z bazą danych");
- Label err2 = new Label("Błąd sterownika");
- //przyciski
- Button test = new Button("test");
- panel_lewy.getChildren().addAll(test);
- prawy.getChildren().addAll(kolumna1);
- //akcja przycisków
- test.setOnAction(e->{
- kolumna1.getChildren().clear();
- kolumna1.getChildren().clear();
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- con = DriverManager.getConnection("jdbc:sqlserver://"+
- "153.19.7.13:1401;databaseName=mrzeppa;"+
- "user=mrzeppa;password=253943;");
- kolumna1.getChildren().add(wynik);
- Statement query = con.createStatement();
- ResultSet resultSet = query.executeQuery("SELECT * FROM klient");
- ResultSetMetaData countCol = resultSet.getMetaData();
- kolumna1.getChildren().add(new Label("\nKlient:\n"));
- while (resultSet.next()) {
- StringBuilder sb = new StringBuilder("");
- sb.append(" | ");
- for (int i = 1; i <= countCol.getColumnCount(); i++) {
- sb.append(resultSet.getString(i));
- sb.append(" | ");
- }
- sb.append("\n");
- Label temp = new Label(sb.toString());
- kolumna1.getChildren().add(temp);
- }
- con.close();
- } catch (SQLException cerr) {
- kolumna1.getChildren().add(err1);
- cerr.printStackTrace();
- } catch (ClassNotFoundException derr) {
- kolumna1.getChildren().add(err2);
- derr.printStackTrace();
- }
- });
- //
- Scene scena = new Scene(okno, 800, 600);
- stage.setScene(scena);
- stage.show();
- }
- public static void main(String[] args) {
- launch(args);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement