package me.MySQL;


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

import org.bukkit.Bukkit;



import me.BanSystem.Main;

public class MySQL {

	    public static String username;
	    public static String password;
	    public static String database;
	    public static String host;
	    public static String port;
	    public static Connection con;


	    public static void connnect() {
	    	if(!isConnected()) {
	    		try {
					con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
					Bukkit.getConsoleSender().sendMessage(Main.getInstance().prefix + "§cMySQL Verbindung aufgebaut!");
				} catch (SQLException e) {

					e.printStackTrace();
				}


	    	}

          }

	    public static void close() {
	    	if(isConnected()) {
	    		try {
					con.close();
					Bukkit.getConsoleSender().sendMessage(Main.getInstance().prefix + "§cMySQL Verbindung geschlossen!");
				} catch (SQLException e) {
					e.printStackTrace();
				}

	    	}


	    }

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

	    }

	    public static void createTabel() {
	    	/*
	    	 *
	    	 * Syntax: Spielername, UUID, Ende, Grund;
	    	 *
	    	 */
	    	if(isConnected());
	    	try {
				con.createStatement().executeUpdate("CREATE TABEL IF NOT EXISTS BannendPlayers (Spielername VARCHAR(100), UUID VARCHAR(100), Ende VARCHAR(100), Grund VARCHAR(100))");
			} catch (SQLException e) {
				e.printStackTrace();
			}

	    }



}