import com.mysql.jdbc.Statement;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

//import java.sql.Connection;
//import java.sql.DriverManager;
//import java.sql.SQLException;
//import java.util.Scanner;

public class Main {

    private static String DB_DRIVER = "com.mysql.jdbc.Driver";
    private static String DB_CONNECTION = "jdbc:mysql://localhost:3306/contacts";
    private static String DB_USER = "root";
    private static String DB_PASSWORD = "";
    private static java.sql.Statement statement = null;

    public static void main(String[] args) {
        System.out.println("***Справочник для хранения телефонов ЗНАКОМЫХ людей!***");
        Scanner scanner = new Scanner(System.in);
        showMenu(scanner);
    }


    private static Connection getDBConnection() {
        Connection dbConnection = null;
        try {
            Class.forName(DB_DRIVER);
        } catch (ClassNotFoundException e) {
            System.out.println(e.getMessage());
        }
        try {
            dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
            return dbConnection;
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
        return dbConnection;
    }

    private static void showMenu(Scanner readLine) {
        readLine = new Scanner(System.in);
        System.out.println("Что вы хотите сделать?\n1. Поиск контакта\n2. Показать список всех контактов\n3. Добавление нового контакта\n4. Удаление контакта");
        int choose = readLine.nextInt();
        switch (choose) {
            case 1: {
                searchContacts();
                showMenu(readLine);
            }

            case 2: {
                showContacts();
                showMenu(readLine);
            }

            case 3: {
                addContact();
                showMenu(readLine);
            }

            case 4: {
                deleteContact();
                showMenu(readLine);
            }
        }
    }

    private static void addContact() {
        Scanner scanner = new Scanner(System.in);
        System.out.println("Введите имя, фамилию и номер телефона через Enter");
        String name = scanner.next();
        String secondname = scanner.next();
        String telephone1 = scanner.next();
        String insertSQL = "INSERT INTO contacts (name, secondname, telephone1) VALUES ('" + name + "', '" + secondname + "', '" + telephone1 + "')";
        //System.out.println(insertSQL);
        try {
            //connection = getDBConnection();
            statement = getDBConnection().createStatement();
            statement.executeUpdate(insertSQL);
            System.out.println("Complete!");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }

    private static void searchContacts() {
        Scanner scanner = new Scanner(System.in);
        System.out.println("Введите имя контакта для поиска: "); //редактирование добавить!
        String search = scanner.next();
        String selectforSearch = "SELECT * FROM CONTACTS WHERE NAME LIKE " + "'" + search + "'";
        showInConsole(selectforSearch);
    }

    private static void showContacts() {
        System.out.println("Мои контакты:\n");
                /*Class.forName(DB_DRIVER);
                Connection conn = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
                conn.close();*/
        String selectSQL = "SELECT name, secondname, telephone1, telephone2, telephone3 from contacts;";
        showInConsole(selectSQL);
    }

    private static void showInConsole(String executeQuery) {
        try {
            //connection = getDBConnection();
            statement = getDBConnection().createStatement();
            ResultSet rs = statement.executeQuery(executeQuery);

            while (rs.next()) {
                String name = rs.getString("name");
                String secondname = rs.getString("secondname");
                String telephone1 = rs.getString("telephone1");
                System.out.print(name + " ");
                System.out.print(secondname + " ");
                System.out.println(telephone1);
            }

        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }

    }

    private static void deleteContact() {
        System.out.println("Введите имя пользователя, которого хотите удалить и нажмите Enter");
        Scanner scanner = new Scanner(System.in);
        String deletename = scanner.nextLine();
        String deleteTableSQL = "DELETE FROM CONTACTS WHERE NAME = '" + deletename + "';";
        try {
            statement = getDBConnection().createStatement();
            statement.execute(deleteTableSQL);
            System.out.println("Record is deleted from DBUSER table!");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }

    }

}