meituan交互浅析(4) AD广告模块与黑名单机制

最新推荐文章于 2021-09-28 10:57:27 发布

KujyouRuri

最新推荐文章于 2021-09-28 10:57:27 发布

阅读量298

点赞数

本文链接：https://blog.youkuaiyun.com/KujyouRuri/article/details/117965760

版权

该博客深入分析了美团广告模块中的黑名单机制，包括DAO层的构建，如AdBlacklist和AdStat类的设计，以及广告状态和用户点击数的存储。同时，介绍了Spark作业在处理广告数据中的应用，如结果存储到ad_user_click_count和ad_province_top3表中，以及利用AdClickTrend类跟踪点击趋势。涉及类型转换和大数据处理方面的内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DAO层的基础建设：

创建 AdBlacklist类，用于


package com.aura.bigdata.analysis.domain.ad;

public class AdBlacklist {
   
    private int user_id;

    public int getUser_id() {
   
        return user_id;
    }

    public void setUser_id(int user_id) {
   
        this.user_id = user_id;
    }
}

AdBlacklist的接口

import com.aura.bigdata.analysis.dao.IBaseDao;
import com.aura.bigdata.analysis.domain.ad.AdBlacklist;

import java.util.List;

public interface IAdBlacklistDao extends IBaseDao<AdBlacklist> {
    /**
     * 查询所有数据
     * @return
     */
    List<AdBlacklist> queryAll();
}

创建ad_blacklist`表来储存结果

CREATE TABLE `ad_blacklist` (
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

创建AdStat类,利用getter和setter方法来获取广告状态

package com.aura.bigdata.analysis.domain.ad;

public class AdStat {
   
    private String date;
    private String province;
    private String city;
    private int ad_id;
    private int click_count;

    public String getDate() {
   
        return date;
    }

    public void setDate(String date) {
   
        this.date = date;
    }

    public String getProvince() {
   
        return province;
    }

    public void setProvince(String province) {
   
        this.province = province;
    }

    public String getCity() {
   
        return city;
    }

    public void setCity(String city) {
   
        this.city = city;
    }

    public int getAd_id() {
   
        return ad_id;
    }

    public void setAd_id(int ad_id) {
   
        this.ad_id = ad_id;
    }

    public int getClick_count() {
   
        return click_count;
    }

    public void setClick_count(int click_count) {
   
        this.click_count = click_count;
    }
}

创建表ad_stat，将结果储存进去

CREATE TABLE `ad_stat` (
  `date` varchar(30) DEFAULT NULL,
  `province` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `ad_id` int(11) DEFAULT NULL,
  `click_count` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

创建ad_user_click_count类，利用setter和getter方法来获得用户的点击数

public class AdUserClickCount {
   
    private String date;
    private int user_id;
    private int ad_id;
    private int click_count;

    public String getDate() {
   
        return date;
    }

    public void setDate(String date) {
   
        this.date = date;
    }

    public int getUser_id() {
   
        return user_id;
    }

    public void setUser_id(int user_id) {
   
        this.user_id = user_id;
    }

    public int getAd_id() {
   
        return ad_id;
    }

    public void setAd_id(int ad_id) {
   
        this.ad_id = ad_id;
    }

    public int getClick_count() {
   
        return click_count;
    }

    public void setClick_count(int click_count) {
   
        this.click_count = click_count;
    }
}

匹配的接口

package com.aura.bigdata.analysis.dao.ad;


import com.aura.bigdata.analysis.dao.IBaseDao;
import com.aura.bigdata.analysis.domain.ad.AdUserClickCount;

public interface IAdUserClickCountDao extends IBaseDao<AdUserClickCount> {
   

    int getClickCountByDateUserAd(String date, int userId, int adId);
}

结果储存到表ad_user_click_count当中

CREATE TABLE `ad_user_click_count` (
  `date` varchar(30) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ad_id` int(11) DEFAULT NULL,
  `click_count` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

int(11)—>java中的integer/int //类型转换
bigint—>java中的Long/long

创建ad_province_top3类，用于求取

package com.aura.bigdata.analysis.domain.ad;


public class AdProvinceTop {
   
    private String date;
    private String province;
    private int ad_id;
    private int click_count;

    public String getDate() {
   
        return date;
    }

    public void setDate(String date) {
   
        this.date = date;
    }

    public String getProvince() {
   
        return province;
    }

    public void setProvince(String province) {

最低0.47元/天解锁文章