package ws;

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 \"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 \"naslov\" FROM \"knjiga\" JOIN \"pisatelj" ON \"(knjiga.p_id = pisatelj.p_id)"
     //     WHERE \"(pisatelj.ime = 'Ivan' and pisatelj.priimek = 'Cankar')"
            String psql = "Select naslov From knjiga JOIN pisatelj on (knjiga.p_id = pisatelj.p_id) WHERE (pisatelj.ime" = '"+element+"';
            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));
                    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;
    }
}