private static String HOST = "localhost";
    private static String PORT = "3306";
    private static String DATABASE = "PlayerStats";
    private static String USERNAME = "root";
    private static String PASSWORD = "78d542a2dc11";

    private static Connection connection;

    public void connect() {
        if(!isConnected()) {
            try {
                connection = DriverManager.getConnection("jdbc:mysql://" + HOST + ":" + PORT + "/" + DATABASE + "?autoReconnect=true", USERNAME, PASSWORD);
                Bukkit.getConsoleSender().sendMessage("§aDie Verbindung mit der MySQL-Datenbank war erfolgreich");
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }else{
            connect();
        }
    }

    public void disconnect() {
        if(isConnected()) {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void update(String qry) {
        if(isConnected()) {
            try {
                connection.createStatement().executeUpdate(qry);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else{
            connect();
        }
    }

    public ResultSet getResult(String qry) {
        if(isConnected()) {
            try {
                return connection.createStatement().executeQuery(qry);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return null;
    }

    public void createTable() {
        if(isConnected()) {
            try {
                connection.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS PlayerStats (UUID VARCHAR(100), PlayerName VARCHAR(100), Kills INT(100), Deaths INT(100))");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    private static boolean isConnected() {
        try {
            return (connection != null && connection.isValid(5));
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }