package com.company;

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

public class JDBC_train {

    private String login;
    private String password;
    private Statement statement = null;
    private Connection connect = null;
    private ResultSet rs = null;

    public JDBC_train(String login, String password){
        this.login = login;
        this.password = password;

   //     connectDB();

    }
    public void setLogin(String login) {
        this.login = login;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public void connectDB() throws Exception {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            connect = DriverManager.getConnection("jdbc:oracle:thin:@sql.edu-netcracker.com:1251",
                    login, password);

            statement = connect.createStatement();
        } catch (ClassNotFoundException e) {
            System.err.println("У вас не установлен драйвер");
            e.printStackTrace();
        } catch (SQLException e){
            System.err.println("не удалось присоедениться к БД, проверте запущен ли сервер");
            e.printStackTrace();
        }

    }

    public static void main(String[] args) throws Exception {
        System.out.println("Privet, User, tell me ur usename and password");
        Scanner in = new Scanner(System.in);
        String login = in.nextLine();
        String password = in.nextLine();
      }

    public void makeQuevery() throws SQLException{


    }