package nl.erbenvarvil.sql.test;

import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.event.Listener;
import org.bukkit.plugin.java.JavaPlugin;

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

/**
 * Gemaakt door Erben Varvil op 4-7-2017.
 */
public class Main extends JavaPlugin implements Listener {
    private Connection connection;
    public String host, database, username, password, port;

    public void onEnable() {
        mysqlSetup();
    }

    public void mysqlSetup() {
        host =  "shareddb1d.hosting.stackcp.net";
        username = "dyrhomc-3231e610";
        database = "dyrhomc-3231e610";
        port = "3306";
        password = "SQLDB123";


        try {


                synchronized (this) {
                    if(getConnection() != null && !getConnection().isClosed()) {
                        return;
                    }

                    Class.forName("com.mysql.jdbc.Driver");
                    setConnection(DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password));

                    Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "MYSQL CONNECTED");
                }
        } catch(SQLException e) {
            Bukkit.getServer().getConsoleSender().sendMessage("SQL Error at " + e.getMessage());
        } catch (ClassNotFoundException e){
            e.printStackTrace();
        }
    }


    public Connection getConnection() {
        return connection;
    }

    public void setConnection(Connection connection) {
        this.connection = connection;
    }
}