开发语言:Java
框架:ssm
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql 5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
数据库:
DROP TABLE IF EXISTS `caiwutongji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caiwutongji` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`tongjibianhao` varchar(200) DEFAULT NULL COMMENT ‘统计编号’,
`nianfen` varchar(200) NOT NULL COMMENT ‘年份’,
`feiyongzhichu` int(11) DEFAULT NULL COMMENT ‘费用支出’,
`caiwushouru` int(11) DEFAULT NULL COMMENT ‘财务收入’,
`chunlirun` int(11) DEFAULT NULL COMMENT ‘纯利润’,
`dengjiriqi` date DEFAULT NULL COMMENT ‘登记日期’,
PRIMARY KEY (`id`),
UNIQUE KEY `tongjibianhao` (`tongjibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT=’财务统计’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `caiwutongji`
—
LOCK TABLES `caiwutongji` WRITE;
/*!40000 ALTER TABLE `caiwutongji` DISABLE KEYS */;
INSERT INTO `caiwutongji` VALUES (71,’2022-04-23 07:01:26′,’1111111111′,’2019年’,111,222,111,’2022-04-23′),(72,’2022-04-23 07:01:26′,’2222222222′,’2020年’,211,222,11,’2022-04-23′),(73,’2022-04-23 07:01:26′,’3333333333′,’年份3′,3,3,3,’2022-04-23′),(74,’2022-04-23 07:01:26′,’4444444444′,’年份4′,4,4,4,’2022-04-23′),(75,’2022-04-23 07:01:26′,’5555555555′,’年份5′,5,5,5,’2022-04-23′),(76,’2022-04-23 07:01:26′,’6666666666′,’年份6′,6,6,6,’2022-04-23′);
/*!40000 ALTER TABLE `caiwutongji` 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/1650698265995.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `diquxinxi`
—
DROP TABLE IF EXISTS `diquxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diquxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`diqu` varchar(200) DEFAULT NULL COMMENT ‘地区’,
PRIMARY KEY (`id`),
UNIQUE KEY `diqu` (`diqu`)
) ENGINE=InnoDB AUTO_INCREMENT=1650698077991 DEFAULT CHARSET=utf8 COMMENT=’地区信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `diquxinxi`
—
LOCK TABLES `diquxinxi` WRITE;
/*!40000 ALTER TABLE `diquxinxi` DISABLE KEYS */;
INSERT INTO `diquxinxi` VALUES (21,’2022-04-23 07:01:26′,’北京’),(22,’2022-04-23 07:01:26′,’地区2′),(23,’2022-04-23 07:01:26′,’地区3′),(24,’2022-04-23 07:01:26′,’地区4′),(25,’2022-04-23 07:01:26′,’地区5′),(26,’2022-04-23 07:01:26′,’地区6′),(1650698077990,’2022-04-23 07:14:37′,’上海’);
/*!40000 ALTER TABLE `diquxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `forum`
—
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`title` varchar(200) DEFAULT NULL COMMENT ‘帖子标题’,
`content` longtext NOT NULL COMMENT ‘帖子内容’,
`parentid` bigint(20) DEFAULT NULL COMMENT ‘父节点id’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`username` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`isdone` varchar(200) DEFAULT NULL COMMENT ‘状态’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650698363790 DEFAULT CHARSET=utf8 COMMENT=’论坛交流’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `forum`
—
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (91,’2022-04-23 07:01:26′,’帖子标题1′,’帖子内容1′,0,1,’用户名1′,’开放’),(92,’2022-04-23 07:01:26′,’帖子标题2′,’帖子内容2′,0,2,’用户名2′,’开放’),(93,’2022-04-23 07:01:26′,’帖子标题3′,’帖子内容3′,0,3,’用户名3′,’开放’),(94,’2022-04-23 07:01:26′,’帖子标题4′,’帖子内容4′,0,4,’用户名4′,’开放’),(95,’2022-04-23 07:01:26′,’帖子标题5′,’帖子内容5′,0,5,’用户名5′,’开放’),(96,’2022-04-23 07:01:26′,’帖子标题6′,’帖子内容6′,0,6,’用户名6′,’开放’),(1650698363789,’2022-04-23 07:19:23′,’第三方电商发多少’,'<p>水电费是发送到发送到水电费电商发多少</p>\n<p><img src=\”../../../upload/1650698362131.jpg\” /></p>’,0,1650698036453,’11’,’开放’);
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `guanyuwomen`
—
DROP TABLE IF EXISTS `guanyuwomen`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guanyuwomen` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`biaoti` varchar(200) NOT NULL COMMENT ‘标题’,
`jianjie` longtext COMMENT ‘简介’,
`fabushijian` date DEFAULT NULL COMMENT ‘发布时间’,
`fengmian` varchar(200) DEFAULT NULL COMMENT ‘封面’,
`neirong` longtext COMMENT ‘内容’,
`clicktime` datetime DEFAULT NULL COMMENT ‘最近点击时间’,
`clicknum` int(11) DEFAULT ‘0’ COMMENT ‘点击次数’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650698196707 DEFAULT CHARSET=utf8 COMMENT=’关于我们’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `guanyuwomen`
—
LOCK TABLES `guanyuwomen` WRITE;
/*!40000 ALTER TABLE `guanyuwomen` DISABLE KEYS */;
INSERT INTO `guanyuwomen` VALUES (61,’2022-04-23 07:01:26′,’标题1′,’简介1′,’2022-04-23′,’upload/guanyuwomen_fengmian1.jpg’,’内容1′,’2022-04-23 15:01:26′,1),(62,’2022-04-23 07:01:26′,’标题2′,’简介2′,’2022-04-23′,’upload/guanyuwomen_fengmian2.jpg’,’内容2′,’2022-04-23 15:01:26′,2),(63,’2022-04-23 07:01:26′,’标题3′,’简介3′,’2022-04-23′,’upload/guanyuwomen_fengmian3.jpg’,’内容3′,’2022-04-23 15:01:26′,3),(64,’2022-04-23 07:01:26′,’标题4′,’简介4′,’2022-04-23′,’upload/guanyuwomen_fengmian4.jpg’,’内容4′,’2022-04-23 15:01:26′,4),(65,’2022-04-23 07:01:26′,’标题5′,’简介5′,’2022-04-23′,’upload/guanyuwomen_fengmian5.jpg’,’内容5′,’2022-04-23 15:01:26′,5),(66,’2022-04-23 07:01:26′,’标题6′,’简介6′,’2022-04-23′,’upload/guanyuwomen_fengmian6.jpg’,’内容6′,’2022-04-23 15:01:26′,6),(1650698196706,’2022-04-23 07:16:36′,’水电费时代发送到’,’时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代’,’2022-04-23′,’upload/1650698185995.jpg’,'<p>时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代<img src=\”http://localhost:8080/ssm6ui1j/upload/1650698195671.jpg\”></p>’,’2022-04-23 15:18:07′,3);
/*!40000 ALTER TABLE `guanyuwomen` ENABLE KEYS */;
UNLOCK TABLES;