package slothsec.eu.login;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import org.bukkit.plugin.java.JavaPlugin;
import org.bukkit.scheduler.BukkitRunnable;
import org.bukkit.scheduler.BukkitTask;

/**
 * Created by sloth on 05.12.2016.
 */
public class login extends JavaPlugin {

        private Connection verbindung;
        private String host, datenbank, benutzername, passwort;
        private int port;

    @Override
    public void onEnable(){
        System.out.println("MYSQL erfolgreich gestartet!");
        r.runTaskAsynchronously(this);

    }

    @Override
    public void onDisable(){

    }
    public void openConnection() throws SQLException, ClassNotFoundException{
        if (verbindung != null && !verbindung.isClosed()){
            return;
        }
        synchronized(this){
            if (verbindung != null && !verbindung.isClosed()){
                return;
            }
            Class.forName("com.mysql.jdbc.Driver");
            verbindung = DriverManager.getConnection("jdbc:mysql://" +this.host+ ":" + this.port + "/" + this.datenbank, this.benutzername, this.passwort);
        }
    }
    BukkitRunnable r = new BukkitRunnable(){
        @Override
        public void run() {
            host = "localhost";
            port = 3306;
            datenbank = "minecraft";
            benutzername = "minecraft";
            passwort = "sl0thmc";
            try {
                openConnection();
                Statement statement = verbindung.createStatement();

                ResultSet result = statement.executeQuery("SELECT * FROM Spieler;");
                List<String> players = new ArrayList<String>();

                while (result.next()) {
                    String name = result.getString("spielername");
                    players.add(name);
                    System.out.println(name);
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    };

}