package com.mybank.db;

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

public class ATMDB {

	// database configurations
	private static String url = "jdbc:mysql://localhost:3306/ftmkbank";
	private static String user = "root";
	private static String password = "Iver30n";

	public static Connection connect() {
		try {
			// load and register mysql jdbc driver
			Class.forName("com.mysql.cj.jdbc.Driver");

			// establish a connection
			Connection conn = DriverManager.getConnection(url, user, password);

			if (conn != null) {
				System.out.println("Connected to database successfully!");
				return conn;
			}
		} catch (Exception ex) {
			System.out.println("Connection error: " + ex.getMessage());
		}
		return null;
	}

	public static void disconnect(Connection conn) {
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// do nothing
			}
		}
	}
}