package bus;

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

public class Bus {
    private static final String url = "jdbc:mysql://fr79380k.beget.tech:3306/fr79380k_test";
    private static final String user = "fr79380k_test";
    private static final String password = "12345678";

    private static String query;

    public static void main(String[] args) {
        Scanner inputScanner = new Scanner(System.in);

        try {
            Connection connection = DriverManager.getConnection(url, user, password);
            Statement CONNECTION = connection.createStatement();

            while(true) {
                System.out.println("Выберите пункт меню:");
                System.out.println("1- Вывод данных");
                System.out.println("2- Добавление данных");
                System.out.println("3- Редактирование данных");
                System.out.println("4- Поиск данных");
                System.out.println("5- Удаление данных");
                System.out.println("6- Выход");

                int input = inputScanner.nextInt();

                switch (input) {
                    case 1:
                        query = "select id, number, name, arrival, departure, time, price from info";
                        ResultSet result = CONNECTION.executeQuery(query);

                        while (result.next()) {
                            int id = result.getInt(1);
                            int number = result.getInt(2);
                            String name = result.getString(3);
                            String arrival = result.getString(4);
                            String departure = result.getString(5);
                            String time = result.getString(6);
                            int price = result.getInt(7);

                            System.out.printf("id: %d, number: %d, name: %s, arrival: %s, departure: %s, time: %s, price: %d%n", id, number, name, arrival, departure, time, price);
                        }
                    break;

                    case 2:
                        System.out.println("Введите Id для автобуса: ");
                        int id = inputScanner.nextInt();
                        System.out.println("Введите номер автобуса: ");
                        int number = inputScanner.nextInt();
                        System.out.println("Введите название : ");
                        String name = inputScanner.next();
                        System.out.println("Введите время отправление: ");
                        String arrival = inputScanner.next();
                        System.out.println("Введите время прибытия: ");
                        String departure = inputScanner.next();
                        System.out.println("Ведите время пути: ");
                        String time = inputScanner.next();
                        System.out.println("Ведите стоимость: ");
                        int price = inputScanner.nextInt();

                        query = String.format(
                            "insert into info(id,number, name, arrival, departure, time, price)\n" +
                            " values ( '%d', '%d', '%s', '%s', '%s', '%s', '%d');",
                            id, number, name, arrival, departure, time, price
                        );
                        CONNECTION.executeUpdate(query);
                    break;
                }
            }

        } catch (SQLException sqlEx) {
            sqlEx.printStackTrace();
        }
    }

}