package ws;

import java.sql.*;
import java.util.*;

public class WS {
   Connection db;
   Statement sql;
   DatabaseMetaData dbmd;

    public Zamudnik[] najdi (String element)
    {
        int i=0;
        Zamudnik zam;
        ArrayList zamudniki = new ArrayList();
        try {
            System.out.println("Isaknje zamudnikov: "+element);

       //   String psql = "SELECT \"Naziv\" FROM \"rezervni_deli\" WHERE \"Cena\" = (SELECT \"Cena\" FROM \"rezervni_deli\" WHERE \"Naziv\"= '"+element+"')" ;
      //    String psql = "SELECT \"naslov\" FROM \"knjiga\" WHERE \"cena\" = (SELECT \"cena\" FROM \"knjiga\" WHERE \"naslov\"= '"+element+"')" ;
            String psql = "SELECT \"s.s_id\", \"s.ime\", \"s.priimek\", \"naslov\" FROM \"stranka s\" JOIN \"izposoja iz\" ON \"s.s_id\" = \"iz.i_id\" JOIN \"knjiga_izposoja kiz\" ON \"kiz.i_id\" = \"iz.i_id\" JOIN \"zaloga zal\" ON \"zal.zal_id\" = \"kiz.zal_id\"             JOIN \"knjiga k\" ON \"k.k_id\" = \"zal.k_id\" WHERE \"iz.kon_datum\" - \"iz.zac_datum\" > \"14\" ";
            String url = "jdbc:postgresql://localhost:5432/spletnaknjigarna";
            String username = "postgres";
            String password = "simonr";
            Class.forName("org.postgresql.Driver");
            db = DriverManager.getConnection(url, username, password);

            if(db!=null)
            {
                System.out.println("Povezava je v redu");
            }
            else
            {
                System.out.println("Povezava ni v redu");
            }
            sql = db.createStatement();

            ResultSet rs = sql.executeQuery(psql);
            if (rs != null)
            {
                while (rs.next())
                {
                 // zam = new Zamudnik(rs.getString(1));
                    new Zamudnik(rs.getString(1),rs.getString(2), rs.getString(3));
                    i++;
                    zamudniki.add(zam);
                }
            }
        } catch (ClassNotFoundException e) {
            System.out.println("Napaka: " +e);
        } catch (SQLException e) {
            System.out.println("Napaka SQL " + e);
        }
        Zamudnik[] tabelaZamudnikov=new Zamudnik[i];
        zamudniki.toArray(tabelaZamudnikov);
        return tabelaZamudnikov;
    }
}