/*
 *
 */

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

public class my_DB
{
    private Scanner reader;

    public static void main (String[]   args) throws Exception{
        new my_DB();
    }

    public my_DB() throws Exception{


    //if (args.length != 1)
    //{
    //    System.err.println  ("Usage: java find_person <name>");
    //    System.exit (1);
    //}

    reader = new Scanner(System.in);

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

    System.out.println("Find person (1), Insert person(2), Delete person (3), Exit(4)");
    System.out.print(">");

    String inputLine = reader.nextLine();
    switch(Integer.parseInt(inputLine)){
        case 1:
            System.out.print("Name: ");

            String query = ("select namn, lön "  +
            "from anställd  "    +
            "where namn like ? " +
            "order by lön desc");

            PreparedStatement ps = db.prepareStatement (query);
            ps.setString (1, "%" + reader.nextLine() + "%");
            ResultSet rs = ps.executeQuery ();

            while (rs.next ())
            {
                String name = rs.getString (1);
                System.out.print (name);
                String space = "";
                for (int i = 0; i < 20 - name.length (); ++i)
                space  = space + " ";
                System.out.println (space + rs.getString (2));
            }

            rs.close();
            ps.close();
        case 2:
            System.out.print("Insert(name sallory): ");
            String inLine[] = reader.nextLine().split(" ");
            String sql = "INSERT INTO anställd (namn,lön) VALUES('"+inLine[0]+"',"+inLine[1]+")";
            PreparedStatement stmt = db.prepareStatement (sql);
            stmt.executeUpdate(sql);
        case 3:
        default:System.exit (1);
    }
}
}