package net.Syntaxfehler.gungame.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import org.bukkit.Bukkit;
import org.bukkit.command.ConsoleCommandSender;

public class MySQL
{
  public static String host;
  public static String port;
  public static String database;
  public static String username;
  public static String password;
  public static Connection con;

  public static void connect()
  {
    if (!isConnected()) {
      try
      {
        con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
        Bukkit.getConsoleSender().sendMessage("§8[§6MySQL§8] §3Verbindung zur MySQL-Datenbank wurde herrgestellt§8.");
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
  }

  public static void disconnect()
  {
    if (isConnected()) {
      try
      {
        con.close();
        Bukkit.getConsoleSender().sendMessage("§8[§6MySQL§8] §3Verbindung zur MySQL-Datenbank wurde getrennt§8.");
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
  }

  public static boolean isConnected()
  {
    return con != null;
  }

  public static Connection getConnection()
  {
    return con;
  }
}