package vit;

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

public class Main {
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Scanner in = new Scanner(System.in);

        String connectionUrl = "jdbc:mysql://***.***.**.***:3306/****?"+
                "&useSSL=true"+
                "&serverTimezone=UTC";
        Class.forName("com.mysql.jdbc.Driver");
        try (Connection conn = DriverManager.getConnection(connectionUrl,"manager","*****");
             Statement statement = conn.createStatement()) {
            statement.executeQuery("SET NAMES utf8");
            ResultSet res = statement.executeQuery("select * from users");
            while (res.next()) {
                System.out.println(res.getString("name"));
                System.out.println(res.getString("surname"));
                System.out.println("----------------------------");
            }
        }

        String name = in.nextLine();
        System.out.println("Имя: " + name);
    }
}