/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package lab_jdbc;


/**
 *
 * @author student
 */

    import java.sql.*;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;

public class Lab_JDBC {



    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws SQLException {
         Connection conn = null;
     Properties connectionProps = new Properties();
     connectionProps.put("user", "inf132224");
     connectionProps.put("password", "inf132224");
try{
         conn = DriverManager.getConnection(
"jdbc:oracle:thin:@//admlab2.cs.put.poznan.pl:1521/"
        + "dblab02_students.cs.put.poznan.pl",
         connectionProps);

     }
catch
 (SQLException ex) {
    Logger.getLogger(Lab_JDBC.class.getName()).log(Level.SEVERE,"nie udało się połączyć z bazą danych", ex);
         System.exit(-1);
     }
       System.out.println("Połączono z DB");

        Statement zad2 = null;
       //Statement stmt = null;
       //ResultSet rs = null;
       //ResultSet zad1 = null;
       ResultSet rzad2 = null;
       //stmt = conn.createStatement();

       zad2 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

     //  rs = stmt.executeQuery("SELECT ID_PRAC, RPAD(NAZWISKO,11), PLACA_POD FROM PRACOWNICY");
      /* while(rs.next()){
           System.out.println(rs.getInt(1)+ " "
                   + rs.getString(2) + " " +rs.getFloat(3));
            }*/


    /*    zad1 = stmt.executeQuery("SELECT (SELECT COUNT(NAZWISKO) FROM PRACOWNICY),COUNT(P.NAZWISKO),Z.NAZWA FROM PRACOWNICY P\n" +
"JOIN ZESPOLY Z ON P.ID_ZESP = Z.ID_ZESP\n" +
"GROUP BY Z.NAZWA");
        zad1.next();
        System.out.println("Zatrudniono "+ zad1.getInt(1) + "pracowników, w tym:\n");
        System.out.println(
        zad1.getInt(2) + " w zespole " +zad1.getString(3));
        while(zad1.next()){
           System.out.println(
                    zad1.getInt(2) + " w zespole " +zad1.getString(3));
            }*/
        rzad2 = zad2.executeQuery("SELECT nazwisko from pracownicy\n" +
"where etat = 'ASYSTENT'\n" +
"order by placa_pod desc");
        rzad2.last();
        System.out.println(rzad2.getString(1));
        rzad2.previous();
        rzad2.previous();
        System.out.println(rzad2.getString(1));
        rzad2.first();
        rzad2.next();
        System.out.println(rzad2.getString(1));

       //zad1.close();
       //rs.close();
       //stmt.close();
       rzad2.close();
        try {
            zad2.close();
            System.out.println("Rozłączono z DB");
        } catch (SQLException ex) {
            Logger.getLogger(Lab_JDBC.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

}