package Main;

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

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);
      Bukkit.getConsoleSender().sendMessage("§aMySQL mit Tokenshop verbunden!");
    } catch (SQLException e) {
      Bukkit.getConsoleSender().sendMessage("§cMySQL konte nicht mit den TokenShop verbunden werden: " + e.getMessage());
      e.printStackTrace();
    }
    return con;
  }

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

  public static boolean hasConnection() {
    if (con != null) {
      return true;
    }
    return false;
  }
}