package me.biggriefer.core.handlers.listeners.DB;

import com.mysql.jdbc.Connection;
import org.bukkit.Bukkit;

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

public class MySQLmain {

    private Connection connection;
    public String host, database, username, password;
    public int port;
    public MySQLmain mySQLmain;

    public void mysqlSetup() {

        host = "localhost";
        port = 3306;
        username = "user";
        database = "testbase";
        password = "12345qdas";

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

                Class.forName("com.mysql.jdbc.Driver");
                setConnection((Connection) DriverManager.getConnection("jdbc.mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password));
                Bukkit.getConsoleSender().sendMessage("MySQL connected!");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }


    }

    public Connection getConnection() {
        return connection;
    }

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

//Code
[16:32:56 INFO]: Core loaded!
[16:32:56 WARN]: java.sql.SQLException: No suitable driver found for jdbc.mysql//localhost:3306/testbase
[16:32:56 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[16:32:56 WARN]:        at java.sql.DriverManager.getConnection(Unknown Source)
[16:32:56 WARN]:        at me.biggriefer.core.handlers.listeners.DB.MySQLmain.mysqlSetup(MySQLmain.java:31)
[16:32:56 WARN]:        at me.biggriefer.Core.onEnable(Core.java:37)
[16:32:56 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[16:32:56 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[16:32:56 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
[16:32:56 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
[16:32:56 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
[16:32:56 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:422)
[16:32:56 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:383)
[16:32:56 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:338)
[16:32:56 WARN]:        at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:272)
[16:32:56 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
[16:32:56 WARN]:        at java.lang.Thread.run(Unknown Source)