大家好!我是职场程序猿,感谢您阅读本文,欢迎一键三连哦。
精彩专栏推荐👇🏻👇🏻👇🏻
开发环境
- 开发语言:java
- 框架:Hadoop,Scrapy,vue,springboot
- 数据库:mysql
- 数据库工具:Navicat
- 开发软件:eclipse/myeclipse/idea
- 浏览器:谷歌浏览器
演示视频
基于Hadoop的NBA球员大数据分析与可视化演示录像
论文目录
❤️【如需全文请按文末获取联系】
一、项目简介
本文基于Hadoop平台,针对NBA球员的大数据进行了分析和可视化。首先,通过数据采集和清洗,获取了包括球员个人信息、比赛数据、进球数据等多维度数据。然后,利用Hadoop集群进行数据处理和计算,包括统计各球员在不同场次中的表现指标,比如得分、篮板、助攻等。接着,通过数据可视化工具,如Tableau或matplotlib,对数据进行可视化展示,包括图表、雷达图、热力图等形式,以便进一步的数据分析和挖掘。通过这样的大数据分析与可视化方法,可以帮助球队教练和管理者更好地了解球员个人表现和团队整体水平,以做出更有效的战术和人员调整。
二、系统设计
2.1软件功能模块设计
系统总体结构图如下,见图4-1。
2.2数据库设计
如图4-3所示:
三、系统项目部分截图
3.1注册登陆功能
系统登录页面如图5-1所示。
系统注册页面如图5-2所示:
3.2管理员功能实现
管理员进入主页面,主要功能包括对系统首页、个人中心、用户管理、战绩排行管理、球员信息管理、系统管理等进行操作。管理员主页面如图5-3所示:
管理员进行爬取数据后,点击主页面右上角的看板,可以查看到队名得分、战绩排行、队名胜率、队名排名统计、球队统计、球员排名统计、分类统计等实时的分析图进行可视化管理;如图5-7所示:
四、部分核心代码
package com.controller;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;
import com.entity.ZhanjipaihangEntity;
import com.entity.view.ZhanjipaihangView;
import com.service.ZhanjipaihangService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MPUtil;
import com.utils.MapUtils;
import com.utils.CommonUtil;
import java.io.IOException;
/**
* 战绩排行
* 后端接口
* @author
* @email
* @date 2024-02-06 13:55:31
*/
@RestController
@RequestMapping("/zhanjipaihang")
public class ZhanjipaihangController {
@Autowired
private ZhanjipaihangService zhanjipaihangService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,ZhanjipaihangEntity zhanjipaihang,
HttpServletRequest request){
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
PageUtils page = zhanjipaihangService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zhanjipaihang), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,ZhanjipaihangEntity zhanjipaihang,
HttpServletRequest request){
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
PageUtils page = zhanjipaihangService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zhanjipaihang), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( ZhanjipaihangEntity zhanjipaihang){
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
ew.allEq(MPUtil.allEQMapPre( zhanjipaihang, "zhanjipaihang"));
return R.ok().put("data", zhanjipaihangService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(ZhanjipaihangEntity zhanjipaihang){
EntityWrapper< ZhanjipaihangEntity> ew = new EntityWrapper< ZhanjipaihangEntity>();
ew.allEq(MPUtil.allEQMapPre( zhanjipaihang, "zhanjipaihang"));
ZhanjipaihangView zhanjipaihangView = zhanjipaihangService.selectView(ew);
return R.ok("查询战绩排行成功").put("data", zhanjipaihangView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
ZhanjipaihangEntity zhanjipaihang = zhanjipaihangService.selectById(id);
return R.ok().put("data", zhanjipaihang);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
ZhanjipaihangEntity zhanjipaihang = zhanjipaihangService.selectById(id);
return R.ok().put("data", zhanjipaihang);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody ZhanjipaihangEntity zhanjipaihang, HttpServletRequest request){
//ValidatorUtils.validateEntity(zhanjipaihang);
zhanjipaihangService.insert(zhanjipaihang);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody ZhanjipaihangEntity zhanjipaihang, HttpServletRequest request){
//ValidatorUtils.validateEntity(zhanjipaihang);
zhanjipaihangService.insert(zhanjipaihang);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
public R update(@RequestBody ZhanjipaihangEntity zhanjipaihang, HttpServletRequest request){
//ValidatorUtils.validateEntity(zhanjipaihang);
zhanjipaihangService.updateById(zhanjipaihang);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
zhanjipaihangService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* (按值统计)
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}")
public R value(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
List<Map<String, Object>> result = zhanjipaihangService.selectValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计(多))
*/
@RequestMapping("/valueMul/{xColumnName}")
public R valueMul(@PathVariable("xColumnName") String xColumnName,@RequestParam String yColumnNameMul, HttpServletRequest request) {
String[] yColumnNames = yColumnNameMul.split(",");
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
for(int i=0;i<yColumnNames.length;i++) {
params.put("yColumn", yColumnNames[i]);
List<Map<String, Object>> result = zhanjipaihangService.selectValue(params, ew);
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
result2.add(result);
}
return R.ok().put("data", result2);
}
/**
* (按值统计)时间统计类型
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}/{timeStatType}")
public R valueDay(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
params.put("timeStatType", timeStatType);
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
List<Map<String, Object>> result = zhanjipaihangService.selectTimeStatValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计)时间统计类型(多)
*/
@RequestMapping("/valueMul/{xColumnName}/{timeStatType}")
public R valueMulDay(@PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,@RequestParam String yColumnNameMul,HttpServletRequest request) {
String[] yColumnNames = yColumnNameMul.split(",");
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("timeStatType", timeStatType);
List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
for(int i=0;i<yColumnNames.length;i++) {
params.put("yColumn", yColumnNames[i]);
List<Map<String, Object>> result = zhanjipaihangService.selectTimeStatValue(params, ew);
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
result2.add(result);
}
return R.ok().put("data", result2);
}
/**
* 分组统计
*/
@RequestMapping("/group/{columnName}")
public R group(@PathVariable("columnName") String columnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("column", columnName);
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
List<Map<String, Object>> result = zhanjipaihangService.selectGroup(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* 总数量
*/
@RequestMapping("/count")
public R count(@RequestParam Map<String, Object> params,ZhanjipaihangEntity zhanjipaihang, HttpServletRequest request){
EntityWrapper<ZhanjipaihangEntity> ew = new EntityWrapper<ZhanjipaihangEntity>();
int count = zhanjipaihangService.selectCount(MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zhanjipaihang), params), params));
return R.ok().put("data", count);
}
}
获取源码或论文
如需对应的论文或源码,以及其他定制需求,也可以下方微信联系我。