package javaapplication2;

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

/**
 *
 * @author bocinec3
 */
public class JavaApplication2 {

    public static void strankovanie(int strana,int pocetNaStranu ){

        String url = "jdbc:postgresql://db.ii.fmph.uniba.sk/db1";
        // Properties je mapa kluc->hodnota
        Properties properties = new Properties();
        properties.put("user", "bocinec3@uniba.sk");
        properties.put("password", "db1bocinec3");


      try(Connection connection = DriverManager.getConnection(url,properties)){
          System.out.println("som prihlaseny ");
          Statement statement = connection.createStatement();
          String query= "SELECT * from employees offset "+Integer.toString(strana*pocetNaStranu)+" limit "+Integer.toString(pocetNaStranu);
          ResultSet res = statement.executeQuery(query);
          while(res.next()){
              System.out.println(res.getString("first_name"));
          }

      }
      catch(Exception e){
          e.printStackTrace();
      }
      }
    public static void main(String[] args) throws SQLException {
        strankovanie(1,10);
    }

}