package databazy;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import javax.activation.DataSource;
import org.postgresql.ds.PGPoolingDataSource;
import org.postgresql.ds.PGSimpleDataSource;

public class Databazy {


    static DataSource getDataSource(){

        PGSimpleDataSource dataSource = new PGSimpleDataSource();
        dataSource.setServerName("db.ii.fmph.uniba.sk");
        dataSource.setPortNumber(5432);
        dataSource.setDatabaseName("db1");
        dataSource.setUser("brcko2@uniba.sk");
        dataSource.setPassword("db1brcko2");


        return (DataSource) dataSource;
    }

    public static void main(String[] args) throws SQLException {

        //DataSource data = getDataSource();

        String url = "jdbc:postgresql://db.ii.fmph.uniba.sk/db1";
        Properties prop = new Properties();
        prop.put("user","brcko2@uniba.sk");
        prop.put("password", "db1brcko2");

        try(Connection connection = DriverManager.getConnection(url, prop)) {
            Statement statement = connection.createStatement();
            ResultSet result = statement.executeQuery("SELECT * FROM employees");
            System.out.println("Fuck");
            while (result.next()){
                System.out.println(result);
            }
            statement.close();
        }
        catch(Exception e){
            e.printStackTrace();
        }
    }
}