package ro.scoalainformala.bankjdbc.helper;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DBHelper {

    public static Connection getConnection() {
        Properties connectionProperties = new Properties();
        connectionProperties.put("user", "root");
        connectionProperties.put("password", "random112");

        String connString = "jdbc:mysql://localhost:3306/bank_curs";
        try {
            Connection con = DriverManager.getConnection(connString, connectionProperties);
            System.out.println("Conexiunea la baza de date a fost deschisa");
            return con;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public static void closeConnection(Connection con) {
        try {
            con.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}