大家好，我是小孟！
我是一个大龄程序员，90后。今年35了。
每当看到招聘不招35岁以上的程序员，就慌的一b。
码代码占据了我大部分的时间，除了代码养家，
篮球给我带来了很多的快乐，比女友还快乐！
“穿上球衣，穿上球鞋，叫上兄弟们！
一起出来打球，打完篮球，坐在夕阳下，喝着一块一瓶的水，聊着自己喜欢的女孩”
练球虽累，但他不苦。姑娘虽美，但我不配。故事很长，也不难讲。打完这场球，再谈理想。
篮球虐我千百遍，我待篮球如初恋！
作为一名码农，这几天因疫情在家隔离，闲的没事，手撸了一个篮球小程序系统。
一，系统展示二，小程序端代码三，后端代码四，数据库五，手把手教你学习
一，系统展示
在这里插 欢迎围观小孟朋友圈，我的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}} 未开始 没有预约比赛
@Controller
@RequestMapping(value = "${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 = {"list", ""})
public String list(Article article, Model model) {
model.addAttribute("article", article);
return "modules/article/articleList";
}
@RequiresPermissions("article:article:view")
@RequestMapping(value = "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 = "form")
public String form(Article article, Model model) {
model.addAttribute("article", article);
return "modules/article/articleForm";
}
@RequiresPermissions("article:article:edit")
@PostMapping(value = "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成功！"));
}
@RequiresPermissions("article:article:edit")
@RequestMapping(value = "delete")
@ResponseBody
public String delete(Article article) {
articleService.delete(article);
return renderResult(Global.TRUE, text("删除i_article成功！"));
}
}
@Controller
@RequestMapping(value = "${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 = {"list", ""})
public String list(Match match, Model model) {
model.addAttribute("match", match);
return "modules/match/matchList";
}
@RequiresPermissions("match:match:view")
@RequestMapping(value = "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 = "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 = "save")
@ResponseBody
public String save(@Validated Match match) {
matchService.save(match);
return renderResult(Global.TRUE, text("保存赛事管理成功！"));
}
@RequiresPermissions("match:match:edit")
@RequestMapping(value = "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;
-- ----------------------------
五，手把手教你学习
前面分享了很多的项目、教程、面试题。
大家可以跟着学习。都是免费的。
给个三连（点赞+关注）和关注，一起变强，你点赞关注我，就算支持了小孟，当然我也会回报更多的给你。人和人之间都是相互的，嘿嘿……
项目给大家提供了。所有资料获取，点击下面的，关注弹出来的图片，
