Hadoop 视频分析系统

已于 2024-11-05 16:21:01 修改
阅读量3.9w 收藏 25
点赞数 5
分类专栏： Hadoop 大数据 数据分析 文章标签： 服务器 linux 运维 数据库 mysql hadoop mapreduce
于 2023-11-09 14:16:04 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_24330181/article/details/134310439
版权

视频分析系统

Hadoop

业务流程

Hadoop

原始数据

vedio.json

{"rank":1,"title":"《逃出大英博物馆》第二集","dzl":"77.8","bfl":"523.9","zfl":"39000","type":"影视","time":"3-5"}
{"rank":2,"title":"兄弟们这一期真的要看到最后！","dzl":"89.6","bfl":"636.1","zfl":"4246","type":"搞笑","time":"3-5"}
{"rank":3,"title":"全世界学生都痛恨的一种教育方式","dzl":"27.3","bfl":"313.6","zfl":"13000","type":"搞笑","time":"5-8"}
{"rank":4,"title":"这是我玩过最抽象的宝可梦了3","dzl":"29.7","bfl":"193.6","zfl":"4631","type":"搞笑","time":"10+"}
{"rank":5,"title":"我们又又又改造公司了","dzl":"25.0","bfl":"269.7","zfl":"3084","type":"搞笑","time":"10+"}
{"rank":6,"title":"我在尝试当一种很新的美食博主","dzl":"48.0","bfl":"258.7","zfl":"6596","type":"美食","time":"0-3"}
{"rank":100,"title":"很听劝我和男装的自己搞在一起","dzl":"18.7","bfl":"87.8","zfl":"4077","type":"搞笑","time":"0-3"}
{"rank":99,"title":"探秘中国最贵的面！70只大闸蟹做一碗面！到底什么味道？","dzl":"8.8","bfl":"88.2","zfl":"4527","type":"美食","time":"5-8"}
{"rank":7,"title":"土布","dzl":"26.4","bfl":"224.8","zfl":"3291","type":"生活","time":"5-8"}
{"rank":34,"title":"我的工作周报vs我实际的工作","dzl":"18.2","bfl":"162.6","zfl":"21000","type":"生活","time":"3-5"}
{"rank":8,"title":"麒麟9000S性能分析：华为Mate60 Pro能效如何？","dzl":"18.7","bfl":"151.7","zfl":"34000","type":"知识","time":"10+"}
{"rank":98,"title":"Time Vent！十秒带你穿越2023-2009！感受令和与新平成假面骑士的力量叭！","dzl":"14.4","bfl":"124.3","zfl":"6918","type":"动画","time":"0-3"}
{"rank":35,"title":"魔术师的三个阶段","dzl":"12.2","bfl":"180.0","zfl":"3841","type":"影视","time":"3-5"}
{"rank":9,"title":"高斯一败涂地","dzl":"21.3","bfl":"181.3","zfl":"3424","type":"搞笑","time":"10+"}
{"rank":97,"title":"千匹之战！中国车VS特斯拉！","dzl":"7.2","bfl":"117.4","zfl":"15000","type":"知识","time":"10+"}
{"rank":96,"title":"真实事件改编没想到一个综艺节目这么敢拍孩子需要被改造吗？","dzl":"11.2","bfl":"441.4","zfl":"1640","type":"影视","time":"5-8"}
{"rank":36,"title":"哈哈哈哈哈谁是卧底音乐版","dzl":"14.2","bfl":"232.9","zfl":"16000","type":"生活","time":"0-3"}
{"rank":10,"title":"偷子","dzl":"58.1","bfl":"699.6","zfl":"20000","type":"搞笑","time":"10+"}
{"rank":37,"title":"感谢还有读书这条路能让我摆脱这样的原生家庭","dzl":"11.2","bfl":"162.4","zfl":"13000","type":"生活","time":"10+"}
{"rank":11,"title":"“当 代 热 门 游 戏 现 状”","dzl":"26.3","bfl":"205.0","zfl":"2511","type":"游戏","time":"0-3"}
{"rank":95,"title":"欧洲资本积累到底有多肮脏？揭秘罪恶的黑奴贸易历史书为何只字不提？","dzl":"8.1","bfl":"77.8","zfl":"3752","type":"生活","time":"10+"}
{"rank":38,"title":"永不停息的制裁华为能否王者归来？","dzl":"16.0","bfl":"128.1","zfl":"3785","type":"知识","time":"8-10"}
{"rank":12,"title":"章鱼哥疯了","dzl":"10.2","bfl":"425.1","zfl":"1550","type":"游戏","time":"10+"}
{"rank":13,"title":"当你以游戏的方式打开军训","dzl":"18.6","bfl":"146.8","zfl":"11000","type":"生活","time":"8-10"}
{"rank":14,"title":"这下终于听懂秀才的小曲了","dzl":"17.7","bfl":"233.5","zfl":"9093","type":"搞笑","time":"0-3"}
{"rank":15,"title":"【毕导】这个视频里说的都是真的但你却永远无法证明","dzl":"32.3","bfl":"436.4","zfl":"35000","type":"知识","time":"10+"}
{"rank":16,"title":"【冰冰vlog.011】总要在烟雨青天去趟江南吧","dzl":"15.7","bfl":"150.3","zfl":"15000","type":"生活","time":"8-10"}
{"rank":17,"title":"【深度科普】长期摆烂如何恢复体能？","dzl":"9.9","bfl":"135.9","zfl":"12000","type":"运动","time":"5-8"}
{"rank":18,"title":"恋与提瓦特空桃篇：谁让你是我命定的另一半","dzl":"16.3","bfl":"122.1","zfl":"9901","type":"动画","time":"3-5"}
{"rank":19,"title":"帮唐山一位身残志坚的大姐卖冰激凌","dzl":"19.6","bfl":"134.2","zfl":"2845","type":"生活","time":"3-5"}
{"rank":20,"title":"350元一桶巨型泡面！新晋“天价网红泡面”值不值？？？","dzl":"13.5","bfl":"270.4","zfl":"1517","type":"美食","time":"10+"}
{"rank":21,"title":"深夜抢救我爸被喷一脸血怕得病猛搓脸找药吃","dzl":"21.1","bfl":"239.2","zfl":"1103","type":"生活","time":"5-8"}
{"rank":22,"title":"新铁锅怎么开锅更好用酒店大厨教你诀窍保证不锈不粘锅","dzl":"22.2","bfl":"425.3","zfl":"7099","type":"美食","time":"0-3"}
{"rank":94,"title":"九小时畅享听完一整本书不是一剪梅！书荒丨小说","dzl":"2.0","bfl":"119.8","zfl":"88","type":"动画","time":"10+"}
{"rank":23,"title":"潮汕大妈在北美说唱圈里的生意经","dzl":"21.9","bfl":"417.8","zfl":"1106","type":"生活","time":"3-5"}
{"rank":93,"title":"再次出发","dzl":"13.7","bfl":"104.6","zfl":"3630","type":"知识","time":"0-3"}
{"rank":24,"title":"万人雪书的长视频终于来啦！架不住你们天天催啊花了好多时间呜呜呜～","dzl":"25.6","bfl":"376.5","zfl":"4181","type":"生活","time":"8-10"}
{"rank":92,"title":"2023年8月热歌榜TOP50今夕是何年？难以置信这是2023年？","dzl":"6.7","bfl":"92.1","zfl":"3226","type":"音乐","time":"10+"}
{"rank":25,"title":"《明日方舟》SideStory「不义之财」活动宣传PV","dzl":"14.1","bfl":"172.7","zfl":"36000","type":"游戏","time":"5-8"}
{"rank":26,"title":"当中二青年来买单！(猜不到结局版）","dzl":"22.3","bfl":"235.5","zfl":"18000","type":"影视","time":"3-5"}
{"rank":91,"title":"日本排海为何中国网友互喷？日本政府是如何正当化排海的？","dzl":"6.4","bfl":"70.7","zfl":"7570","type":"知识","time":"10+"}
{"rank":90,"title":"她似了又活了。她没似他似了所以她也似了。她又活了可他们似了所以她又似了。","dzl":"8.0","bfl":"46.5","zfl":"7960","type":"搞笑","time":"3-5"}
{"rank":28,"title":"宿舍规则怪谈","dzl":"27.1","bfl":"205.1","zfl":"5178","type":"搞笑","time":"10+"}
{"rank":89,"title":"光头强家里捡的","dzl":"0.4","bfl":"320.9","zfl":"14","type":"动画","time":"8-10"}
{"rank":88,"title":"全网首拆！麒麟 5G 确认回归 | 华为 Mate 60 Pro","dzl":"56.2","bfl":"703.5","zfl":"90000","type":"知识","time":"10+"}
{"rank":29,"title":"穷小子强行与富少爷交换人生本想荣华富贵哪知少爷家里更是离谱！","dzl":"17.7","bfl":"288.5","zfl":"2355","type":"动画","time":"3-5"}
{"rank":87,"title":"我精神状态完全没有出问题的啦！！！","dzl":"16.4","bfl":"127.9","zfl":"4622","type":"动画","time":"0-3"}
{"rank":30,"title":"一个疯子却获得了诺贝尔奖真实故事改编高分电影《美丽心灵》","dzl":"12.5","bfl":"329.1","zfl":"3109","type":"影视","time":"10+"}
{"rank":86,"title":"最诡异的一局","dzl":"11","bfl":"101.4","zfl":"1702","type":"游戏","time":"3-5"}
{"rank":85,"title":"拥有几十台能上路的经典老车是什么样的体验？","dzl":"9.8","bfl":"163.4","zfl":"1669","type":"知识","time":"3-5"}
{"rank":31,"title":"这款游戏出现在21世纪还是太迷幻了","dzl":"12.5","bfl":"114.6","zfl":"1791","type":"游戏","time":"10+"}
{"rank":84,"title":"史上最好的原神模组！！（boss篇）","dzl":"8.7","bfl":"104.8","zfl":"8998","type":"游戏","time":"5-8"}
{"rank":32,"title":"关于下半身的生理知识没人告诉你这些！｜拉撒保姆级教程","dzl":"10.9","bfl":"100.1","zfl":"7921","type":"知识","time":"10+"}
{"rank":83,"title":"努力有错吗？学习有罪吗？高考没有一个韩国人敢退出的战争","dzl":"8.2","bfl":"168.7","zfl":"9989","type":"知识","time":"10+"}
{"rank":33,"title":"宝可梦日语OP大全【挪威小哥Pellek｜中字】","dzl":"11.7","bfl":"77.4","zfl":"3124","type":"音乐","time":"8-10"}
{"rank":82,"title":"不同年代的上班族白领都是怎么办公的？最后真的别演我工作状态哈哈哈哈！","dzl":"15.6","bfl":"147.5","zfl":"1688","type":"生活","time":"0-3"}
{"rank":81,"title":"我们分手了","dzl":"8.1","bfl":"241.4","zfl":"7008","type":"运动","time":"5-8"}
{"rank":39,"title":"老鼠们每天用捕鼠夹健身只为发动鼠界第三次世界大战","dzl":"19.2","bfl":"627.6","zfl":"10000","type":"影视","time":"10+"}
{"rank":40,"title":"大意了！这些不是全国统一的","dzl":"17.0","bfl":"219.7","zfl":"1325","type":"生活","time":"5-8"}
{"rank":41,"title":"青春没有售价米哈游贴脸开大","dzl":"28.6","bfl":"147.1","zfl":"29000","type":"游戏","time":"0-3"}
{"rank":42,"title":"早自习补作业事件","dzl":"29.0","bfl":"331.6","zfl":"5866","type":"影视","time":"0-3"}
{"rank":43,"title":"凌晨12.00教100个仙人掌唱歌没想到邻居找上门来了","dzl":"10.7","bfl":"330.0","zfl":"11000","type":"生活","time":"3-5"}
{"rank":44,"title":"这一次我们重新定义砖块","dzl":"24.7","bfl":"309.7","zfl":"5792","type":"生活","time":"0-3"}
{"rank":45,"title":"抗塔两分钟还是满血我没开玩笑！","dzl":"12.9","bfl":"279.4","zfl":"2197","type":"游戏","time":"5-8"}
{"rank":67,"title":"世界纪录保持者的拍摄间该怎么提升？","dzl":"9.3","bfl":"117.2","zfl":"2266","type":"知识","time":"10+"}
{"rank":68,"title":"一口气看完海贼王真人版第1季！1-8集！真人版符合你的预期吗？","dzl":"4.0","bfl":"238.6","zfl":"11000","type":"影视","time":"10+"}
{"rank":69,"title":"叶问之摆烂宗师","dzl":"9.2","bfl":"139.3","zfl":"10000","type":"搞笑","time":"5-8"}
{"rank":70,"title":"甲方花钱助我出道","dzl":"10.5","bfl":"78.4","zfl":"4665","type":"生活","time":"3-5"}
{"rank":71,"title":"秀 才 小 曲 最 骚 版 本","dzl":"12.9","bfl":"144.9","zfl":"3663","type":"搞笑","time":"0-3"}
{"rank":72,"title":"还原一下著名的《潘博文事件》","dzl":"21.8","bfl":"499.1","zfl":"5908","type":"生活","time":"3-5"}
{"rank":73,"title":"手持烟火以谋生 心怀诗意以谋爱","dzl":"15.3","bfl":"120.8","zfl":"5448","type":"动画","time":"0-3"}
{"rank":74,"title":"大家散伙！唐僧闹分手悟空为何大开杀戒？","dzl":"6.8","bfl":"101.4","zfl":"2224","type":"影视","time":"10+"}
{"rank":75,"title":"数学揭示万物密码 当然这还不够我们要去探访一下永恒。","dzl":"8.4","bfl":"132.2","zfl":"1487","type":"知识","time":"5-8"}
{"rank":76,"title":"如果2077的CV来配音《赛博朋克：边缘行者》（第八话）","dzl":"7.5","bfl":"57.5","zfl":"4243","type":"动画","time":"10+"}
{"rank":77,"title":"自己做的游戏终于发布了！赚了多少钱！？","dzl":"17.6","bfl":"155.7","zfl":"3834","type":"游戏","time":"0-3"}
{"rank":78,"title":"《要有自己的颜色》","dzl":"21.2","bfl":"199.9","zfl":"1782","type":"生活","time":"0-3"}
{"rank":79,"title":"买一块几十斤巨大安格斯上脑又被坑惨了涮麻辣火锅却爽翻了","dzl":"11.2","bfl":"136.6","zfl":"803","type":"美食","time":"8-10"}
{"rank":80,"title":"鹦鹉螺：我不是活化石","dzl":"14.3","bfl":"199.4","zfl":"1950","type":"知识","time":"10+"}
{"rank":27,"title":"【洛天依游学记原创曲】歌行四方 | AI歌手X非遗音乐","dzl":"10.4","bfl":"200.7","zfl":"5512","type":"音乐","time":"3-5"}
{"rank":46,"title":"我居然穿越回了10年前的B站！！！","dzl":"7.7","bfl":"116.6","zfl":"3811","type":"生活","time":"8-10"}
{"rank":47,"title":"陈Sir的工作日","dzl":"13.5","bfl":"110.8","zfl":"26000","type":"生活","time":"0-3"}
{"rank":48,"title":"干嘛啊","dzl":"24.0","bfl":"266.1","zfl":"7128","type":"生活","time":"0-3"}
{"rank":49,"title":"你看你又不敢对峙命运了吧！！！","dzl":"14.0","bfl":"97.8","zfl":"696","type":"游戏","time":"3-5"}
{"rank":50,"title":"我花1万块重庆打车到上海却被全国网友说成老赖","dzl":"15.3","bfl":"140.3","zfl":"10000","type":"生活","time":"10+"}
{"rank":51,"title":"摸 气 挑 战 （2）","dzl":"26.3","bfl":"247.7","zfl":"9562","type":"生活","time":"0-3"}
{"rank":52,"title":"仙人揉腹操九式详解版！做完大拉特拉","dzl":"7.9","bfl":"69.7","zfl":"14000","type":"运动","time":"0-3"}
{"rank":53,"title":"看着徒弟一点点长大逝去才发现长生是苦【我和徒弟03】","dzl":"5.6","bfl":"150.4","zfl":"618","type":"动画","time":"10+"}
{"rank":54,"title":"祝妹妹一路顺风","dzl":"25.4","bfl":"170.8","zfl":"18000","type":"生活","time":"0-3"}
{"rank":55,"title":"300w粉丝特别节目！拍了一些大家想看的但是也太怪了？","dzl":"12.3","bfl":"66.5","zfl":"710","type":"知识","time":"5-8"}
{"rank":56,"title":"爆肝几个星期我建出了最细节的海岛小镇！！！","dzl":"24.3","bfl":"214.8","zfl":"5545","type":"游戏","time":"5-8"}
{"rank":57,"title":"让巴黎看到国人的美","dzl":"24.4","bfl":"186.1","zfl":"784","type":"生活","time":"0-3"}
{"rank":58,"title":"村里来了新成员漠叔好心劝上学做社会有用的人","dzl":"11.9","bfl":"119.5","zfl":"1510","type":"美食","time":"10+"}
{"rank":59,"title":"《原神》角色演示-「菲米尼：海露幽响」","dzl":"11.7","bfl":"110.7","zfl":"7387","type":"游戏","time":"5-8"}
{"rank":61,"title":"当你碰到经验就会「瞬间暴毙」!!？","dzl":"10.0","bfl":"105.6","zfl":"554","type":"游戏","time":"10+"}
{"rank":62,"title":"大学开学时的各种人|大学学习","dzl":"9.0","bfl":"294.9","zfl":"224","type":"搞笑","time":"3-5"}
{"rank":63,"title":"都什么年代谁还用传统方式结义？！！","dzl":"9.0","bfl":"60.6","zfl":"3278","type":"搞笑","time":"10+"}
{"rank":64,"title":"【闽南婚宴】中式流水席天花板吃过一辈子忘不掉。","dzl":"39.1","bfl":"393.2","zfl":"6.5","type":"美食","time":"10+"}
{"rank":65,"title":"口腔溃疡为什么是白色的？","dzl":"18.1","bfl":"318.9","zfl":"3562","type":"知识","time":"3-5"}
{"rank":66,"title":"我今年拼过最牛的积木！（上）","dzl":"7.8","bfl":"172.8","zfl":"8298","type":"动画","time":"10+"}
{"rank":60,"title":"【太君の噩梦】打服日本一战成名比你想象的更夸张！苏联军神朱可夫","dzl":"10.7","bfl":"130.1","zfl":"1218","type":"知识","time":"10+"}

上传原始数据

hdfs dfs -mkdir -p /video/data

hdfs dfs -put data.json /video/data

hdfs dfs -cat /video/data/data.json

视频类别占比

Echarts

json数据格式

[
    {
        "name": "影视",
        "value": 9
    },
    {
        "name": "搞笑",
        "value": 14
    },
    {
        "name": "美食",
        "value": 7
    },
    {
        "name": "生活",
        "value": 25
    },
    {
        "name": "知识",
        "value": 16
    },
    {
        "name": "动画",
        "value": 10
    },
    {
        "name": "游戏",
        "value": 13
    },
    {
        "name": "运动",
        "value": 3
    },
    {
        "name": "音乐",
        "value": 3
    }
]

视频时长占比

Echarts

json数据格式

[
    {
        "name": "3-5",
        "value": 19
    },
    {
        "name": "5-8",
        "value": 16
    },
    {
        "name": "10+",
        "value": 34
    },
    {
        "name": "0-3",
        "value": 23
    },
    {
        "name": "8-10",
        "value": 8
    }
]

视频类别播放量和点赞量

Echarts

json数据格式

{
    "dzlList": [
        "195.0",
        "362.6",
        "154.7",
        "458.7",
        "252.5",
        "103.4",
        "201.9",
        "25.9",
        "28.8"
    ],
    "bflList": [
        "3009.1",
        "3506.5",
        "1691.9",
        "5348.0",
        "3108.9",
        "1605.0",
        "2234.7",
        "447.0",
        "370.2"
    ],
    "catList": [
        "影视",
        "搞笑",
        "美食",
        "生活",
        "知识",
        "动画",
        "游戏",
        "运动",
        "音乐"
    ]
}

视频类别点赞率

Echarts

json数据格式

{
    "catList": [
        "影视",
        "搞笑",
        "美食",
        "生活",
        "知识",
        "动画",
        "游戏",
        "运动",
        "音乐"
    ],
    "dzpList": [
        "6.48",
        "10.34",
        "9.14",
        "8.58",
        "8.12",
        "6.44",
        "9.03",
        "5.79",
        "7.78"
    ]
}

在HDFS上准备业务数据

vim data.json

hdfs dfs -mkdir -p /video/data

hdfs dfs -put data.json /video/data/data.json

hdfs dfs -cat /video/data/data.json

数据清洗

原始数据 video.json 格式

{"rank":1,"title":"《逃出大英博物馆》第二集","dzl":"77.8","bfl":"523.9","zfl":"39000","type":"影视","time":"3-5"}

清洗后数据 video.csv 格式

1,《逃出大英博物馆》第二集,77.8,523.9,39000,影视,3-5

javabean

package cn.lhz.video;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

/**
 * 数据清洗的序列化类
 *
 * @author 李昊哲
 * @version 1.0.0
 */
@Setter
@Getter
@NoArgsConstructor
@AllArgsConstructor
public class Video {
  /**
   * 视频编号
   */
  private int rank;
  /**
   * 视频标题
   */
  private String title;
  /**
   * 视频点赞量
   */
  private String dzl;
  /**
   * 视频播放量
   */
  private String bfl;
  /**
   * 视频转发量
   */
  private String zfl;
  /**
   * 视频类型
   */
  private String type;
  /**
   * 视频时长
   */
  private String time;

  @Override
  public String toString() {
    return rank + "\t" + title + "\t" + dzl + "\t" + bfl + "\t" + zfl + "\t" + type + "\t" + time;
  }
}

ETL数据格式化

package cn.lhz.video;

import cn.lhz.util.json.jackson.JacksonUtils;
import cn.lhz.util.string.StringUtil;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.FileSystem;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.LongWritable;
import org.apache.hadoop.io.NullWritable;
import org.apache.hadoop.io.Text;
import org.apache.hadoop.mapreduce.Job;
import org.apache.hadoop.mapreduce.Mapper;
import org.apache.hadoop.mapreduce.lib.input.FileInputFormat;
import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;

import java.io.IOException;

/**
 * @author 李昊哲
 * @version 1.0.0
 */
public class DataFormat {
  /**
   * 原始数据清洗 mapper
   */
  public static class DataFormatMapper extends Mapper<LongWritable, Text, Text, NullWritable> {
    // 将转换后的结果封装为输出的 key
    private final Text outKey = new Text();
    // 输出的 value
    NullWritable outValue = NullWritable.get();

    @Override
    protected void map(LongWritable key, Text value, Mapper<LongWritable, Text, Text, NullWritable>.Context context) throws IOException, InterruptedException {
      try {
        String line = value.toString();
        // 将读取的内容转为 Video 对象
        Video video = JacksonUtils.json2bean(line, Video.class);
        // 将 对象 转为 csv 文件 格式字符串
        String csv = StringUtil.format2CSV(video);
        // 将转换后的结果封装为输出的 key
        outKey.set(csv);
        // 输出清洗的数据
        context.write(outKey, outValue);
      } catch (IllegalAccessException e) {
        throw new RuntimeException(e);
      }
    }
  }

  public static void main(String[] args) throws IOException, InterruptedException, ClassNotFoundException {
    // 设置环境变量 hadoop 用户名 为 root
    System.setProperty("HADOOP_USER_NAME", "root");

    // 参数配置对象
    Configuration conf = new Configuration();

    // 跨平台提交
    conf.set("mapreduce.app-submission.cross-platform", "true");

    // 本地运行
    // conf.set("mapreduce.framework.name", "local");

    // 设置默认文件系统为 本地文件系统
    // conf.set("fs.defaultFS", "file:///

    // 声明Job对象 就是一个应用
    Job job = Job.getInstance(conf, "video data format");

    // 指定当前Job的驱动类
    job.setJarByClass(DataFormat.class);

    // 指定当前Job的 Mapper
    job.setMapperClass(DataFormatMapper.class);
    // 设置 reduce 数量为 零
    job.setNumReduceTasks(0);

    // 设置 map 输出 key 的数据类型
    job.setMapOutputValueClass(Text.class);
    // 设置 map 输出 value 的数据类型
    job.setMapOutputValueClass(NullWritable.class);

    // 定义 map 输入的路径 注意：该路径默认为hdfs路径
    FileInputFormat.addInputPath(job, new Path("/video/data/data.json"));

    // 定义 map 输出数据持久化的路径 注意：该路径默认为hdfs路径
    Path path = new Path("/video/ods");

    FileSystem fs = path.getFileSystem(conf);
    if (fs.exists(path)) {
      fs.delete(path, true);
    }
    FileOutputFormat.setOutputPath(job, path);

    // 提交 job
    System.exit(job.waitForCompletion(true) ? 0 : 1);
  }
}

项目打包上传测试

项目打包

mvn package

上传 jar 文件到集群

scp target/mapreduce.jar root@lihaozhe01:

在集群上提交 job

hadoop jar mapreduce.jar cn.lhz.video.DataFormat

查看 job 执行结果

hdfs dfs -cat /video/ods/part-m-00000

视频占比代码

mapreduce统计

package cn.lhz.video;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.FileSystem;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.IntWritable;
import org.apache.hadoop.io.LongWritable;
import org.apache.hadoop.io.Text;
import org.apache.hadoop.mapreduce.Job;
import org.apache.hadoop.mapreduce.Mapper;
import org.apache.hadoop.mapreduce.Reducer;
import org.apache.hadoop.mapreduce.lib.input.FileInputFormat;
import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;

import java.io.IOException;

/**
 * 视频占比 计算
 *
 * @author 李昊哲
 * @version 1.0.0
 */
public class CategoryPercentJob {

  public static class CategoryPercentMapper extends Mapper<LongWritable, Text, Text, IntWritable> {
    // 输出的 key
    Text outKey = new Text();
    // 输出的 value
    IntWritable outValue = new IntWritable(1);

    @Override
    protected void map(LongWritable key, Text value, Mapper<LongWritable, Text, Text, IntWritable>.Context context) throws IOException, InterruptedException {
      // 读取文档一行内容 使用逗号分隔将 内容转为字符串数组
      String[] split = value.toString().split(",");
      // 获取字符串数组下标为5的元素封装为输出的key
      outKey.set(split[5]);
      // 输出数据
      context.write(outKey, outValue);
    }
  }

  public static class CategoryPercentReducer extends Reducer<Text, IntWritable, Text, IntWritable> {
    // 输出的 value
    IntWritable outValue = new IntWritable();

    @Override
    protected void reduce(Text key, Iterable<IntWritable> values, Reducer<Text, IntWritable, Text, IntWritable>.Context context) throws IOException, InterruptedException {
      int sum = 0;
      for (IntWritable val : values) {
        sum += val.get();
      }
      outValue.set(sum);
      context.write(key, outValue);
    }
  }

  public static void main(String[] args) throws IOException, InterruptedException, ClassNotFoundException {
    // 设置环境变量 hadoop 用户名 为 root
    System.setProperty("HADOOP_USER_NAME", "root");

    // 参数配置对象
    Configuration conf = new Configuration();

    // 跨平台提交
    conf.set("mapreduce.app-submission.cross-platform", "true");

    // 本地运行
    // conf.set("mapreduce.framework.name", "local");

    // 设置默认文件系统为 本地文件系统
    // conf.set("fs.defaultFS", "file:///

    // 声明Job对象 就是一个应用
    Job job = Job.getInstance(conf, "video category percent");

    // 指定当前Job的驱动类
    job.setJarByClass(CategoryPercentJob.class);

    // 本地提交启用该行

    // 指定当前Job的 Mapper
    job.setMapperClass(CategoryPercentMapper.class);
    // 指定当前Job的 Combiner 注意：一定不能影响最终计算结果 否则 不使用
    job.setCombinerClass(CategoryPercentReducer.class);
    // 指定当前Job的 Reducer
    job.setReducerClass(CategoryPercentReducer.class);

    // 设置 reduce 数量为 零
    // job.setNumReduceTasks(0);
    // 设置 map 输出 key 的数据类型
    job.setMapOutputValueClass(Text.class);
    // 设置 map 输出 value 的数据类型
    job.setMapOutputValueClass(IntWritable.class);

    // 设置 map 输出 key 的数据类型
    job.setMapOutputValueClass(Text.class);
    // 设置 map 输出 value 的数据类型
    job.setMapOutputValueClass(IntWritable.class);

    // 设置 reduce 输出 key 的数据类型
    job.setOutputKeyClass(Text.class);
    // 设置 reduce 输出 value 的数据类型
    job.setOutputValueClass(IntWritable.class);

    // 定义 map 输入的路径 注意：该路径默认为hdfs路径
    FileInputFormat.addInputPath(job, new Path("/video/ods/part-m-00000"));
    // 定义 reduce 输出数据持久化的路径 注意：该路径默认为hdfs路径
    Path path = new Path("/video/dwd");

    // 获取 HDFS 连接
    FileSystem fs = path.getFileSystem(conf);
    if (fs.exists(path)) {
      fs.delete(path, true);
    }

    FileOutputFormat.setOutputPath(job, path);
    // 提交 job
    System.exit(job.waitForCompletion(true) ? 0 : 1);
  }
}

项目打包上传测试

项目打包

mvn package

上传 jar 文件到集群

scp target/mapreduce.jar root@lihaozhe01:

在集群上提交 job

hadoop jar mapreduce.jar cn.lhz.video.CategoryPercentJob

查看 job 执行结果

hdfs dfs -cat /video/dwd/part-r-00000

数据写入数据库

创建数据表
create database bigdata;
use bigdata;
create table category_percent(
    name varchar(50) comment '视频类别名称',
    value int unsigned comment '视频数量'
) comment '视频类别占比信息表';
javabean
package cn.lhz.video;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import org.apache.hadoop.mapreduce.lib.db.DBWritable;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 视频占比
 *
 * @author 李昊哲
 * @version 1.0.0
 */
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
public class CategoryPercent implements DBWritable {
  /**
   * 视频类型
   */
  private String name;
  /**
   * 视频数量
   */
  private int value;

  @Override
  public void write(PreparedStatement preparedStatement) throws SQLException {
    preparedStatement.setString(1, this.name);
    preparedStatement.setInt(2, this.value);
  }

  @Override
  public void readFields(ResultSet resultSet) throws SQLException {
    this.name = resultSet.getString(1);
    this.value = resultSet.getInt(2);
  }
}
job类
package cn.lhz.video;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.LongWritable;
import org.apache.hadoop.io.NullWritable;
import org.apache.hadoop.io.Text;
import org.apache.hadoop.mapred.lib.db.DBConfiguration;
import org.apache.hadoop.mapreduce.Job;
import org.apache.hadoop.mapreduce.Mapper;
import org.apache.hadoop.mapreduce.lib.db.DBOutputFormat;
import org.apache.hadoop.mapreduce.lib.input.FileInputFormat;

import java.io.IOException;

/**
 * 视频类别占比 写入到数据库
 *
 * @author 李昊哲
 * @version 1.0.0
 */
public class CategoryPercentWriteDB {
  public static class CategoryPercentMapper extends Mapper<LongWritable, Text, CategoryPercent, NullWritable> {
    /**
     * 输出的 key
     */
    CategoryPercent outKey = new CategoryPercent();
    /**
     * 输出的 value
     */
    NullWritable outValue = NullWritable.get();

    @Override
    protected void map(LongWritable key, Text value, Mapper<LongWritable, Text, CategoryPercent, NullWritable>.Context context) throws IOException, InterruptedException {
      String[] split = value.toString().split("\t");
      outKey.setName(split[0]);
      outKey.setValue(Integer.parseInt(split[1]));
      context.write(outKey, outValue);
    }
  }
  public static void main(String[] args) throws IOException, InterruptedException, ClassNotFoundException {
    // 设置环境变量 hadoop 用户名 为 root
    System.setProperty("HADOOP_USER_NAME", "root");

    // 参数配置对象
    Configuration conf = new Configuration();

    // 跨平台提交
    conf.set("mapreduce.app-submission.cross-platform", "true");

    // 本地运行
    // conf.set("mapreduce.framework.name", "local");

    // 设置默认文件系统为 本地文件系统
    // conf.set("fs.defaultFS", "file:///");

    // 配置JDBC 参数
    DBConfiguration.configureDB(conf,
        "com.mysql.cj.jdbc.Driver",
        "jdbc:mysql://lihaozhe03:3306/hadoop?allowPublicKeyRetrieval=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=UTF8&useSSL=false&useServerPrepStmts=false&rewriteBatchedStatements=true&cachePrepStmts=true&allowMultiQueries=true&serverTimeZone=Asia/Shanghai&sslMode=DISABLED",
        "root", "Lihaozhe!!@@1122");

    // 声明Job对象 就是一个应用
    Job job = Job.getInstance(conf, "CategoryPercent write db");

    // 指定当前Job的驱动类
    // 本地提交 注释该行
    job.setJarByClass(CategoryPercentWriteDB.class);

    // 本地提交启用该行
    // job.setJar("F:\\新疆大学\\code\\bigdata2024\\bigdata\\hadoop\\target\\hadoop.jar");

    // 指定当前Job的 Mapper
    job.setMapperClass(CategoryPercentMapper.class);

    // 设置 reduce 数量为 零
    job.setNumReduceTasks(0);

    // 设置 map 输出 key 的数据类型
    job.setMapOutputValueClass(CategoryPercent.class);
    // 设置 map 输出 value 的数据类型
    job.setMapOutputValueClass(NullWritable.class);

    // 定义 map 输入的路径 注意：该路径默认为hdfs路径
    FileInputFormat.addInputPath(job, new Path("/video/dwd/part-r-00000"));

    // 设置输出类
    job.setOutputFormatClass(DBOutputFormat.class);

    // 将数据写入到数据表
    DBOutputFormat.setOutput(job, "category_percent", "name", "value");

    // 提交 job
    System.exit(job.waitForCompletion(true) ? 0 : 1);
  }
}
项目打包上传测试

项目打包

mvn package

上传 jar 文件到集群

scp target/mapreduce.jar root@lihaozhe01:

集群提交 job

hadoop jar mapreduce.jar cn.lhz.video.CategoryPercentWriteDB

遇到以下报错，原因是 hadoop 集群上没有 MySQL驱动

Error: java.io.IOException: com.mysql.cj.jdbc.Driver
	at org.apache.hadoop.mapreduce.lib.db.DBOutputFormat.getRecordWriter(DBOutputFormat.java:197)
	at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.<init>(MapTask.java:660)
	at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:780)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:348)
	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:178)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1899)
	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:172)

上传 MySQL 驱动到 $HADOOP_HOME/share/hadoop/common/lib

mysql-connector-j-9.1.0.jar

protobuf-java-4.28.3.jar

将 MySQL 驱动同步到集群其它节点

scp $HADOOP_HOME/share/hadoop/common/lib/mysql-connector-j-9.1.0.jar root@lihaozhe02:$HADOOP_HOME/share/hadoop/common/lib/
scp $HADOOP_HOME/share/hadoop/common/lib/mysql-connector-j-9.1.0.jar root@lihaozhe03:$HADOOP_HOME/share/hadoop/common/lib/
scp $HADOOP_HOME/share/hadoop/common/lib/protobuf-java-4.28.3.jar root@lihaozhe02:$HADOOP_HOME/share/hadoop/common/lib/
scp $HADOOP_HOME/share/hadoop/common/lib/protobuf-java-4.28.3.jar root@lihaozhe03:$HADOOP_HOME/share/hadoop/common/lib/

推荐重启集群后重新提交job

hadoop jar hadoop.jar cn.lhz.video.CategoryPercentWriteDB

数据传输

创建数据表
create database bigdata_view;
use bigdata_view;
create table category_percent(
	name varchar(50) comment '视频类别名称',
	value int unsigned comment '视频数量'
) comment '视频类别占比信息表';
jdbc
package cn.lhz.video;

import com.mysql.cj.jdbc.Driver;

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

/**
 * 同步视频类别占比数据到可视化数据表中
 *
 * @author 李昊哲
 * @version 1.0.0
 */
public class CategoryPercentCopyDB {

  public static void main(String[] args) throws SQLException {
    List<CategoryPercent> list = select();
    insert(list);
  }

  /**
   * 大数据业务员部门将 视频类别占比数据查询出来
   *
   * @return 视频类别占比数据
   */
  public static List<CategoryPercent> select() throws SQLException {
    List<CategoryPercent> list = new ArrayList<CategoryPercent>();
    String url = "jdbc:mysql://lihaozhe03:3306/bigdata?allowPublicKeyRetrieval=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=UTF8&useSSL=false&useServerPrepStmts=false&rewriteBatchedStatements=true&cachePrepStmts=true&allowMultiQueries=true&serverTimeZone=Asia/Shanghai&sslMode=DISABLED";
    String user = "root";
    String password = "Lihaozhe!!@@1122";
    String sql = "select name,value from category_percent";
    DriverManager.registerDriver(new Driver());
    Connection conn = DriverManager.getConnection(url, user, password);
    PreparedStatement pst = conn.prepareStatement(sql);
    ResultSet rs = pst.executeQuery();
    CategoryPercent percent = null;
    while (rs.next()) {
      percent = new CategoryPercent();
      percent.setName(rs.getString("name"));
      percent.setValue(rs.getInt("value"));
      list.add(percent);
    }
    rs.close();
    pst.close();
    conn.close();
    return list;
  }

  /**
   * 将视频类别占比数据 写入到数据可视化部门的数据表中
   *
   * @param list 视频类别占比数据
   */
  public static void insert(List<CategoryPercent> list) throws SQLException {
    String url = "jdbc:mysql://lihaozhe03:3306/bigdata_view?allowPublicKeyRetrieval=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=UTF8&useSSL=false&useServerPrepStmts=false&rewriteBatchedStatements=true&cachePrepStmts=true&allowMultiQueries=true&serverTimeZone=Asia/Shanghai&sslMode=DISABLED";
    String user = "root";
    String password = "Lihaozhe!!@@1122";
    String sql = "insert into category_percent values(?,?)";
    DriverManager.registerDriver(new Driver());
    Connection conn = DriverManager.getConnection(url, user, password);
    conn.setAutoCommit(false);
    PreparedStatement pst = conn.prepareStatement(sql);
    int i = 0;
    for (CategoryPercent percent : list) {
      pst.setString(1, percent.getName());
      pst.setInt(2, percent.getValue());
      i = pst.executeUpdate();
    }
    if (i > 0) {
      conn.commit();
    } else {
      conn.rollback();
    }
    pst.close();
    conn.close();
  }
}

数据可视化

echarts图表

Echarts

ai智能视频智能分析系统
sxyxhwl的博客
11-01 934
智能AI行为识别分析监控系统，能主动识别场景内各种求救事件、打架事件、摔倒事件、闯入事件、攀爬事件，一旦被监控摄像机扑捉到类似行为，立即预警给监控中心，监控中心可以快速做出反应，及时防范，阻止事态恶化。利用计算机图像视觉分析技术理解视频画面内容，系统将图像处理、模式识别、智能分析以及信号处理等先进算法技术融入多元化场景中，通过算法优化分离场景背景与目标，从海量图像中自动发现、分析人的异常行为并立即进行处理，实现包括入侵检测、围墙翻越检测、群体事件检测、离岗检测等行为识别。注：以下内容跟正文无关。
视频行为分析系统，可做安全行为检测，比如周界入侵，打架
一个爱编程的人专栏
01-22 934
基于视频行为分析系统v4系列版本可以在不用考虑流媒体音视频开发，编解码开发，界面开发等情况下， 只需要训练自己的模型，开发自己的行为算法插件，就可以轻松开发出任何你想要的安全行为检测，比如周界入侵，打架，斗殴，跌倒，人群聚集，离岗睡岗，安全帽检测，充电桩，工作服， 疲劳检测，交通拥堵等等。从v4.24版本开始，该软件已经支持Windows10，Windows11，Ubuntu20，Ubuntu21，Ubuntu22，Ubuntu23。注：当前仅提供Windows版编译安装包，其他平台编译请联系作者。
基于大数据的视频智能分析系统的应用
06-20
大数据技术在营销、金融等行业用来分析客户行为指导精准营销,已经取得了广泛成功。但是在视频监控领域应用发展十分迟缓,其主要原因就是视频监控领域的核心数据是视频是非结构化数据,无法直接使用成熟的大数据软件进行分析处理。对此,首先对大数据技术进行了介绍,并对大数据技术在视频智能分析领域应用进行详细探究,以期促进视频大数据在平安城市建设的应用。
一款视频行为分析系统，可轻松开发安全行为检测
欧菲丽的博客
12-19 2410
基于视频行为分析系统v4系列版本可以在不用考虑流媒体音视频开发，编解码开发，界面开发等情况下， 只需要训练自己的模型，开发自己的行为算法插件，就可以轻松开发出任何你想要的安全行为检测，比如周界入侵，打架，斗殴，跌倒，人群聚集，离岗睡岗，安全帽检测，充电桩，工作服， 疲劳检测，交通拥堵等等。（当前仅提供Windows版编译安装包，其他平台编译请联系作者）
基于人工智能的智能视频内容分析系统
m0_61057267的博客
03-15 463
目录下生成处理结果。请确保在运行前将示例视频放在。系统使用YAML格式的配置文件，位于。
行人检测与行人再标识
m0_49367516的博客
04-16 779
视频监控采集的视频图像数据具有极高的价值。基于沃达德大数据平台，通过对海量数据采集、处理、存储、分析和数据挖掘，根据数据的特性，采用合适的可视化方式，将数据直观地展现出来，以帮助人们认识数据、理解数据，同时找出包含在海量数据中的规律或者信息，预测未来发展趋势，进行智能化决策分析，使得数据资产成为核心竞争力。人工智能是计算机科学与技术专业的一门重要的专业课程，运用计算机模拟和延伸人脑功能，模仿人脑所从事的推理、识别、理解、设计、学习、思考等思维活动，以此解决预测、规划等需要人类专家才能处理的复杂问题。
智能视频分析系统 PVG-VA
weixin_34199405的博客
06-08 390
智能视频分析系统PVG-VA 智能视频分析系统 PVG-VA 系统概述 视频应用的早期阶段，用户关注的是摄像机数量的建设，并逐步通过数字化和网络实现视频的联网和存储，但随着视频资源 的逐步增多，用户开始关注如何从海量的信息中提取真正有效的信息，为安全防范、可视化管理提供决策信息，而视频内容分析（Vision Analysis）...
视频智能行为分析系统 YOLOv3
燧机科技的博客
06-29 528
视频智能行为分析系统可以借助现场已有的不同品牌的监控摄像机开展实时分析识别，视频智能行为分析系统以检验视频监控画面中身体构造的行为形态为载体，从了四个维度：时间、行为、人数和方向多个维度对现场作业人员进行识别分析，如：非法闯入、倒地事件、打架事件、离岗检测、睡岗检测、抽烟识别、攀高检测、安全帽佩戴检测、反光衣识别、高空作业安全带识别等等，方便后面向三方平台消息推送预警图片、视频和警报统计分析分析信息内容。
基于DeepFM、Hadoop、Spark的微信视频号大数据分析与推荐系统毕业设计项目
05-20
1.采用Hadoop作为分布式文件文件系统存储数据 2.基于 TensorFlow 复现论文 PNN、DeepFM 3.搭建推荐系统架构，召回、过滤、精排阶段 4.使用 SparkStreaming 进行流计算，不断将用户行为反馈给模型进行计算，提供 下一...
基于Hadoop豆瓣电影数据分析实验报告
06-16
【基于Hadoop豆瓣电影数据分析实验报告】 在大数据时代，对海量信息进行高效处理和分析是企业决策的关键。Hadoop作为一款强大的分布式计算框架，自2006年诞生以来，已经在多个领域展现了其卓越的数据处理能力。本...
基于Hadoop的校园智能视频分析系统应用.pdf
09-13
【基于Hadoop的校园智能视频分析系统应用】 随着信息技术的发展，智能视频监控系统在校园安全防范中发挥着越来越重要的作用。然而，随着高清摄像头的普及，监控视频数据呈现出海量增长的趋势，这给数据存储和分析...
视频智能分析系统EasyCVR视频流媒体安防监控云服务实现城市视频智能化应用
TSINGSEE青犀视频官方技术博客
11-27 1440
在互联网、物联网、大数据、人工智能引领新经济发展时，智慧城市成了城市发展破冰前行的利刃。而随着经济发展的需求和科学技术的进步，传统的电视监控因其具有不够精确等特点，已被新型的智能视频监控技术逐渐替代。在智慧城市建设持续纵深推进的同时，由于算法准确率和环境适应性的不断提高，将促使智能视频分析技术应用的大规模部署，智能视频分析技术的应用将越来越普遍。 TSINGSEE青犀视频研发团队为了满足智慧城市对智能视频分析的需求，自主研发了EasyCVR视频智能分析结构化平台，将前端视频流信息处理成数据信息，传输至
视频动作行为分析
01-25
为了解决当前视频监控系统对异常行为检测精度与自我学习能力较弱的问题，提出了基于光流场分析与深度学习的视频监控方法。首先，引入光流场检测算法，利用图像序列中目标像素的强度数据时域变化来确定运动行为是否异常，从而建立视频目标行为识别算子，获取异常行为光流特征; 并利用卷积神经网络对光流特征进行逐层训练，设计自我学习机制，增强系统对异常行为的检出率; 最后，基于．NET 平台与 Accord 开源库，对本文监控系统进行实现。
AI视频分析系统的必要性
qq_41269324的博客
08-06 720
AI视频分析、设备监控、智慧消防、能耗管理、摄像头离线监测、工单管理、物联网
视频行为智能分析系统 YOLOv8
燧机科技的博客
07-10 495
视频行为智能分析系统可以对现场监控画面视频流自动识别，视频行为智能分析系统实时分辨监控画面中违规行为情况，视频行为智能分析统发现问题后会主动抓拍预警现场同步有声音提示，能够对现场作业岗位开展状态异常检测，全天候监控现场人员打电话、睡岗、玩手机、离岗、抽烟等行为进行识别，一旦发现，马上抓拍警报。
视频智能动作行为分析系统带你了解：动作捕捉与行为分析
t05777的博客
06-20 875
什么是动作捕捉？顾名思义，动作捕捉指的是一种可以能够实时准确的测量、可以记录物体在作业过程中的运动轨迹和姿态。什么是行为分析？行为分析，是在动作捕捉的基础上，对物体的运动轨迹或者直接的说是对现场岗位员工动作情况的一个分析。 ​视频智能动作行为分析系统带你了解：动作捕捉与行为分析对于制造行业来说，做好现场岗位人员的动作、行为分析可以有效的提升生产作业效率。在一定程度上实现单位时间内的产出增加。而需要实现动作捕捉与行为分析，可以通过人工和软件这两个方式进行，随着当下市场端信息化、数字化的发展，越来越多的用户倾向
xcms：视频行为分析系统，轻松实现智能监控
最新发布
gitblog_00339的博客
03-30 293
xcms：视频行为分析系统，轻松实现智能监控 xcms C++开发的视频行为分析系统v4版本 项目地址: https://gitcode.com/gh_mirrors/xcm/xcms ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

李昊哲小课

桃李不言下自成蹊

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值