基于微信小程序的校运会管理系统计算机毕业设计源码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 */;
越美的女人越狠毒,女主颜值超高蛇蝎情人俗话说漂亮的女人是老虎,越是漂亮的女人越是欲壑难填,整不好真的会吃人的。今天就介绍一部关于漂亮女人的电影蛇蝎情人雷(詹姆斯斯派德JamesSpader饰)事业有成,经营着一家广告公
真闺蜜Pk伪闺蜜方糖和小雨的结局警醒我们一定要看清闺蜜的德行我最近粉上了电视剧妻子的选择,它不仅剧情紧凑带有推理感而且涉及方方面面的东西,所以我挺喜欢这部剧的,今天咱们聊一聊剧中闺蜜的话题。1。真闺蜜是什么体验?在电视剧里,女主角方糖有一个
女星齐溪OOPS新花样文艺氛围封面大片热播综艺乘风破浪让更多人认识了低调的演员齐溪,近期她登上OOPS新花样杂志新刊封面,演绎时光清浅,恰如其分的文艺氛围,是很适合她的大片风格。继年初春节档电影奇迹笨小孩里的汪春梅之后
周杰伦官宣,将于7月15日发行个人第15张专辑最伟大的作品最近周杰伦的粉丝们可以说是非常开心了,因为周杰伦的新专辑可以说是千呼万唤始出来,终于不是打嘴炮忽悠粉丝了,这次是真的,周杰伦的新专辑将于7月15日发行,并且这张专辑将会是周杰伦的个
大S离婚后,居然变回少女了大S二婚丈夫具俊晔上了一档韩国采访,分享的感情生活瞬间霸了屏。当然,我肯定不会错过得也去看了。节目分享我倒是没啥太大兴趣,也不过就是一个晚婚大叔兴奋分享自己和旧爱破镜重圆的幸福故事
彻底被秦岚这段话点醒了昨晚偶然翻看鲁豫有约秦岚谈到关于婚姻的这段话,希望女性朋友们可以看到我觉得结了婚就不要离婚就不要分开我不会觉得我今天想结婚我就结婚了如果将来我有孩子我想要对孩子负责我如果作为一位母
207亿!史上最难618背后,宝尊电商如何赋能品牌主?文金错刀疫情裁员潮等冲击,让2022年的一切充满着不确定性。电商行业也不能幸免。阿里巴巴京东拼多多美团,快手,以电商为主营业务的互联网平台发布的2022Q1财报中,都提到了疫情引起
B站带货当学新东方编辑导语不知不觉中,B站已经开启直播带货业务近两年,那么在这两年里,B站的直播带货模式是否真的跑通了?未来B站如果真的想继续发展直播带货业务,又该如何在这一模块上进行深耕?本篇文章
一篇文章带你走进cookie,session,Token的世界前言无状态的HTTP协议一天,你有个需求,你要去超市买一瓶可乐。到了超市买了可乐,你告诉售货员,下次给我准备下雷碧,我下次来拿。第二次,你去超市拿雷碧,售货员说他不记得你什么时候说
每天下班后的几个小时你能做啥?每个人的差距就在这时候来体现了大家都羡慕体制内的工作最大的原因应该就是朝九晚五了吧。正常情况下确实都是可以正常下班的,虽然有时加班,毕竟那也不是常态。可是作为年轻人,11点之前入睡的我想都在少数了,不说12点1
如果世上真有奇迹,那只是努力的别名人生如戏,戏可以重演,但人生却不可重来。如果世上真有奇迹,那就是努力的别名。人生大的失误不是跌倒,而是从来不敢向前奔跑。自己想要的东西必须奋力直追,不能坐等。一个妄想的巨人行动的矮