package ws;

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

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

    public Customer[] search (String customer)
    {
        int i=0;
        Customer cust;
        ArrayList customers = new ArrayList();
        try {
            System.out.println("Searching customers:"+customer);


            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("Connection OK");
            }
            else
            {
                System.out.println("Connection not OK");
            }
            sql = db.createStatement();

            ResultSet rs = sql.executeQuery(psql);
            if (rs != null)
            {
                while (rs.next())
                {

                    zam = new Customer(rs.getString(1),rs.getString(2), rs.getString(3));
                    i++;
                    customers.add(cust);
                }
            }
        } catch (ClassNotFoundException e) {
            System.out.println("Error: " +e);
        } catch (SQLException e) {
            System.out.println("Error SQL " + e);
        }
        Customer[] tableofCustomers=new Customer[i];
        customers.toArray(tableofCustomers);
        return tableofCustomers;
    }
}