开发语言：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','第三方电商发多少','
水电费是发送到发送到水电费电商发多少
\n<img src=\"../../../upload/1650698362131.jpg\" />',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','
时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代时代发送到发送到发送到发送到时代发送到水电费时代<img src=\"http://localhost:8080/ssm6ui1j/upload/1650698195671.jpg\">
','2022-04-23 15:18:07',3);
/!40000 ALTER TABLE guanyuwomen ENABLE KEYS */;
UNLOCK TABLES;
