基于微信小程序的校运会管理系统-计算机毕业设计源码+LW文档

计算机毕业设计老师 04-02 90

前言：

而今朋友们对“基于java的微信小程序开发实现发布和报名活动功能”大概比较重视，咱们都想要了解一些“基于java的微信小程序开发实现发布和报名活动功能”的相关内容。那么小编也在网上汇集了一些有关“基于java的微信小程序开发实现发布和报名活动功能””的相关资讯，希望各位老铁们能喜欢，兄弟们快快来了解一下吧！

小程序开发说明

开发语言：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='配置文件';