基于ssm的牧場管理系統(tǒng)-計算機畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫：
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 '創(chuàng)建時間',
? `tongjibianhao` varchar(200) DEFAULT NULL COMMENT '統(tǒng)計編號',
? `nianfen` varchar(200) NOT NULL COMMENT '年份',
? `feiyongzhichu` int(11) DEFAULT NULL COMMENT '費用支出',
? `caiwushouru` int(11) DEFAULT NULL COMMENT '財務(wù)收入',
? `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='財務(wù)統(tǒng)計';
/*!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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時間',
? `diqu` varchar(200) DEFAULT NULL COMMENT '地區(qū)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `diqu` (`diqu`)
) ENGINE=InnoDB AUTO_INCREMENT=1650698077991 DEFAULT CHARSET=utf8 COMMENT='地區(qū)信息';
/*!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','地區(qū)2'),(23,'2022-04-23 07:01:26','地區(qū)3'),(24,'2022-04-23 07:01:26','地區(qū)4'),(25,'2022-04-23 07:01:26','地區(qū)5'),(26,'2022-04-23 07:01:26','地區(qū)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 '創(chuàng)建時間',
? `title` varchar(200) DEFAULT NULL COMMENT '帖子標題',
? `content` longtext NOT NULL COMMENT '帖子內(nèi)容',
? `parentid` bigint(20) DEFAULT NULL COMMENT '父節(jié)點id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `isdone` varchar(200) DEFAULT NULL COMMENT '狀態(tài)',
? 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','帖子內(nèi)容1',0,1,'用戶名1','開放'),(92,'2022-04-23 07:01:26','帖子標題2','帖子內(nèi)容2',0,2,'用戶名2','開放'),(93,'2022-04-23 07:01:26','帖子標題3','帖子內(nèi)容3',0,3,'用戶名3','開放'),(94,'2022-04-23 07:01:26','帖子標題4','帖子內(nèi)容4',0,4,'用戶名4','開放'),(95,'2022-04-23 07:01:26','帖子標題5','帖子內(nèi)容5',0,5,'用戶名5','開放'),(96,'2022-04-23 07:01:26','帖子標題6','帖子內(nèi)容6',0,6,'用戶名6','開放'),(1650698363789,'2022-04-23 07:19:23','第三方電商發(fā)多少','<p>水電費是發(fā)送到發(fā)送到水電費電商發(fā)多少</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 '創(chuàng)建時間',
? `biaoti` varchar(200) NOT NULL COMMENT '標題',
? `jianjie` longtext COMMENT '簡介',
? `fabushijian` date DEFAULT NULL COMMENT '發(fā)布時間',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `neirong` longtext COMMENT '內(nèi)容',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點擊時間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點擊次數(shù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650698196707 DEFAULT CHARSET=utf8 COMMENT='關(guān)于我們';
/*!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','內(nèi)容1','2022-04-23 15:01:26',1),(62,'2022-04-23 07:01:26','標題2','簡介2','2022-04-23','upload/guanyuwomen_fengmian2.jpg','內(nèi)容2','2022-04-23 15:01:26',2),(63,'2022-04-23 07:01:26','標題3','簡介3','2022-04-23','upload/guanyuwomen_fengmian3.jpg','內(nèi)容3','2022-04-23 15:01:26',3),(64,'2022-04-23 07:01:26','標題4','簡介4','2022-04-23','upload/guanyuwomen_fengmian4.jpg','內(nèi)容4','2022-04-23 15:01:26',4),(65,'2022-04-23 07:01:26','標題5','簡介5','2022-04-23','upload/guanyuwomen_fengmian5.jpg','內(nèi)容5','2022-04-23 15:01:26',5),(66,'2022-04-23 07:01:26','標題6','簡介6','2022-04-23','upload/guanyuwomen_fengmian6.jpg','內(nèi)容6','2022-04-23 15:01:26',6),(1650698196706,'2022-04-23 07:16:36','水電費時代發(fā)送到','時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代','2022-04-23','upload/1650698185995.jpg','<p>時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代時代發(fā)送到發(fā)送到發(fā)送到發(fā)送到時代發(fā)送到水電費時代<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;
