package ua.kiev.prog;

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

/*Спроектировать базу «Квартиры». Каждая запись в базе содержит данные о квартире (район, адрес, площадь, кол. комнат, цена).
        Сделать возможность выборки квартир из списка по параметрам.*/

public class ApartmentMain {
    private static final String DB_CONNECTION = "jdbc:mysql://localhost:3306/dbapartment";
    private static final String DB_USER = "root";
    private static final String DB_PASSWORD = "03051993_Zakusylo";

    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        try (Connection connection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD)) {
            ApartmentWorker worker = new ApartmentWorker(connection, sc);


            while (true) {
                System.out.println("1: Delete load table of database and start new");
                System.out.println("2: Add new apartment");
                System.out.println("3: Delete apartment");
                System.out.println("4: Change price of apartment");
                System.out.println("5: View all apartments");
                System.out.println("6: View apartments by parameters");
                System.out.print("-> ");

                String s = sc.nextLine();
                switch (s) {
                    case "1":
                        worker.deleteOldTableAndCreateNew();
                        break;
                    case "2":
                        worker.addNewApartment();
                        break;
                    case "3":
                        worker.deleteApartment();
                        break;
                    case "4":
                        worker.changePriceOfApartment();
                        break;
                    case "5":
                        worker.showDataBase();
                        break;
                    case "6":
                        worker.showDataBaseByParamets();
                        break;
                    default:
                        return;
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}