基于ssm的校運(yùn)會(huì)管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開發(fā)語(yǔ)言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫(kù)腳本：
DROP TABLE IF EXISTS `bisaibaoming`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bisaibaoming` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `baomingbianhao` varchar(200) DEFAULT NULL COMMENT '報(bào)名編號(hào)',
? `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目名稱',
? `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `baomingshijian` datetime DEFAULT NULL COMMENT '報(bào)名時(shí)間',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號(hào)',
? `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用戶姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `baomingbianhao` (`baomingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='比賽報(bào)名';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bisaibaoming`
--
LOCK TABLES `bisaibaoming` WRITE;
/*!40000 ALTER TABLE `bisaibaoming` DISABLE KEYS */;
INSERT INTO `bisaibaoming` VALUES (41,'2022-05-19 06:30:58','1111111111','項(xiàng)目名稱1','項(xiàng)目類型1','upload/bisaibaoming_tupian1.jpg','2022-05-19 14:30:58','用戶賬號(hào)1','用戶姓名1','是',''),(42,'2022-05-19 06:30:58','2222222222','項(xiàng)目名稱2','項(xiàng)目類型2','upload/bisaibaoming_tupian2.jpg','2022-05-19 14:30:58','用戶賬號(hào)2','用戶姓名2','是',''),(43,'2022-05-19 06:30:58','3333333333','項(xiàng)目名稱3','項(xiàng)目類型3','upload/bisaibaoming_tupian3.jpg','2022-05-19 14:30:58','用戶賬號(hào)3','用戶姓名3','是',''),(44,'2022-05-19 06:30:58','4444444444','項(xiàng)目名稱4','項(xiàng)目類型4','upload/bisaibaoming_tupian4.jpg','2022-05-19 14:30:58','用戶賬號(hào)4','用戶姓名4','是',''),(45,'2022-05-19 06:30:58','5555555555','項(xiàng)目名稱5','項(xiàng)目類型5','upload/bisaibaoming_tupian5.jpg','2022-05-19 14:30:58','用戶賬號(hào)5','用戶姓名5','是',''),(46,'2022-05-19 06:30:58','6666666666','項(xiàng)目名稱6','項(xiàng)目類型6','upload/bisaibaoming_tupian6.jpg','2022-05-19 14:30:58','用戶賬號(hào)6','用戶姓名6','是','');
/*!40000 ALTER TABLE `bisaibaoming` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chengjixinxi`
--
DROP TABLE IF EXISTS `chengjixinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chengjixinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `chengjibianhao` varchar(200) DEFAULT NULL COMMENT '成績(jī)編號(hào)',
? `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目名稱',
? `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時(shí)間',
? `bisaichengji` float DEFAULT NULL COMMENT '比賽成績(jī)',
? `xiangqing` longtext COMMENT '詳情',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號(hào)',
? `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用戶姓名',
? `userid` bigint(20) DEFAULT NULL COMMENT '用戶id',
? PRIMARY KEY (`id`),
? UNIQUE KEY `chengjibianhao` (`chengjibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='成績(jī)信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chengjixinxi`
--
LOCK TABLES `chengjixinxi` WRITE;
/*!40000 ALTER TABLE `chengjixinxi` DISABLE KEYS */;
INSERT INTO `chengjixinxi` VALUES (51,'2022-05-19 06:30:58','1111111111','項(xiàng)目名稱1','項(xiàng)目類型1','upload/1652942004223.png','2022-05-19 14:30:58',1,'<p>詳情1</p>','用戶賬號(hào)1','用戶姓名1',1),(52,'2022-05-19 06:30:58','2222222222','項(xiàng)目名稱2','項(xiàng)目類型2','upload/chengjixinxi_tupian2.jpg','2022-05-19 14:30:58',2,'詳情2','用戶賬號(hào)2','用戶姓名2',2),(53,'2022-05-19 06:30:58','3333333333','項(xiàng)目名稱3','項(xiàng)目類型3','upload/chengjixinxi_tupian3.jpg','2022-05-19 14:30:58',3,'詳情3','用戶賬號(hào)3','用戶姓名3',3),(54,'2022-05-19 06:30:58','4444444444','項(xiàng)目名稱4','項(xiàng)目類型4','upload/chengjixinxi_tupian4.jpg','2022-05-19 14:30:58',4,'詳情4','用戶賬號(hào)4','用戶姓名4',4),(55,'2022-05-19 06:30:58','5555555555','項(xiàng)目名稱5','項(xiàng)目類型5','upload/chengjixinxi_tupian5.jpg','2022-05-19 14:30:58',5,'詳情5','用戶賬號(hào)5','用戶姓名5',5),(56,'2022-05-19 06:30:58','6666666666','項(xiàng)目名稱6','項(xiàng)目類型6','upload/chengjixinxi_tupian6.jpg','2022-05-19 14:30:58',6,'詳情6','用戶賬號(hào)6','用戶姓名6',6);
/*!40000 ALTER TABLE `chengjixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `name` varchar(100) NOT NULL COMMENT '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡(jiǎn)介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='廣播信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news`
前臺(tái)登錄代碼：
?// 登陸
? ? login() {
? ? ? if (!this.rulesForm.username) {
? ? ? ? ?this.$message.error("請(qǐng)輸入用戶名");
? ? ? ? return;
? ? ? }
? ? ? if (!this.rulesForm.password) {
? ? ? ? ?this.$message.error("請(qǐng)輸入密碼");
? ? ? ? return;
? ? ? }
? ? ? if(this.roles.length>1) {
? ? ? ? ? if (!this.rulesForm.role) {
? ? ? ? ? ? ?this.$message.error("請(qǐng)選擇角色");
? ? ? ? ? ? return;
? ? ? ? ? }
? ? ? ? ? let menus = this.menus;
? ? ? ? ? for (let i = 0; i < menus.length; i++) {
? ? ? ? ? ? if (menus[i].roleName == this.rulesForm.role) {
? ? ? ? ? ? ? this.tableName = menus[i].tableName;
? ? ? ? ? ? }
? ? ? ? ? }
? ? ? } else {
? ? ? ? ? this.tableName = this.roles[0].tableName;
? ? ? ? ? this.rulesForm.role = this.roles[0].roleName;
? ? ? }
? ? ? this.$http({
? ? ? ? url: `${this.tableName}/login?username=${this.rulesForm.username}&password=${this.rulesForm.password}`,
? ? ? ? method: "post"
? ? ? }).then(({ data }) => {
? ? ? ? if (data && data.code === 0) {
? ? ? ? ? this.$storage.set("Token", data.token);
? ? ? ? ? this.$storage.set("role", this.rulesForm.role);
? ? ? ? ? this.$storage.set("sessionTable", this.tableName);
? ? ? ? ? this.$storage.set("adminName", this.rulesForm.username);
? ? ? ? ? this.$router.replace({ path: "/index/" });
? ? ? ? } else {
? ? ? ? ? this.$message.error(data.msg);
? ? ? ? }
? ? ? });
? ? },
? ? getRandCode(len = 4){
? ? ? this.randomString(len)
? ? },
? ? randomString(len = 4) {
? ? ? let chars = [
? ? ? ? ? "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k",
? ? ? ? ? "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v",
? ? ? ? ? "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G",
? ? ? ? ? "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R",
? ? ? ? ? "S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2",
? ? ? ? ? "3", "4", "5", "6", "7", "8", "9"
? ? ? ]
? ? ? let colors = ["0", "1", "2","3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f"]
? ? ? let sizes = ['14', '15', '16', '17', '18']
? ? ? let output = [];
? ? ? for (let i = 0; i < len; i++) {
? ? ? ? // 隨機(jī)驗(yàn)證碼
? ? ? ? let key = Math.floor(Math.random()*chars.length)
? ? ? ? this.codes[i].num = chars[key]
? ? ? ? // 隨機(jī)驗(yàn)證碼顏色
? ? ? ? let code = '#'
? ? ? ? for (let j = 0; j < 6; j++) {
? ? ? ? ? let key = Math.floor(Math.random()*colors.length)
? ? ? ? ? code += colors[key]
? ? ? ? }
? ? ? ? this.codes[i].color = code
? ? ? ? // 隨機(jī)驗(yàn)證碼方向
? ? ? ? let rotate = Math.floor(Math.random()*60)
? ? ? ? let plus = Math.floor(Math.random()*2)
? ? ? ? if(plus == 1) rotate = '-'+rotate
? ? ? ? this.codes[i].rotate = 'rotate('+rotate+'deg)'
? ? ? ? // 隨機(jī)驗(yàn)證碼字體大小
? ? ? ? let size = Math.floor(Math.random()*sizes.length)
? ? ? ? this.codes[i].size = sizes[size]+'px'
? ? ? }
? ? },
? }
};
</script>
