基于微信小程序的校運會管理系統(tǒng)設計與實現(xiàn)-計算機畢業(yè)設計源碼+LW文檔
小程序開發(fā)說明
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
小程序框架：uniapp
小程序開發(fā)軟件：HBuilder X
小程序運行軟件：微信開發(fā)者
數(shù)據(jù)庫腳本：
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)建時間',
? `baomingbianhao` varchar(200) DEFAULT NULL COMMENT '報名編號',
? `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '項目名稱',
? `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '項目類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `baomingshijian` datetime DEFAULT NULL COMMENT '報名時間',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號',
? `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用戶姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復',
? PRIMARY KEY (`id`),
? UNIQUE KEY `baomingbianhao` (`baomingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='比賽報名';
/*!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-27 05:45:04','1111111111','項目名稱1','項目類型1','upload/bisaibaoming_tupian1.jpg','2022-05-27 13:45:04','用戶賬號1','用戶姓名1','是',''),(42,'2022-05-27 05:45:04','2222222222','項目名稱2','項目類型2','upload/bisaibaoming_tupian2.jpg','2022-05-27 13:45:04','用戶賬號2','用戶姓名2','是',''),(43,'2022-05-27 05:45:04','3333333333','項目名稱3','項目類型3','upload/bisaibaoming_tupian3.jpg','2022-05-27 13:45:04','用戶賬號3','用戶姓名3','是',''),(44,'2022-05-27 05:45:04','4444444444','項目名稱4','項目類型4','upload/bisaibaoming_tupian4.jpg','2022-05-27 13:45:04','用戶賬號4','用戶姓名4','是',''),(45,'2022-05-27 05:45:04','5555555555','項目名稱5','項目類型5','upload/bisaibaoming_tupian5.jpg','2022-05-27 13:45:04','用戶賬號5','用戶姓名5','是',''),(46,'2022-05-27 05:45:04','6666666666','項目名稱6','項目類型6','upload/bisaibaoming_tupian6.jpg','2022-05-27 13:45:04','用戶賬號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)建時間',
? `chengjibianhao` varchar(200) DEFAULT NULL COMMENT '成績編號',
? `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '項目名稱',
? `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '項目類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `baobiao` varchar(200) DEFAULT NULL COMMENT '報表',
? `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時間',
? `bisaichengji` float DEFAULT NULL COMMENT '比賽成績',
? `xiangqing` longtext COMMENT '詳情',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號',
? `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='成績信息';
/*!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-27 05:45:04','1111111111','項目名稱1','項目類型1','upload/chengjixinxi_tupian1.jpg','upload/1653630419489.png','2022-05-27 13:45:04',1,'<p>詳情1</p>','用戶賬號1','用戶姓名1',1),(52,'2022-05-27 05:45:04','2222222222','項目名稱2','項目類型2','upload/chengjixinxi_tupian2.jpg','upload/chengjixinxi_baobiao2.jpg','2022-05-27 13:45:04',2,'詳情2','用戶賬號2','用戶姓名2',2),(53,'2022-05-27 05:45:04','3333333333','項目名稱3','項目類型3','upload/chengjixinxi_tupian3.jpg','upload/chengjixinxi_baobiao3.jpg','2022-05-27 13:45:04',3,'詳情3','用戶賬號3','用戶姓名3',3),(54,'2022-05-27 05:45:04','4444444444','項目名稱4','項目類型4','upload/chengjixinxi_tupian4.jpg','upload/chengjixinxi_baobiao4.jpg','2022-05-27 13:45:04',4,'詳情4','用戶賬號4','用戶姓名4',4),(55,'2022-05-27 05:45:04','5555555555','項目名稱5','項目類型5','upload/chengjixinxi_tupian5.jpg','upload/chengjixinxi_baobiao5.jpg','2022-05-27 13:45:04',5,'詳情5','用戶賬號5','用戶姓名5',5),(56,'2022-05-27 05:45:04','6666666666','項目名稱6','項目類型6','upload/chengjixinxi_tupian6.jpg','upload/chengjixinxi_baobiao6.jpg','2022-05-27 13:45:04',6,'詳情6','用戶賬號6','用戶姓名6',6);
/*!40000 ALTER TABLE `chengjixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chexiaobaoming`
--
DROP TABLE IF EXISTS `chexiaobaoming`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chexiaobaoming` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `chexiaobianhao` varchar(200) DEFAULT NULL COMMENT '撤銷編號',
? `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '項目名稱',
? `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '項目類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `chexiaoshijian` datetime DEFAULT NULL COMMENT '撤銷時間',
? `chexiaobeizhu` longtext COMMENT '撤銷備注',
? `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用戶賬號',
? `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用戶姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復',
? PRIMARY KEY (`id`),
? UNIQUE KEY `chexiaobianhao` (`chexiaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='撤銷報名';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chexiaobaoming`
--
LOCK TABLES `chexiaobaoming` WRITE;
/*!40000 ALTER TABLE `chexiaobaoming` DISABLE KEYS */;
INSERT INTO `chexiaobaoming` VALUES (61,'2022-05-27 05:45:04','1111111111','項目名稱1','項目類型1','upload/chexiaobaoming_tupian1.jpg','2022-05-27 13:45:04','撤銷備注1','用戶賬號1','用戶姓名1','是',''),(62,'2022-05-27 05:45:04','2222222222','項目名稱2','項目類型2','upload/chexiaobaoming_tupian2.jpg','2022-05-27 13:45:04','撤銷備注2','用戶賬號2','用戶姓名2','是',''),(63,'2022-05-27 05:45:04','3333333333','項目名稱3','項目類型3','upload/chexiaobaoming_tupian3.jpg','2022-05-27 13:45:04','撤銷備注3','用戶賬號3','用戶姓名3','是',''),(64,'2022-05-27 05:45:04','4444444444','項目名稱4','項目類型4','upload/chexiaobaoming_tupian4.jpg','2022-05-27 13:45:04','撤銷備注4','用戶賬號4','用戶姓名4','是',''),(65,'2022-05-27 05:45:04','5555555555','項目名稱5','項目類型5','upload/chexiaobaoming_tupian5.jpg','2022-05-27 13:45:04','撤銷備注5','用戶賬號5','用戶姓名5','是',''),(66,'2022-05-27 05:45:04','6666666666','項目名稱6','項目類型6','upload/chexiaobaoming_tupian6.jpg','2022-05-27 13:45:04','撤銷備注6','用戶賬號6','用戶姓名6','是','');
/*!40000 ALTER TABLE `chexiaobaoming` 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)建時間',
? `title` varchar(200) NOT NULL COMMENT '標題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='廣播信息';
/*!40101 SET character_set_client = @saved_cs_client */;
