基于微信小程序的校运会管理系统设计与实现-计算机毕业设计源码+LW文档
小程序开发说明
开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
小程序框架：uniapp
小程序开发软件：HBuilder X
小程序运行软件：微信开发者
数据库脚本：
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 '创建时间',
`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 '创建时间',
`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 '发布时间',
`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 '创建时间',
`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 '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
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 '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='广播信息';
/*!40101 SET character_set_client = @saved_cs_client */;
