package Duel;

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

public class MySQL {

	public static Connection con;

	public static Connection connect(String host, int port, String database, String user, String password) {

		try {
			con = DriverManager.getConnection("jdbc:mysql://"+host+":"+port+"/"+database+"?autoReconnect=true", user, password);
			System.out.println("[Duel] [Mysql] connection ist hergestellt!");
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("[Duel] [Mysql] connection ist Fehlgeschlagen!");
		}

		return con;
	}

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

	public static boolean hasConnection(){

		if(con != null){
			return true;
		}

		return false;
	}

}