public class MySQL {

    private static String HOST = "";
    private static String DATABASE = "";
    private static String USER = "";
    private static String PASSWORD = "";

    private static Connection con;

    public MySQL(String host, String database, String user, String password) {
        this.HOST = host;
        this.DATABASE = database;
        this.USER = user;
        this.PASSWORD = password;

        connect();
    }

    public static void connect() {
        try {
            System.out.println("Host=" + HOST + " DB=" + DATABASE + " User=" + USER + " PW=" + PASSWORD);
            con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":3306/" + DATABASE + "?autoReconnect=true&useJDBCCompliantTimezoneShift=true&serverTimezone=UTC", USER, PASSWORD);
            System.out.println("[MySQL] Die Verbindung zur MySQL wurde hergestellt!");
        } catch (SQLException e) {
            System.out.println("[MySQL] Die Verbindung zur MySQL ist fehlgeschlagen! Fehler: " + e.getMessage());
            e.printStackTrace();
        }
    }





@EventHandler
    public void onjoin(PlayerJoinEvent event) {

        final Player player = event.getPlayer();
        final String name = player.getName();


        ItemStack item = new ItemStack(Material.SKULL_ITEM);
        item.setDurability((short) 3);

        SkullMeta skullMeta = (SkullMeta) item.getItemMeta();
        GameProfile profile = new GameProfile(UUID.randomUUID(), player.getName());
        profile.getProperties().put("textures",
                new Property("textures",
                        getPlayerTexture(name),
                        getPlayerSignature(name)));

        try {
            Field gameProfileField = Class.forName("org.bukkit.craftbukkit.v1_8_R3.inventory.CraftMetaSkull").getDeclaredField("profile");
            if (!gameProfileField.isAccessible()) {
                gameProfileField.setAccessible(true);
            }
            gameProfileField.set(skullMeta, profile);
        } catch (Throwable e) {
            e.printStackTrace();
        }

        item.setItemMeta(skullMeta);

        player.getInventory().addItem(item);











private static String getPlayerTexture(String name) {

        try {
            PreparedStatement st = MySQL.getCon().prepareStatement("SELECT texture FROM PlayerTexture WHERE name = ?");
            st.setString(1, name);
            ResultSet rs = st.executeQuery();

            while (rs.next()) {
            return rs.getString("texture");
            }

        }catch (SQLException e) {
            e.printStackTrace();
        }
        return "ERROR";
    }

    private static String getPlayerSignature(String name) {

        try {
            PreparedStatement st = MySQL.getCon().prepareStatement("SELECT signature FROM PlayerTexture WHERE name = ?");
            st.setString(1, name
            );
            ResultSet rs = st.executeQuery();

            while (rs.next()) {
                return rs.getString("signature");
            }

        }catch (SQLException e) {
            e.printStackTrace();
        }
        return "ERROR";
    }