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


public class Labb2 {


	Labb2(String[] args){
	try{
		BufferedReader in = new BufferedReader(new InputStreamReader(System.in));

		Class.forName ("org.postgresql.Driver");
		Properties settings = new Properties ();
		settings.setProperty ("user", System.getProperty ("user.name"));
		String url = "jdbc:postgresql://localhost/darar";
		Connection 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 efter varaunummer");
		System.out.println("2. Sök efter varutyp");
		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("Vilket varunummer söker du?");
			int varunr = Integer.parseInt(in.readLine());

		    String query1 = "select * from vara where varunr = "+varunr;
	        ResultSet rs1 = db.createStatement().executeQuery (query1);

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

		case 2:
			System.out.println("hej du valde sök2");
			break;
		case 3:
			System.out.println("hej du valde remove");
			break;
		case 4:
			System.out.println("hej du valde lägg till");
			break;
		case 5:
			System.out.println("hej du valde uppdatera");
			break;
		case 6:
			System.out.println("Hej du valde list");
			break;
		case 0:
			System.out.println("Hej då!");
			System.exit(0);
		}
		}


		//insert into vara values (366, 'xbox')
		//String query = "delete from vara where varunr = 366";

		//ResultSet rs = db.createStatement().executeQuery (query);

//	    String query1 = "select * from vara";
//        ResultSet rs1 = db.createStatement().executeQuery (query1);
//
//        while (rs1.next ())
//            System.out.println (rs1.getString (1) + " " + rs1.getString(2) );

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

	}



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


}