import java.awt.event.*;
import java.sql.Connection;

import java.sql.Connection;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;

public class Connect implements ActionListener{

    private Display display;

    private String server, login, password, database, url;
    private int port;
    private Connection connection;

    public Connect(){}

    public void init() {
        display = new Display("Obsługa bazy danych", 600, 600);
        display.btnConnect.addActionListener(this);
    }


    @Override
    public void actionPerformed(ActionEvent e) {
        server = display.txtServer.getText();
        port = Integer.parseInt(display.txtPort.getText());
        login = display.txtSQLlogin.getText();
        password = String.valueOf(display.txtSQLpass.getPassword());
        database = display.txtDataBase.getText();
        url = String.format("jdbc:sqlserver://%s:%d;database=%s;user=%s;password=%s;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;", server, port,  database, login, password);
        connection = null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(url);
            String schema = connection.getSchema();
            System.out.println("Successful connection - Schema: " + schema);

            String selectSql = "tu bedzie select";

            try (Statement statement = connection.createStatement();
                 ResultSet resultSet = statement.executeQuery(selectSql)) {

                while (resultSet.next())
                {
                    //Wypisywanie
                }
                connection.close();
            }
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}