jdbc1

/*
 * 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 jdbc;

/**
 *
 * @author student
 */
import java.sql.*;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;

public class JDBC {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws SQLException {
        // TODO code application logic here

Connection conn = null;
Properties connectionProps = new Properties();
connectionProps.put("user", "inf132274");
connectionProps.put("password", "pawelek");
 try {
    conn = DriverManager.getConnection("jdbc:oracle:thin:@//admlab2.cs.put.poznan.pl:1521/"+"dblab02_students.cs.put.poznan.pl", connectionProps);
    System.out.println("Połączono z bazą danych");
 } catch (SQLException ex) {
    Logger.getLogger(JDBC.class.getName()).log(Level.SEVERE,"nie udało się połączyć z bazą danych", ex);
    System.exit(-1);
}

 Statement stmt;
 stmt = conn.createStatement();
 ResultSet rs;
 rs = stmt.executeQuery("SELECT id_prac , RPAD(nazwisko,15) , placa_pod FROM pracownicy");

 while(rs.next()){
     System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getFloat(3));
 }

 rs.close();
 stmt.close();

        System.out.println(" ");
 //-------------------ZAD1---------------

 Statement zad1;
 zad1 = conn.createStatement();
 ResultSet rezad1;
 rezad1 = zad1.executeQuery("SELECT  (SELECT COUNT(DISTINCT nazwisko) FROM PRACOWNICY) , zespoly.nazwa , count(*) as liczba\n" +
                            "FROM PRACOWNICY JOIN zespoly ON zespoly.id_zesp = pracownicy.id_zesp\n" +
                            "GROUP BY zespoly.nazwa");
 rezad1.next();
 System.out.println("Zatrudniono " + rezad1.getInt(1) + " pracowników, w tym:");
 System.out.println("  " + rezad1.getInt(3) + " w zespole " + rezad1.getString(2));

 while(rezad1.next()){
      System.out.println("  " + rezad1.getInt(3) + " w zespole " + rezad1.getString(2));
 }

 rezad1.close();
 zad1.close();

 System.out.println("");
 //-----------------ZAD2-----------------
 Statement zad2;
 zad2 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE , ResultSet.CONCUR_READ_ONLY);
 ResultSet rezad2;
 rezad2 = zad2.executeQuery("SELECT nazwisko\n" +
                            "FROM pracownicy JOIN zespoly ON zespoly.id_zesp = pracownicy.id_zesp\n" +
                            "WHERE etat = 'ASYSTENT'\n" +
                            "ORDER BY placa_pod DESC");

 rezad2.afterLast();
 rezad2.previous();

 System.out.println("Najmniej zarabia " + rezad2.getString(1));

 rezad2.previous();
 rezad2.previous();
 System.out.println("Trzeci najmniej zarabiający to " + rezad2.getString(1));

 rezad2.afterLast();
 rezad2.previous();
 rezad2.previous();
 System.out.println("Przedostatni to " + rezad2.getString(1));

 rezad2.close();
 zad2.close();

 //-------------------ZAD3---------------
 int [] zwolnienia= {150, 200, 230};
 String [] zatrudnienia= {"Kandefer", "Rygiel", "Boczar"};
 int [] noweId = {250 , 260 , 270};



 try {
     conn.close();
     System.out.println("\nRozłączono z bazą danych");
 } catch (SQLException ex) {
     Logger.getLogger(JDBC.class.getName()).log(Level.SEVERE, null, ex);
        }




    }

}