package db2;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DB2 {
    // uloha 3
    static void strankovanie(int strana, int naStranu) throws SQLException{
        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 con = DriverManager.getConnection(url, prop)){
            Statement stat1 = con.createStatement();
            //Statement stat2 = con.createStatement();

            stat1.executeQuery("SELECT import_company()");
            String sql = String.format("SELECT * FROM employees ORDER BY last_name OFFSET '%d' LIMIT '%d'", strana*naStranu, naStranu);
            ResultSet res = stat1.executeQuery(sql);

            while(res.next()){
                System.out.println(res.getObject("last_name"));
            }
            //ResultSet res2 = stat2.executeQuery("SELECT * FROM employees");

        }
    }

    // uloha 4
    static boolean porovnaj() throws SQLException {
        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 con = DriverManager.getConnection(url, prop)){

            Statement stat1 = con.createStatement();
            Statement stat2 = con.createStatement();

            stat1.executeQuery("SELECT import_company()");
            String sql1 = "SELECT * FROM employees ORDER BY last_name ";
            String sql2 = "SELECT * FROM employees ORDER BY last_name";
            ResultSet res1 = stat1.executeQuery(sql1);
            ResultSet res2 = stat2.executeQuery(sql2);
            ResultSetMetaData metaData1 = res1.getMetaData();


            if (metaData1.getColumnCount() != metaData2.getColumnCount())
                return false;


        }
        return false;
    }


    public static void main(String[] args) throws SQLException {
        System.out.println(porovnaj());
    }

}