基于微信小程序的校运会管理系统计算机毕业设计源码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,"
详情1","用户账号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 */;
解密!喝酒时脸红脸白,哪个更能喝?有人喝酒后瞬间就脸红,有人则从头到尾面不改色,甚至脸色发白。其实这两种情况都要少喝酒,喝好酒,因为解酒时人体需要乙醇脱氢酶和乙醛脱氢酶。喝酒脸红是因为体内缺乏一种酒精代谢的酶,名为
脑卒中病因和发病机制,以及如何预防概述脑梗死又称缺血性卒中,中医称之为卒中或中风。本病系由各种原因所致的局部脑组织区域血液供应障碍,导致脑组织缺血缺氧性病变坏死,进而产生临床上对应的神经功能缺失表现。脑梗死依据发病
男孩这三个缺点让宝妈头疼,但不用管,将来可能更有出息大家好,这里是天城育儿家有男孩的宝妈,都深有体会,养儿费妈!相对于养育女孩来说,养男孩很累。在管教时,还要照顾男孩的性格心境,特别伤脑筋。男孩子天生的性格特点,就与女孩子不一样。所
早产儿为什么要补铁?怎么补?看完你就知道了每个妈妈都希望自己的宝宝能够在肚子里待到足月才出生,但是有的时候还是不能尽如人意,临床上也会有早产儿的出生。早产儿一般是指没有足月的,而且生理功能器官组织等也没有完全成熟的新生儿。
痛风皆属于火,贼火外伤,子火内伤,内外火相交导致痛风中医有个理论,叫祛贼火,养子火理论,治疗痛风很好用中医的祛贼火养子火的理论来自于清代医学家程钟龄在医学心语中的相关论著。程钟龄认为尽管中医从黄帝内经就开始论及火,金元时期朱丹溪更是
岐黄心药此心光明我们无法左右坏事的发生,但可以试着用更好的心态去看待它。忽然被人误解之时,我们常常会感到愤怒失望委屈悲伤这些失控的七情会化作利剑刺伤我们的五脏六腑,让我们伤痕累累。我们无法左右别人
aptupdate如何工作本文简单介绍了在ubuntu的命令行下运行aptupdate时,软件包管理工具apt所执行的实际动作,相信此文会让你对ubuntu的包管理系统有更好的了解。1。导言众所周知,Lin
甘肃技能大师工作室提升技能,还需要横向学习2019年7月,邹斌(左四)在工作室内进行集团内部竞赛培训。(资料图)兰石集团供图中新网兰州12月5日电(刘潇)除了培训,我身为领办人,还要有效利用集团内部资源,实现多赢。作为兰石
英特尔中国高管叶唯琛在外企工作多年已57岁不再负责运营商业务?运营商财经杨杨文AMD凭借收购赛灵思进一步揭露了对FPGA市场野心后,英特尔如何应对,成为行业普遍关心的话题,英特尔可编程方案事业部在其中扮演的角色也愈发重要。此次运营商财经试图梳
工作应酬怎样才不会喝醉先说一下喝酒前应该准备的,这些东西是胃最好的伙伴。大家一定要保存或牢记!平时大家都有工作应酬喝多的何况出现吧!有时因为酒场没发挥好而错失良机,有一些不喜欢喝多想吐的那种感觉,今天教
祝贺!乒超马龙带队再创佳绩,7胜1负排名第一,樊振东被安排轮休2022年12月8日,乒超联赛继续进行,男团循环赛第八轮结束,山东鲁能30江苏中超电缆,7胜1负累积15分,直接锁定第一名,可以挑选自己半决赛的对手,马龙带队再创佳绩。男团七轮循环