小程序开发说明
开发语言: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 */;