Java毕业设计：基于ssm养老院管理app(源码+文档).zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssm895th -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `ssm895th` -- /*!40000 DROP DATABASE IF EXISTS `ssm895th`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm895th` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `ssm895th`; -- -- Table structure for table `caiwutongji` -- 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 '统计编号', `dangyueshouru` float DEFAULT NULL COMMENT '当月收入', `dangyuezhichu` float DEFAULT NULL COMMENT '当月支出', `chunlirun` float DEFAULT NULL COMMENT '纯利润', `dengjiriqi` date DEFAULT NULL COMMENT '登记日期', PRIMARY KEY (`id`), UNIQUE KEY `tongjibianhao` (`tongjibianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=237 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 (231,'2022-03-22 14:11:46','1111111111',1,1,1,'2022-03-22'),(232,'2022-03-22 14:11:46','2222222222',2,2,2,'2022-03-22'),(233,'2022-03-22 14:11:46','3333333333',3,3,3,'2022-03-22'),(234,'2022-03-22 14:11:46','4444444444',4,4,4,'2022-03-22'),(235,'2022-03-22 14:11:46','5555555555',5,5,5,'2022-03-22'),(236,'2022-03-22 14:11:46','6666666666',6,6,6,'2022-03-22'); /*!40000 ALTER TABLE `caiwutongji` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chuangwei` -- DROP TABLE IF EXISTS `chuangwei`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chuangwei` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `fangjianhao` varchar(200) DEFAULT NULL COMMENT '房间号', `loufangmingcheng` varchar(200) DEFAULT NULL COMMENT '楼房名称', `chuangweihao` varchar(200) NOT NULL COMMENT '床位号', `chuangweizhuangtai` varchar(200) DEFAULT NULL COMMENT '床位状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='床位'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chuangwei` -- LOCK TABLES `chuangwei` WRITE; /*!40000 ALTER TABLE `chuangwei` DISABLE KEYS */; INSERT INTO `chuangwei` VALUES (51,'2022-03-22 14:11:46','房间号1','楼房名称1','床位号1','已使用'),(52,'2022-03-22 14:11:46','房间号2','楼房名称2','床位号2','已使用'),(53,'2022-03-22 14:11:46','房间号3','楼房名称3','床位号3','已使用'),(54,'2022-03-22 14:11:46','房间号4','楼房名称4','床位号4','已使用'),(55,'2022-03-22 14:11:46','房间号5','楼房名称5','床位号5','已使用'),(56,'2022-03-22 14:11:46','房间号6','楼房名称6','床位号6','已使用'); /*!40000 ALTER TABLE `chuangwei` 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 `fangjianziliao` -- DROP TABLE IF EXISTS `fangjianziliao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fangjianziliao` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `fangjianhao` varchar(200) DEFAULT NULL COMMENT '房间号', `loufangmingcheng` varchar(200) DEFAULT NULL COMMENT '楼房名称', `fangjianmianji` varchar(200) DEFAULT NULL COMMENT '房间面积', `fangjiansheshi` longtext COMMENT '房间设施', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='房间资料'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fangjianziliao` -- LOCK TABLES `fangjianziliao` WRITE; /*!40000 ALTER TABLE `fangjianziliao` DISABLE KEYS */; INSERT INTO `fangjianziliao` VALUES (41,'2022-03-22 14:11:46','房间号1','楼房名称1','房间面积1','房间设施1'),(42,'2022-03-22 14:11:46','房间号2','楼房名称2','房间面积2','房间设施2'),(43,'2022-03-22 14:11:46','房间号3','楼房名称3','房间面积3','房间设施3'),(44,'2022-03-22 14:11:46','房间号4','楼房名称4','房间面积4','房间设施4'),(45,'2022-03-22 14:11:46','房间号5','楼房名称5','房间面积5','房间设施5'),(46,'2022-03-22 14:11:46','房间号6','楼房名称6','房间面积6','房间设施6'); /*!40000 ALTER TABLE `fangjianziliao` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hugong` -- DROP TABLE IF EXISTS `hugong`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hugong` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `hugonggonghao` varchar(200) NOT NULL COMMENT '护工工号', `mima` varchar(200) NOT NULL COMMENT '密码', `hugongxingming` varchar(200) NOT NULL COMMENT '护工姓名', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `hugongzhaopian` varchar(200) DEFAULT NULL COMMENT '护工照片', `nianling` int(11) DEFAULT NULL COMMENT '年龄', `hugongdianhua` varchar(200) DEFAULT NULL COMMENT '护工电话', `minzu` varchar(200) DEFAULT NULL COMMENT '民族', `xueli` varchar(200) DEFAULT NULL COMMENT '学历', `hunfou` varchar(200) DEFAULT NULL COMMENT '婚否', `hulijibie` varchar(200) NOT NULL COMMENT '护理级别', PRIMARY KEY (`id`), UNIQUE KEY `hugonggonghao` (`hugonggonghao`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='护工'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hugong` -- LOCK TABLES `hugong` WRITE; /*!40000 ALTER TABLE `hugong` DISABLE KEYS */; INSERT INTO `hugong` VALUES (11,'2022-03-22 14:11:46','护工工号1','123456','护工姓名1','男','upload/hugong_hugongzhaopian1.jpg',1,'13823888881','民族1','学历1','未婚','特级护理'),(12,'2022-03-22 14:11:46','护工工号2','123456','护工姓名2','男','upload/hugong_hugongzhaopian2.jpg',2,'13823888882','民�