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


public class Kund {


        Kund(String[] args){
        try{

                BufferedReader in = new BufferedReader(new InputStreamReader(System.in));
                boolean bool = true;
                Class.forName ("org.postgresql.Driver");
                Properties settings = new Properties ();
                settings.setProperty ("user", System.getProperty ("user.name"));

		settings.setProperty ("allowEncodingChanges","true");
		settings.setProperty ("client_encoding", "UTF-8");
		settings.setProperty ("encoding", "UTF-8");

                String url = "jdbc:postgresql://localhost/harryli";
                Connection db = DriverManager.getConnection (url, settings);
                String query1;
                String svar;
        ResultSet rs1;
        int varunr;
                while(true){
                System.out.println("Välkommen till varuhuset, vad vill du göra?");
                System.out.println("1. Sök efter film");
               	System.out.println("2. Sök skådespelare");
              	//System.out.println("3. Ta bort varnunmr");
                //System.out.println("4. Lägg till ny vara");
                //System.out.println("5. Uppdatera vara");
                //System.out.println("6. Lista alla varor\n\n\n");
                System.out.println("0. Exit");
                int val = Integer.parseInt(in.readLine());
                switch(val){
                case 1:
                        System.out.println("Vilken film söker du?");
                        String titel = in.readLine();


                    query1 = "select * from film where Regissör = '"+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) + "\n\n" );
                System.out.println("Do you want to know more? y/n");
                svar = in.readLine().toString();
                if(svar.equalsIgnoreCase("y")){
                        break;
                }
                else {
                        System.out.println("hej då!");
                        System.exit(0);
                }

                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);

                while (rs1.next ()) {
                System.out.println (rs1.getString(1) + " medverkar i filmen: " + rs1.getString(2));
                }
                System.out.println("\n\n");
                System.out.println("Do you want to know more? y/n");
                svar = in.readLine().toString();
                if(svar.equalsIgnoreCase("y")){
                        break;
                }
                else {
                        System.out.println("hej då!");
                        System.exit(0);
                }
        /*
                case 3:
                        System.out.println("Vilket varunummer vill du ta bort?");

                        varunr = Integer.parseInt(in.readLine());

                    query1 = "delete from vara where varunr = " + varunr;
                    try{
                           db.createStatement().executeQuery (query1);
                            }
                            catch(Exception e) {

                          }


                System.out.println ("Vara med varunummer: " + varunr + " togs bort.");

                System.out.println("\n\n");
                System.out.println("Do you want to know more? y/n");
                svar = in.readLine().toString();
                if(svar.equalsIgnoreCase("y")){
                        break;
                }
                else {
                        System.out.println("hej då!");
                        System.exit(0);
                }

                case 4:
                        System.out.println("Vilken vara vill du lägga till?");

                        varutyp = in.readLine();
                        query1 = "select max(varunr) from vara";
                        rs1 = (db.createStatement().executeQuery (query1));
                        rs1.next();
                        int max = Integer.parseInt(rs1.getString(1));


                    query1 = "insert into vara values ("+(max+1)+", "+"'"+varutyp+"')";
                    try{
                    db.createStatement().executeQuery (query1);
                    }
                    catch(Exception e) {

                    }


                System.out.println ("Vara: " + varutyp + " har lagts till med varunummer: "+(max+1));

                System.out.println("\n\n");
                System.out.println("Do you want to know more? y/n");
                svar = in.readLine().toString();
                if(svar.equalsIgnoreCase("y")){
                        break;
                }
                else {
                        System.out.println("hej då!");
                        System.exit(0);
                }
                case 5:
                        System.out.println("Vilket varunummer vill du ändra?");
                        varunr = Integer.parseInt(in.readLine());

                        System.out.println("Vad vill du ändra det till?");
                        varutyp = in.readLine().toString();

                        query1 = "update vara set typ = "+"'"+varutyp+"'"+" where varunr = "+varunr;
                    try{
                    db.createStatement().executeQuery (query1);
                    }
                    catch(Exception e) {

                    }
                System.out.println("Do you want to know more? y/n");
                svar = in.readLine().toString();
                if(svar.equalsIgnoreCase("y")){
                        break;
                }
                else {
                        System.out.println("hej då!");
                        System.exit(0);
                }

                case 6:
                        System.out.println("Hej du valde list");
                    query1 = "select * from vara";
                rs1 = db.createStatement().executeQuery (query1);

                while (rs1.next ())
                        System.out.println (rs1.getString(1)+ " " +rs1.getString(2) );
                        System.out.println("Do you want to know more? y/n");
                        svar = in.readLine().toString();
                        if(svar.equalsIgnoreCase("y")){
                                break;
                        }
                        else {
                                System.out.println("hej då!");
                                System.exit(0);
                        }
		*/
                case 0:
                        System.out.println("Hej då!");
                        System.exit(0);
                }
                }


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

        }



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


}