import java.io.*;
import java.sql.*;
import java.util.Properties;


public class Kund {
    private String query1,svar, url;
    private ResultSet rs1;
    private Connection db;
    private Properties settings;
    private BufferedReader in;

        Kund(String[] args){
        try{

                in = new BufferedReader(new InputStreamReader(System.in));
                Class.forName ("org.postgresql.Driver");
                settings = new Properties ();
                settings.setProperty ("user", System.getProperty ("user.name"));
                url = "jdbc:postgresql://localhost/harryli";
                db = DriverManager.getConnection (url, settings);

                while(true){
                System.out.println("Välkommen till varuhuset, vad vill du göra?");
                System.out.println("1. Sök titel");
                System.out.println("2. Sök skådespelare");
                System.out.println("3. Sök regissör");
                System.out.println("4. Sök genre");
                System.out.println("5. Sök filmbolag");
                System.out.println("6. Sök distrubitör\n\n\n");
                System.out.println("0. Exit");

                int val = Integer.parseInt(in.readLine());
                switch(val){

                //case 1, sök film
                case 1:
                    System.out.println("Vilken film söker du?");
                    String titel = in.readLine();

                    query1 = "select * from film where Title = '"+titel+"'";
                    rs1 = db.createStatement().executeQuery (query1);

                    while (rs1.next ())
                        System.out.println (rs1.getString(1) + ". Regissör: " + rs1.getString(2)+ ". Genre: " + rs1.getString(3) + ". Filmbolag: " + rs1.getString(4) + ". Distributör: " +rs1.getString(5));

                    if(moar()){
                        break;
                    }

                //sök skådespelare
                case 2:
                    System.out.println("Vem söker du?");
                    String skads = in.readLine();

                    query1 = "select snamn,titel from skådespelare natural join spelasav where snamn = '"+skads+"'";
                    rs1 = db.createStatement().executeQuery (query1);

                    System.out.println(skads + " meddverkar i följande filmer:");
                    while (rs1.next ()) {
                        System.out.println (rs1.getString(2));
                    }

                    if(moar()){
                        break;
                    }

                //sök regissör
                case 3:
                    System.out.println("Vilken regissör söker du?");
                    String regi = in.readLine();

                    query1 = "select * from film where Regissor = '"+regi+"'";
                    rs1 = db.createStatement().executeQuery (query1);

                    System.out.println(regi+":");
                    while (rs1.next ())
                        System.out.println ("Titel: " + rs1.getString(1)+ ". Genre: " + rs1.getString(3) + ". Filmbolag: " + rs1.getString(4) + ". Distributör: " +rs1.getString(5) + "\n\n" );

                    if(moar()){
                        break;
                    }

                //sök genre
                case 4:
                    System.out.println("Vilken genre söker du?");
                    String genre = in.readLine();

                    query1 = "select * from film where Kategori = '"+genre+"'";
                    rs1 = db.createStatement().executeQuery (query1);

                    System.out.println("Följande filmer är registrerade som " + genre +":");
                    while (rs1.next ())
                        System.out.println ("Titel: " + rs1.getString(1)+ ". Regissör: " + rs1.getString(2)+". Filmbolag: " + rs1.getString(4) + ". Distributör: " +rs1.getString(5));


                    if(moar()){
                        break;
                    }


                case 5:
                    System.out.println("Vilket filmbolag söker du?");
                    String bol = in.readLine();

                    query1 = "select * from film where filmbolag = '"+bol+"'";
                    rs1 = db.createStatement().executeQuery (query1);

                    while (rs1.next ())
                        System.out.println (rs1.getString(1) + ". Regissör: " + rs1.getString(2)+ ". Genre: " + rs1.getString(3) + ". Distributör: " +rs1.getString(5));

                    if(moar()){
                        break;
                    }


                case 6:
                    System.out.println("Vilken distrubitör söker du?");
                    String dis = in.readLine();

                    query1 = "select * from film where distrubitor = '"+dis+"'";
                    rs1 = db.createStatement().executeQuery (query1);

                    while (rs1.next ())
                        System.out.println (rs1.getString(1) + ". Regissör: " + rs1.getString(2)+ ". Genre: " + rs1.getString(3));

                    if(moar()){
                        break;
                    }

                case 0:
                        System.out.println("Hej då!");
                        System.exit(0);
                }
                }


        }
        catch(Exception e){
                System.err.println(e);
        }

        }

        public boolean moar() throws Exception {
            System.out.println("Do you want to know more? y/n");
            svar = in.readLine().toString();
            if(svar.equalsIgnoreCase("y")){
                return true;
            }
            else {
                System.out.println("hej då!");
                System.exit(0);
            }
            return false;
        }


        public static void main(String[] args) {
                new Kund(args);
                System.exit(0);
                }
     }