【原创】基于SpringBoot的大学生竞赛系统(大学生竞赛系统毕业设计)

项目介绍:大学生竞赛系统可供管理员、评委和学生共同使用。系统提供了竞赛信息发布、竞赛信息查询、比赛报名、赛后成绩录入和查询、比赛过程作弊举报等一系列完整的工作流程。系统设计3个使用角色:管理员、学生、评委。管理员符合教导处角色。后台能够对学生、评委、竞赛项目等管理。根据需要,进行大学生竞赛的工作,仅需要由学生参赛,再分配不同的评委进行比赛结果的审核。另外,参赛信息也会将数据进行展示,学生可以查看到竞赛的比分、排名等。

项目类型:SpringBoot源码 

用户类型:3个角色(管理员+学生+裁判)

主要技术:SpringBoot+MySQL

开发工具:Idea使用

数据库:MySQL

数据库表:12张

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

01用户端

1.0网站首页(竞赛信息查询)

1.1竞赛详情

1.2竞赛论坛查看

1.3竞赛论坛详情及评论交流

1.4比赛报名

1.5赛后作弊举报模块

1.6比赛成绩查看模块

1.7比赛获奖查询

1.8举报记录

1.9竞赛论坛发布

02裁判端

2.1个人资料修改模块

2.2比赛报名管理(审核报名、得分录入、评奖)

2.3得奖录入

2.4得分录入

2.5得奖管理模块

2.6举报管理模块

03管理员端

3.1数据统计

3.2用户管理

3.3竞赛主题管理

3.4竞赛内容管理

3.5竞赛内容修改

3.6论坛管理

3.7比赛裁判管理

3.8得奖管理

04项目结构

05数据库设计

 06完整的程序目录

07演示视频


01用户端

1.0网站首页(竞赛信息查询)

1.1竞赛详情

1.2竞赛论坛查看

1.3竞赛论坛详情及评论交流

1.4比赛报名

1.5赛后作弊举报模块

1.6比赛成绩查看模块

1.7比赛获奖查询

1.8举报记录

1.9竞赛论坛发布

02裁判端

2.1个人资料修改模块

2.2比赛报名管理(审核报名、得分录入、评奖)

2.3得奖录入

2.4得分录入

2.5得奖管理模块

2.6举报管理模块

03管理员端

3.1数据统计

3.2用户管理

3.3竞赛主题管理

3.4竞赛内容管理

3.5竞赛内容修改

3.6论坛管理

3.7比赛裁判管理

3.8得奖管理

04项目结构

05数据库设计

 06完整的程序目录

07演示视频

【原创】基于SpringBoot的 大学生竞赛系统

 


-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '管理员账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '管理员密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '1', '1');

-- ----------------------------
-- Table structure for award
-- ----------------------------
DROP TABLE IF EXISTS `award`;
CREATE TABLE `award`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '获取id',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '获奖图片',
  `uid` int(11) DEFAULT NULL COMMENT '获奖学生id',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '获奖内容',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '获奖标题',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of award
-- ----------------------------
INSERT INTO `award` VALUES (2, '/images/2023-04-26/6741f99a-9ad2-4b8c-b830-d9dcdf2dbfbb.png', 1, '手机一部', '手机一部');
INSERT INTO `award` VALUES (3, '/images/2023-09-25/9bccfe5f-94c7-47f7-9e2f-f92888f94583.png', 2, '软件工程课题资料一套', '3等奖奖励');

-- ----------------------------
-- Table structure for board
-- ----------------------------
DROP TABLE IF EXISTS `board`;
CREATE TABLE `board`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '内容',
  `editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布人',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '封面图',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;


-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '竞赛类型id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '竞赛类型名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (3, '数学');
INSERT INTO `category` VALUES (4, '计算机');
INSERT INTO `category` VALUES (5, '高数');
INSERT INTO `category` VALUES (6, '计算机网络');
INSERT INTO `category` VALUES (7, '算法分析');
INSERT INTO `category` VALUES (8, 'C语言');

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论id',
  `uid` int(11) DEFAULT NULL COMMENT '发布人id',
  `nid` int(11) DEFAULT NULL COMMENT '帖子id',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评论内容',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评论时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES (1, 1, 1, '可以学习javaweb基础', '2023-04-12 21:11');

-- ----------------------------
-- Table structure for contest
-- ----------------------------
DROP TABLE IF EXISTS `contest`;
CREATE TABLE `contest`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '竞赛id',
  `cid` int(11) DEFAULT NULL COMMENT '竞赛类型id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '竞赛名称',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '竞赛标题',
  `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '竞赛详情',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '封面图',
  `starttime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '开始时间',
  `endtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '结束时间',
  `start_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '开始日期',
  `eid` int(11) DEFAULT NULL COMMENT '裁判id',
  `videos` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '竞赛视频',
  `leixing1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `leixing2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `leixing3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contest
-- ----------------------------
INSERT INTO `contest` VALUES (2, 6, '计算机网络', '计算机网络', '<p>计算机网络</p>', '/images/2023-04-26/6741f99a-9ad2-4b8c-b830-d9dcdf2dbfbb.png', '00:00:00', '20:00:00', '2023-04-28', 1, '', '个人赛', '校园赛', '初赛', '上海');
INSERT INTO `contest` VALUES (3, 4, 'Java程序设计比赛', 'Java程序比赛', 'Java程序比赛,主要比赛的内容包括编程、开发', '/images/2023-04-27/87da51b2-bb11-4094-8504-48c1a34c09a6.jpg', '10:00:00', '20:00:00', '2023-04-29', 1, '', '个人赛', '校园赛', '初赛', '无锡');
INSERT INTO `contest` VALUES (4, 3, 'C语言', 'C语言比赛,禁止作弊', '<p>C语言比赛,禁止作弊</p><p><img src=\"/images/2023925037fa4b8af1248ac825145f6bcb483ce1.jpg\" alt=\"2023925037fa4b8af1248ac825145f6bcb483ce1.jpg\"><br></p>', '/images/2023-09-25/87a9d86a-2090-4dba-b0a3-2e2731df9646.jpg', '08:00:00', '10:00:00', '2023-09-28', 1, '/images/2023-09-25/7ed29dae-58f9-48df-bb49-4499303c7930.mp4', '个人赛', '校园赛', '初赛', '教学楼');
INSERT INTO `contest` VALUES (5, 6, 'python比赛', 'python比赛', '<p>python比赛</p>', '/images/2023-09-25/b07a108f-6573-4181-9a91-c27f5afd60d8.jpg', '08:00:00', '10:00:00', '2023-09-30', 1, '', '个人赛', '校园赛', '初赛', '无锡');
INSERT INTO `contest` VALUES (6, 7, '数据挖掘算法比赛', '数据挖掘算法比赛', '<p>数据挖掘算法比赛</p>', '/images/2023-09-25/661c47d5-a005-435a-9339-7ef00a0fd59f.JPG', '15:00:00', '18:00:00', '2023-09-30', 1, '', '个人赛', '校园赛', '初赛', '南京');
INSERT INTO `contest` VALUES (7, 3, '高等数学比赛', '高等数学比赛', '<p>高等数学比赛</p>', '/images/2023-09-25/b17d0e2d-ac4d-42a7-a0c8-b8a18317b673.jpg', '12:00:00', '14:00:00', '2023-09-30', 1, '', '团队赛', '省赛', '决赛', '南京');

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '裁判id',
  `eno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '裁判编号',
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '裁判密码',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '裁判照片',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '裁判姓名',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '裁判性别',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES (1, '1', '123456', '/images/2023-09-25/2c381852-e76f-44a5-a8ee-457da4ffe9a3.jpg', '张评委', '男');
INSERT INTO `employee` VALUES (2, '2', '123456', '/images/2023-09-25/c23e938c-0411-403c-82e3-2bad68b88c22.jpg', '李评委', '男');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '帖子id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '帖子标题',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '帖子内容',
  `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '帖子详情',
  `uid` int(11) DEFAULT NULL COMMENT '发布人id',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '帖子类型',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '帖子封面',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (1, '关于java比赛,有什么建议', '关于java比赛,有什么建议', '<p>关于java比赛,有什么建议</p>', 1, '2023-04-12 21:07', '比赛攻略', '/images/2023-04-27/1f1881a8-d106-4750-89e1-474ce9c64b0c.jpg');
INSERT INTO `news` VALUES (2, '关于C语言的学习', '', '<p>关于C语言的学习</p>', 1, '2023-04-27 13:57', '学习', '/images/2023-04-27/97587fd3-c8f6-4828-84a6-045beb17083c.jpg');

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '报名记录id',
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `cid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '竞赛id',
  `state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0待审核  1审核通过  2审核拒绝 3已打分',
  `tools` decimal(11, 2) DEFAULT NULL COMMENT '最后得分',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评语',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of record
-- ----------------------------
INSERT INTO `record` VALUES (4, 1, '2', '1', 90.00, '2023-04-26 23:38', '表现不错');
INSERT INTO `record` VALUES (5, 2, '2', '1', 80.00, '2023-04-27 14:01', '表现不错');
INSERT INTO `record` VALUES (6, 1, '6', '0', 0.00, '2023-09-25 23:43', NULL);

-- ----------------------------
-- Table structure for reply
-- ----------------------------
DROP TABLE IF EXISTS `reply`;
CREATE TABLE `reply`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '回贴id',
  `uid` int(11) DEFAULT NULL COMMENT '回复人id',
  `cid` int(11) DEFAULT NULL COMMENT '评论id',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '回复时间',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '回复内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of reply
-- ----------------------------
INSERT INTO `reply` VALUES (1, 1, 1, '2023-04-12 21:11', '121312321');
INSERT INTO `reply` VALUES (2, 1, 1, '2023-04-12 21:13', '111');

-- ----------------------------
-- Table structure for reports
-- ----------------------------
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '举报id',
  `uid` int(11) DEFAULT NULL COMMENT '举报人id',
  `eid` int(11) DEFAULT NULL COMMENT '裁判id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报对象',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报内容',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '举报时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of reports
-- ----------------------------
INSERT INTO `reports` VALUES (1, 1, 1, '张三', '涉嫌抄袭', '2023-04-26 21:57');
INSERT INTO `reports` VALUES (2, 1, 1, '李四', '他在比赛时作弊', '2023-04-27 14:04');
INSERT INTO `reports` VALUES (3, 1, 1, '陈斯', '比赛中,查阅资料作弊', '2023-09-25 23:37');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学生姓名',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学生头像',
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '简介',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `xueyuan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `teacher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '张三', '/images/2023-04-27/f12471fd-695f-43a9-b486-534671f078d6.jpg', '信息学院的一名学生', '男', '19852410210', '2023-04-05 02:31', 23, '123456', '信息学院', '李平老师');
INSERT INTO `user` VALUES (2, '李四', '/images/2023-04-27/4171f931-f86a-4012-b2db-a6bf6ca9dda8.jpg', '信息学院的一名学生', '男', '18052142134', '2023-04-12 21:27', 20, '123456', '信息学院', '钱粮老师');
INSERT INTO `user` VALUES (3, '李有田', '/images/2023-09-25/0dc22581-92a2-48dd-9a02-8313196802a7.jpg', '信息学院的一名学生', '男', '18850210002', '2023-09-10 00:27', 22, '123456', '信息学院', '钱粮老师');
INSERT INTO `user` VALUES (4, '王杰斯', '/images/2023-09-25/5ac5050f-d393-4cbf-9b16-4d5eb4e7372d.jpg', '信息学院的一名学生', '男', '18865214120', '2023-09-10 00:28', 23, '123456', '信息学院', '钱粮老师');

SET FOREIGN_KEY_CHECKS = 1;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

打赏作者

那条学长V

你的鼓励将是我创作的最大动力

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

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

打赏作者

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

抵扣说明:

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

余额充值