大家好,我是小孟!
我是一个大龄程序员,90后。今年35了。
每当看到招聘不招35岁以上的程序员,就慌的一b。
码代码占据了我大部分的时间,除了代码养家,
【java学习|喜欢看球,那就手撸一个看球小程序系统】篮球给我带来了很多的快乐,比女友还快乐!
“穿上球衣,穿上球鞋,叫上兄弟们!
一起出来打球,打完篮球,坐在夕阳下,喝着一块一瓶的水,聊着自己喜欢的女孩”
文章图片
练球虽累,但他不苦。姑娘虽美,但我不配。故事很长,也不难讲。打完这场球,再谈理想。
篮球虐我千百遍,我待篮球如初恋!
作为一名码农,这几天因疫情在家隔离,闲的没事,手撸了一个篮球小程序系统。
目录
- 一,系统展示
- 二,小程序端代码
- 三,后端代码
- 四,数据库
- 五,手把手教你学习
一,系统展示
文章图片
文章图片
文章图片
文章图片
文章图片
文章图片
文章图片
二,小程序端代码
在这里插
欢迎围观小孟朋友圈,我的V:jishulearn
{{article.articleTitle}}
{{article.articleDate}}
{{article.articleContent}}
评论
{{article.commentList.length}}
{{comment.userName}}
{{comment.comTime}}
{{comment.commentStr}}
入代码片
{{item.gameDate}}
{{item.gameTime}}
{{item.gameName}}
>{{item.team_1}}
>{{item.team_2}}
{{item.team_1_score}}
{{item.team_2_score}}
-
-
>{{vLive_text}}
>{{pLive_text}}
>未开始
没有预约比赛
三,后端代码
/**
* articleController
* @author 小孟V:jishulearn
* @version 2022-02-13
*/
@Controller
@RequestMapping(value = "https://www.it610.com/article/${adminPath}/article/article")
public class ArticleController extends BaseController { @Autowired
private ArticleService articleService;
/**
* 获取数据
*/
@ModelAttribute
public Article get(String id, boolean isNewRecord) {
return articleService.get(id, isNewRecord);
}
/**
* 查询列表
*/
@RequiresPermissions("article:article:view")
@RequestMapping(value = https://www.it610.com/article/{"list", ""})
public String list(Article article, Model model) {
model.addAttribute("article", article);
return "modules/article/articleList";
}
/**
* 查询列表数据
*/
@RequiresPermissions("article:article:view")
@RequestMapping(value = "https://www.it610.com/article/listData")
@ResponseBody
public Page listData(Article article, HttpServletRequest request, HttpServletResponse response) {
article.setPage(new Page<>(request, response));
Page page = articleService.findPage(article);
List articleList = new ArrayList<>();
for (Article article1 : page.getList()) {
List fileUploadList = FileUploadUtils.findFileUpload(article1.getId(),"article_image");
if (fileUploadList.size() > 0){
article1.setImgUrl(FileUploadUtils.findFileUpload(article1.getId(),"article_image").get(0).getFileUrl());
}
articleList.add(article1);
}
page.setList(articleList);
return page;
} /**
* 查看编辑表单
*/
@RequiresPermissions("article:article:view")
@RequestMapping(value = "https://www.it610.com/article/form")
public String form(Article article, Model model) {
model.addAttribute("article", article);
return "modules/article/articleForm";
} /**
* 保存i_article
*/
@RequiresPermissions("article:article:edit")
@PostMapping(value = "https://www.it610.com/article/save")
@ResponseBody
public String save(@Validated Article article) {
if(StringUtils.isEmpty(article.getId())) {
article.setArticleDate(new Date());
}
articleService.save(article);
return renderResult(Global.TRUE, text("保存i_article成功!"));
}
/**
* 删除i_article
*/
@RequiresPermissions("article:article:edit")
@RequestMapping(value = "https://www.it610.com/article/delete")
@ResponseBody
public String delete(Article article) {
articleService.delete(article);
return renderResult(Global.TRUE, text("删除i_article成功!"));
}
}
/**
* 赛事管理Controller
* @author 小孟V:jishulearn
* @version 2022-02-11
*/
@Controller
@RequestMapping(value = "https://www.it610.com/article/${adminPath}/match/match")
public class MatchController extends BaseController { @Autowired
private MatchService matchService;
@Autowired
private GameTypeService gameTypeService;
@Autowired
private TeamService teamService;
/**
* 获取数据
*/
@ModelAttribute
public Match get(String id, boolean isNewRecord) {
return matchService.get(id, isNewRecord);
}
/**
* 查询列表
*/
@RequiresPermissions("match:match:view")
@RequestMapping(value = https://www.it610.com/article/{"list", ""})
public String list(Match match, Model model) {
model.addAttribute("match", match);
return "modules/match/matchList";
}
/**
* 查询列表数据
*/
@RequiresPermissions("match:match:view")
@RequestMapping(value = "https://www.it610.com/article/listData")
@ResponseBody
public Page listData(Match match, HttpServletRequest request, HttpServletResponse response) {
match.setPage(new Page<>(request, response));
Page page = matchService.findPage(match);
List gameTypeList = gameTypeService.findList(new GameType());
List teamList = teamService.findList(new Team());
List matcheList = new ArrayList<>();
for (Match match1 : page.getList()) {
for (GameType gameType : gameTypeList) {
if (gameType.getId().equals(match1.getGameType())) {
match1.setGameType(gameType.getName());
}
}
matcheList.add(match1);
}
List matcheList1 = new ArrayList<>();
for (Match match1 : matcheList) {
for (Team team : teamList) {
if (team.getId().equals(match1.getHomeField())) {
match1.setHomeField(team.getName());
}
if (team.getId().equals(match1.getGuestField())) {
match1.setGuestField(team.getName());
}
}
matcheList1.add(match1);
}
page.setList(matcheList1);
return page;
} /**
* 查看编辑表单
*/
@RequiresPermissions("match:match:view")
@RequestMapping(value = "https://www.it610.com/article/form")
public String form(Match match, Model model) {
List gameTypeList = gameTypeService.findList(new GameType());
List teamList = teamService.findList(new Team());
model.addAttribute("match", match);
model.addAttribute("gameTypeList", gameTypeList);
model.addAttribute("teamList", teamList);
return "modules/match/matchForm";
} /**
* 保存赛事管理
*/
@RequiresPermissions("match:match:edit")
@PostMapping(value = "https://www.it610.com/article/save")
@ResponseBody
public String save(@Validated Match match) {
matchService.save(match);
return renderResult(Global.TRUE, text("保存赛事管理成功!"));
}
/**
* 删除赛事管理
*/
@RequiresPermissions("match:match:edit")
@RequestMapping(value = "https://www.it610.com/article/delete")
@ResponseBody
public String delete(Match match) {
matchService.delete(match);
return renderResult(Global.TRUE, text("删除赛事管理成功!"));
}
四,数据库
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for i_article
-- ----------------------------
DROP TABLE IF EXISTS `i_article`;
CREATE TABLE `i_article`(
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`article_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`article_date` datetime(0) NULL DEFAULT NULL,
`img_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`videoUrl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`article_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`match_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of i_article-- ----------------------------
-- Table structure for i_comment
-- ----------------------------
DROP TABLE IF EXISTS `i_comment`;
CREATE TABLE `i_comment`(
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`open_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`comment_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`com_time` datetime(0) NULL DEFAULT NULL,
`article_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of i_comment
-- ----------------------------
INSERT INTO `i_comment` VALUES ('1229650608296800256', 'oR9X80PNiduNcTgo7_AiwaGUO9G4', '123', '2020-02-18 14:15:25', '1227912896076685312');
-- ----------------------------
-- Table structure for i_game_type
-- ----------------------------
DROP TABLE IF EXISTS `i_game_type`;
CREATE TABLE `i_game_type`(
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- ----------------------------
-- Table structure for i_match
-- ----------------------------
DROP TABLE IF EXISTS `i_match`;
CREATE TABLE `i_match`(
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`home_field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主场',
`guest_field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客场',
`home_score` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '比分',
`guest_score` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`start_time` datetime(0) NULL DEFAULT NULL,
`game_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属赛事',
`game_type_a` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '赛事小分类',
`is_start` int(0) NULL DEFAULT NULL,
`highlight_name1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`highlight_name2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`highlight_name3` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`highlight_name4` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`highlight_u1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`highlight_u2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`highlight_u3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`highlight_u4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of i_match-- ----------------------------
-- Table structure for i_player
-- ----------------------------
DROP TABLE IF EXISTS `i_player`;
CREATE TABLE `i_player`(
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`player_thumb` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`player_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`team` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`score` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`assist` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`backboard` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`steal` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`block` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of i_player
-- ----------------------------
INSERT INTO `i_player` VALUES ('1228343814021251072', 'https://nba.sports.qq.com/media/img/players/head/260x190/203507.png', '托尼斯-阿德托昆博', '1228247876190314496', '30.0', '5.5', '13.5', '1.1', '1.1');
INSERT INTO `i_player` VALUES ('1228344572263333888', 'https://nba.sports.qq.com/media/img/players/head/260x190/202695.png', '莱昂纳德', '1227162154749386772', '27.2', '5.3', '7.4', '1.8', '0.7');
-- ----------------------------
-- Table structure for i_team
-- ----------------------------
DROP TABLE IF EXISTS `i_team`;
CREATE TABLE `i_team`(
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`icon` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`win_num` int(0) NULL DEFAULT NULL,
`lost_num` int(0) NULL DEFAULT NULL,
`location` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
五,手把手教你学习 前面分享了很多的项目、教程、面试题。
大家可以跟着学习。都是免费的。
给个三连(点赞+关注)和关注,一起变强,你点赞关注我,就算支持了小孟,当然我也会回报更多的给你。人和人之间都是相互的,嘿嘿……
项目给大家提供了。所有资料获取,点击下面的,关注弹出来的图片,
点击 然后回复:项目大全
推荐阅读
- Pygame实战|【Pygame实战】众志成城 同心战“疫”,为抗疫加油,只待春暖花开(附抗疫小游戏)
- Turtle|【Turtle系列】2022年春天限定(“樱你而来”带着喜欢的人一起去看一场粉色浪潮吧~)
- Python|【Turtle系列】端正心态正确面对疫情,守护安全防线不放松,共抗疫情,只待春来~
- Python|【Opencv实战】这是我见过的最强大“美颜滤镜”,代码美颜傻瓜式一键操作~(附源码)
- JavaWeb|基于Java开发的CMS内容管理系统
- JAVA|Spring boot 提示“Whitelabel Error Page”
- Spring|Spring Boot整合dubbo+Nacos实战(二)
- SpringBoot性能怎样优化
- 视频教程|Web 前端视频资源分享(Bootstrap/Vue/小程序)