package de.setoras.potionpvp.main;

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

import org.bukkit.plugin.java.JavaPlugin;

public class DB extends JavaPlugin {
	DB mysql = new DB();

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

    @Override
    public void onEnable() {
        host = "localhost";
        port = 3306;
        database = "Minecraft";
        username = "user";
        password = "pass";
        try {
            openConnection();
            Statement statement = connection.createStatement();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Override
    public void onDisable() {
    }

    public void openConnection() throws SQLException, ClassNotFoundException {
    if (connection != null && !connection.isClosed()) {
        return;
    }

    synchronized (this) {
        if (connection != null && !connection.isClosed()) {
            return;
        }
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password);
    }
    }
}