package server;

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

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

    public RezervniDel[] najdi (String element)
    {
        int i=0;
        RezervniDel rd;
        ArrayList deli = new ArrayList();
        try {
            System.out.println("Iscem element: "+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())
                {
                    rd = new RezervniDel(rs.getString(1),rs.getString(2),rs.getString(3));
//                  rd = new RezervniDel(rs.getString(1));
                    i++;
                    deli.add(rd);
                }
            }
        } catch (ClassNotFoundException e) {
            System.out.println("Napaka: " +e);
        } catch (SQLException e) {
            System.out.println("Napaka SQL " + e);
        }
        RezervniDel[] tabelaDelov=new RezervniDel[i];
        deli.toArray(tabelaDelov);
        return tabelaDelov;
    }
}