计算机毕业设计 基于SpringBoot的敬老院管理系统的设计与实现 Java实战项目 附源码+文档+视频讲解
博主介绍：✌从事软件开发10年之余，专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌
🍅文末获取源码联系🍅
👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
————————————————
计算机毕业设计《1000套》✌
目录
1、项目介绍及开发技术
1.1 项目介绍
1.2 开发技术
2、系统功能模块设计
3、功能截图
3.1 前台功能
3.2 后台功能
4、数据库表结构设计
5、关键代码
5.1 服务工单Controller模块
5.2 服务工单Service模块
5.3 服务工单ServiceImpl模块
5.4 服务工单Dao模块
6、论文目录结构
7、源码获取
1、项目介绍及开发技术
1.1 项目介绍
随着人口老龄化的加剧，敬老院管理系统的需求也越来越大。传统的敬老院管理方式已经不能满足现代化的需求。探究如何使用SpringBoot框架设计并实现一个敬老院管理系统，以提高敬老院的管理效率和服务质量。通过该系统的设计和实现，可以为敬老院提供更加高效、便捷、安全的管理方式，同时也可以为老年人提供更好的生活服务。此外，该系统的研究还可以为敬老院管理系统的开发提供参考和借鉴，促进敬老院管理的现代化建设。
本系统从系统的需求分析、结构设计、数据库设计等方面入手，阐述系统的实现过程。在系统实现方面，本文采用Java编程语言和MySQL数据库等技术，分别实现管理员、医护人员和老人的模块功能。在完成系统的开发后，对系统进行测试，以验证其安全性和完整性，同时完善用户权限管理等功能。最终，确保系统符合相关标准。
1.2 开发技术
Java开发语言、SpringBoot、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8+、Vue、HTML、CSS、JS。
2、系统功能模块设计
老人：注册登录、首页、个人中心（修改密码、个人信息）、服务工单管理、健康档案管理、护理记录管理、费用信息管理、护理风险管理、膳食信息管理。
医护人员管理：注册登录、首页、个人中心（修改密码、个人信息）、老人管理、设施信息管理、服务工单管理、健康档案管理、护理记录管理、护理风险管理、物资信息管理、 物资出库管理、物资入库管理、来访登记管理、家属探望管理、请假申请管理。
管理员：登录、首页、个人中心（修改密码、个人信息）、医护等级管理、医护人员管理、老人管理、设施信息管理、服务工单管理、健康档案管理、护理记录管理、费用信息管理、护理风险管理、膳食信息管理、物资分类管理、 物资出库管理、物资入库管理、来访登记管理、员工档案管理、家属探望管理、请假申请管理。
3、功能截图
3.1 前台功能
注册
登录
3.2 后台功能
首页
医护等级
医护人员管理
老人管理
设施信息管理
服务工单管理
健康档案管理
护理记录管理
4、数据库表结构设计
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springboot35806
-- ------------------------------------------------------
-- 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: `springboot35806`
--/*!40000 DROP DATABASE IF EXISTS `springboot35806`*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboot35806` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE `springboot35806`;--
-- 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 `feiyongxinxi`
--DROP TABLE IF EXISTS `feiyongxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feiyongxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dingdanhao` varchar(200) DEFAULT NULL COMMENT '订单号',`jiaofeileixing` varchar(200) DEFAULT NULL COMMENT '缴费类型',`feiyong` varchar(200) DEFAULT NULL COMMENT '费用',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',`jiashuxingming` varchar(200) DEFAULT NULL COMMENT '家属姓名',`dengjishijian` datetime DEFAULT NULL COMMENT '登记时间',`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',PRIMARY KEY (`id`),UNIQUE KEY `dingdanhao` (`dingdanhao`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='费用信息';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `feiyongxinxi`
--LOCK TABLES `feiyongxinxi` WRITE;
/*!40000 ALTER TABLE `feiyongxinxi` DISABLE KEYS */;
INSERT INTO `feiyongxinxi` VALUES (81,'2023-05-13 04:25:22','1111111111','缴费类型1','费用1','老人编号1','老人姓名1','家属姓名1','2023-05-13 12:25:22','未支付'),(82,'2023-05-13 04:25:22','2222222222','缴费类型2','费用2','老人编号2','老人姓名2','家属姓名2','2023-05-13 12:25:22','未支付'),(83,'2023-05-13 04:25:22','3333333333','缴费类型3','费用3','老人编号3','老人姓名3','家属姓名3','2023-05-13 12:25:22','未支付'),(84,'2023-05-13 04:25:22','4444444444','缴费类型4','费用4','老人编号4','老人姓名4','家属姓名4','2023-05-13 12:25:22','未支付'),(85,'2023-05-13 04:25:22','5555555555','缴费类型5','费用5','老人编号5','老人姓名5','家属姓名5','2023-05-13 12:25:22','未支付'),(86,'2023-05-13 04:25:22','6666666666','缴费类型6','费用6','老人编号6','老人姓名6','家属姓名6','2023-05-13 12:25:22','未支付'),(87,'2023-05-13 04:25:22','7777777777','缴费类型7','费用7','老人编号7','老人姓名7','家属姓名7','2023-05-13 12:25:22','未支付'),(88,'2023-05-13 04:25:22','8888888888','缴费类型8','费用8','老人编号8','老人姓名8','家属姓名8','2023-05-13 12:25:22','未支付');
/*!40000 ALTER TABLE `feiyongxinxi` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `fuwugongdan`
--DROP TABLE IF EXISTS `fuwugongdan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwugongdan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`fuwuxiangmu` varchar(200) DEFAULT NULL COMMENT '服务项目',`yihugonghao` varchar(200) DEFAULT NULL COMMENT '医护工号',`yihuxingming` varchar(200) DEFAULT NULL COMMENT '医护姓名',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',`shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',`shijianduan` varchar(200) DEFAULT NULL COMMENT '时间段',`fuwuyaoqiu` longtext COMMENT '服务要求',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='服务工单';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `fuwugongdan`
--LOCK TABLES `fuwugongdan` WRITE;
/*!40000 ALTER TABLE `fuwugongdan` DISABLE KEYS */;
INSERT INTO `fuwugongdan` VALUES (51,'2023-05-13 04:25:22','服务项目1','医护工号1','医护姓名1','13823888881','老人编号1','老人姓名1','13823888881','时间段1','服务要求1'),(52,'2023-05-13 04:25:22','服务项目2','医护工号2','医护姓名2','13823888882','老人编号2','老人姓名2','13823888882','时间段2','服务要求2'),(53,'2023-05-13 04:25:22','服务项目3','医护工号3','医护姓名3','13823888883','老人编号3','老人姓名3','13823888883','时间段3','服务要求3'),(54,'2023-05-13 04:25:22','服务项目4','医护工号4','医护姓名4','13823888884','老人编号4','老人姓名4','13823888884','时间段4','服务要求4'),(55,'2023-05-13 04:25:22','服务项目5','医护工号5','医护姓名5','13823888885','老人编号5','老人姓名5','13823888885','时间段5','服务要求5'),(56,'2023-05-13 04:25:22','服务项目6','医护工号6','医护姓名6','13823888886','老人编号6','老人姓名6','13823888886','时间段6','服务要求6'),(57,'2023-05-13 04:25:22','服务项目7','医护工号7','医护姓名7','13823888887','老人编号7','老人姓名7','13823888887','时间段7','服务要求7'),(58,'2023-05-13 04:25:22','服务项目8','医护工号8','医护姓名8','13823888888','老人编号8','老人姓名8','13823888888','时间段8','服务要求8');
/*!40000 ALTER TABLE `fuwugongdan` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `hulifengxian`
--DROP TABLE IF EXISTS `hulifengxian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hulifengxian` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',`laorenxingbie` varchar(200) DEFAULT NULL COMMENT '老人性别',`laorennianling` int(11) DEFAULT NULL COMMENT '老人年龄',`fangjianhao` varchar(200) DEFAULT NULL COMMENT '房间号',`chuangweihao` varchar(200) DEFAULT NULL COMMENT '床位号',`tiwen` varchar(200) DEFAULT NULL COMMENT '体温',`yihugonghao` varchar(200) DEFAULT NULL COMMENT '医护工号',`yihuxingming` varchar(200) DEFAULT NULL COMMENT '医护姓名',`jiankangzhuangkuang` varchar(200) DEFAULT NULL COMMENT '健康状况',`hulifengxian` longtext COMMENT '护理风险',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='护理风险';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `hulifengxian`
--LOCK TABLES `hulifengxian` WRITE;
/*!40000 ALTER TABLE `hulifengxian` DISABLE KEYS */;
INSERT INTO `hulifengxian` VALUES (91,'2023-05-13 04:25:22','老人编号1','老人姓名1','老人性别1',1,'房间号1','床位号1','体温1','医护工号1','医护姓名1','良好','护理风险1'),(92,'2023-05-13 04:25:22','老人编号2','老人姓名2','老人性别2',2,'房间号2','床位号2','体温2','医护工号2','医护姓名2','良好','护理风险2'),(93,'2023-05-13 04:25:22','老人编号3','老人姓名3','老人性别3',3,'房间号3','床位号3','体温3','医护工号3','医护姓名3','良好','护理风险3'),(94,'2023-05-13 04:25:22','老人编号4','老人姓名4','老人性别4',4,'房间号4','床位号4','体温4','医护工号4','医护姓名4','良好','护理风险4'),(95,'2023-05-13 04:25:22','老人编号5','老人姓名5','老人性别5',5,'房间号5','床位号5','体温5','医护工号5','医护姓名5','良好','护理风险5'),(96,'2023-05-13 04:25:22','老人编号6','老人姓名6','老人性别6',6,'房间号6','床位号6','体温6','医护工号6','医护姓名6','良好','护理风险6'),(97,'2023-05-13 04:25:22','老人编号7','老人姓名7','老人性别7',7,'房间号7','床位号7','体温7','医护工号7','医护姓名7','良好','护理风险7'),(98,'2023-05-13 04:25:22','老人编号8','老人姓名8','老人性别8',8,'房间号8','床位号8','体温8','医护工号8','医护姓名8','良好','护理风险8');
/*!40000 ALTER TABLE `hulifengxian` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `hulijilu`
--DROP TABLE IF EXISTS `hulijilu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hulijilu` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',`laorenxingbie` varchar(200) DEFAULT NULL COMMENT '老人性别',`laorennianling` int(11) DEFAULT NULL COMMENT '老人年龄',`fangjianhao` varchar(200) DEFAULT NULL COMMENT '房间号',`chuangweihao` varchar(200) DEFAULT NULL COMMENT '床位号',`xueya` varchar(200) DEFAULT NULL COMMENT '血压',`xinlv` varchar(200) DEFAULT NULL COMMENT '心率',`tiwen` varchar(200) DEFAULT NULL COMMENT '体温',`shangcesuocishu` varchar(200) DEFAULT NULL COMMENT '上厕所次数',`chuangdangenghuanshijian` datetime DEFAULT NULL COMMENT '床单更换时间',`jiankangzhuangkuang` varchar(200) DEFAULT NULL COMMENT '健康状况',`yihugonghao` varchar(200) DEFAULT NULL COMMENT '医护工号',`yihuxingming` varchar(200) DEFAULT NULL COMMENT '医护姓名',`yihudengji` varchar(200) DEFAULT NULL COMMENT '医护等级',`dengjishijian` datetime DEFAULT NULL COMMENT '等级时间',`huliqingkuang` longtext COMMENT '护理情况',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='护理记录';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `hulijilu`
--LOCK TABLES `hulijilu` WRITE;
/*!40000 ALTER TABLE `hulijilu` DISABLE KEYS */;
INSERT INTO `hulijilu` VALUES (71,'2023-05-13 04:25:22','老人编号1','老人姓名1','老人性别1',1,'房间号1','床位号1','血压1','心率1','体温1','上厕所次数1','2023-05-13 12:25:22','良好','医护工号1','医护姓名1','医护等级1','2023-05-13 12:25:22','护理情况1'),(72,'2023-05-13 04:25:22','老人编号2','老人姓名2','老人性别2',2,'房间号2','床位号2','血压2','心率2','体温2','上厕所次数2','2023-05-13 12:25:22','良好','医护工号2','医护姓名2','医护等级2','2023-05-13 12:25:22','护理情况2'),(73,'2023-05-13 04:25:22','老人编号3','老人姓名3','老人性别3',3,'房间号3','床位号3','血压3','心率3','体温3','上厕所次数3','2023-05-13 12:25:22','良好','医护工号3','医护姓名3','医护等级3','2023-05-13 12:25:22','护理情况3'),(74,'2023-05-13 04:25:22','老人编号4','老人姓名4','老人性别4',4,'房间号4','床位号4','血压4','心率4','体温4','上厕所次数4','2023-05-13 12:25:22','良好','医护工号4','医护姓名4','医护等级4','2023-05-13 12:25:22','护理情况4'),(75,'2023-05-13 04:25:22','老人编号5','老人姓名5','老人性别5',5,'房间号5','床位号5','血压5','心率5','体温5','上厕所次数5','2023-05-13 12:25:22','良好','医护工号5','医护姓名5','医护等级5','2023-05-13 12:25:22','护理情况5'),(76,'2023-05-13 04:25:22','老人编号6','老人姓名6','老人性别6',6,'房间号6','床位号6','血压6','心率6','体温6','上厕所次数6','2023-05-13 12:25:22','良好','医护工号6','医护姓名6','医护等级6','2023-05-13 12:25:22','护理情况6'),(77,'2023-05-13 04:25:22','老人编号7','老人姓名7','老人性别7',7,'房间号7','床位号7','血压7','心率7','体温7','上厕所次数7','2023-05-13 12:25:22','良好','医护工号7','医护姓名7','医护等级7','2023-05-13 12:25:22','护理情况7'),(78,'2023-05-13 04:25:22','老人编号8','老人姓名8','老人性别8',8,'房间号8','床位号8','血压8','心率8','体温8','上厕所次数8','2023-05-13 12:25:22','良好','医护工号8','医护姓名8','医护等级8','2023-05-13 12:25:22','护理情况8');
/*!40000 ALTER TABLE `hulijilu` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `huodongxinxi`
--DROP TABLE IF EXISTS `huodongxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`huodongmingcheng` varchar(200) NOT NULL COMMENT '活动名称',`jubanshijian` date DEFAULT NULL COMMENT '举办时间',`huodongdidian` varchar(200) DEFAULT NULL COMMENT '活动地点',`huodongrenshu` varchar(200) DEFAULT NULL COMMENT '活动人数',`huodongneirong` longtext COMMENT '活动内容',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 COMMENT='活动信息';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `huodongxinxi`
--LOCK TABLES `huodongxinxi` WRITE;
/*!40000 ALTER TABLE `huodongxinxi` DISABLE KEYS */;
INSERT INTO `huodongxinxi` VALUES (191,'2023-05-13 04:25:22','活动名称1','2023-05-13','活动地点1','活动人数1','活动内容1'),(192,'2023-05-13 04:25:22','活动名称2','2023-05-13','活动地点2','活动人数2','活动内容2'),(193,'2023-05-13 04:25:22','活动名称3','2023-05-13','活动地点3','活动人数3','活动内容3'),(194,'2023-05-13 04:25:22','活动名称4','2023-05-13','活动地点4','活动人数4','活动内容4'),(195,'2023-05-13 04:25:22','活动名称5','2023-05-13','活动地点5','活动人数5','活动内容5'),(196,'2023-05-13 04:25:22','活动名称6','2023-05-13','活动地点6','活动人数6','活动内容6'),(197,'2023-05-13 04:25:22','活动名称7','2023-05-13','活动地点7','活动人数7','活动内容7'),(198,'2023-05-13 04:25:22','活动名称8','2023-05-13','活动地点8','活动人数8','活动内容8');
/*!40000 ALTER TABLE `huodongxinxi` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `jiankangdangan`
--DROP TABLE IF EXISTS `jiankangdangan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiankangdangan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`danganbianhao` varchar(200) DEFAULT NULL COMMENT '档案编号',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',`laorenxingbie` varchar(200) DEFAULT NULL COMMENT '老人性别',`laorennianling` varchar(200) DEFAULT NULL COMMENT '老人年龄',`shentiqingkuang` longtext COMMENT '身体情况',`jiazuyichuanshi` longtext COMMENT '家族遗传史',`shenghuojinji` longtext COMMENT '生活禁忌',`yaowuguominshi` longtext COMMENT '药物过敏史',`gengxinshijian` datetime DEFAULT NULL COMMENT '更新时间',PRIMARY KEY (`id`),UNIQUE KEY `danganbianhao` (`danganbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='健康档案';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `jiankangdangan`
--LOCK TABLES `jiankangdangan` WRITE;
/*!40000 ALTER TABLE `jiankangdangan` DISABLE KEYS */;
INSERT INTO `jiankangdangan` VALUES (61,'2023-05-13 04:25:22','1111111111','老人编号1','老人姓名1','老人性别1','老人年龄1','身体情况1','家族遗传史1','生活禁忌1','药物过敏史1','2023-05-13 12:25:22'),(62,'2023-05-13 04:25:22','2222222222','老人编号2','老人姓名2','老人性别2','老人年龄2','身体情况2','家族遗传史2','生活禁忌2','药物过敏史2','2023-05-13 12:25:22'),(63,'2023-05-13 04:25:22','3333333333','老人编号3','老人姓名3','老人性别3','老人年龄3','身体情况3','家族遗传史3','生活禁忌3','药物过敏史3','2023-05-13 12:25:22'),(64,'2023-05-13 04:25:22','4444444444','老人编号4','老人姓名4','老人性别4','老人年龄4','身体情况4','家族遗传史4','生活禁忌4','药物过敏史4','2023-05-13 12:25:22'),(65,'2023-05-13 04:25:22','5555555555','老人编号5','老人姓名5','老人性别5','老人年龄5','身体情况5','家族遗传史5','生活禁忌5','药物过敏史5','2023-05-13 12:25:22'),(66,'2023-05-13 04:25:22','6666666666','老人编号6','老人姓名6','老人性别6','老人年龄6','身体情况6','家族遗传史6','生活禁忌6','药物过敏史6','2023-05-13 12:25:22'),(67,'2023-05-13 04:25:22','7777777777','老人编号7','老人姓名7','老人性别7','老人年龄7','身体情况7','家族遗传史7','生活禁忌7','药物过敏史7','2023-05-13 12:25:22'),(68,'2023-05-13 04:25:22','8888888888','老人编号8','老人姓名8','老人性别8','老人年龄8','身体情况8','家族遗传史8','生活禁忌8','药物过敏史8','2023-05-13 12:25:22');
/*!40000 ALTER TABLE `jiankangdangan` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `jiashutanwang`
--DROP TABLE IF EXISTS `jiashutanwang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiashutanwang` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',`jiashuxingming` varchar(200) DEFAULT NULL COMMENT '家属姓名',`shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',`jiankangma` longtext COMMENT '健康码',`xingchengma` longtext COMMENT '行程码',`hesuanjiancejieguo` varchar(200) DEFAULT NULL COMMENT '核酸检测结果',`tanwangshijian` date DEFAULT NULL COMMENT '探望时间',`beizhu` longtext COMMENT '备注',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COMMENT='家属探望';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `jiashutanwang`
--LOCK TABLES `jiashutanwang` WRITE;
/*!40000 ALTER TABLE `jiashutanwang` DISABLE KEYS */;
INSERT INTO `jiashutanwang` VALUES (171,'2023-05-13 04:25:22','老人编号1','老人姓名1','家属姓名1','手机号1','upload/jiashutanwang_jiankangma1.jpg,upload/jiashutanwang_jiankangma2.jpg,upload/jiashutanwang_jiankangma3.jpg','upload/jiashutanwang_xingchengma1.jpg,upload/jiashutanwang_xingchengma2.jpg,upload/jiashutanwang_xingchengma3.jpg','阴性','2023-05-13','备注1'),(172,'2023-05-13 04:25:22','老人编号2','老人姓名2','家属姓名2','手机号2','upload/jiashutanwang_jiankangma2.jpg,upload/jiashutanwang_jiankangma3.jpg,upload/jiashutanwang_jiankangma4.jpg','upload/jiashutanwang_xingchengma2.jpg,upload/jiashutanwang_xingchengma3.jpg,upload/jiashutanwang_xingchengma4.jpg','阴性','2023-05-13','备注2'),(173,'2023-05-13 04:25:22','老人编号3','老人姓名3','家属姓名3','手机号3','upload/jiashutanwang_jiankangma3.jpg,upload/jiashutanwang_jiankangma4.jpg,upload/jiashutanwang_jiankangma5.jpg','upload/jiashutanwang_xingchengma3.jpg,upload/jiashutanwang_xingchengma4.jpg,upload/jiashutanwang_xingchengma5.jpg','阴性','2023-05-13','备注3'),(174,'2023-05-13 04:25:22','老人编号4','老人姓名4','家属姓名4','手机号4','upload/jiashutanwang_jiankangma4.jpg,upload/jiashutanwang_jiankangma5.jpg,upload/jiashutanwang_jiankangma6.jpg','upload/jiashutanwang_xingchengma4.jpg,upload/jiashutanwang_xingchengma5.jpg,upload/jiashutanwang_xingchengma6.jpg','阴性','2023-05-13','备注4'),(175,'2023-05-13 04:25:22','老人编号5','老人姓名5','家属姓名5','手机号5','upload/jiashutanwang_jiankangma5.jpg,upload/jiashutanwang_jiankangma6.jpg,upload/jiashutanwang_jiankangma7.jpg','upload/jiashutanwang_xingchengma5.jpg,upload/jiashutanwang_xingchengma6.jpg,upload/jiashutanwang_xingchengma7.jpg','阴性','2023-05-13','备注5'),(176,'2023-05-13 04:25:22','老人编号6','老人姓名6','家属姓名6','手机号6','upload/jiashutanwang_jiankangma6.jpg,upload/jiashutanwang_jiankangma7.jpg,upload/jiashutanwang_jiankangma8.jpg','upload/jiashutanwang_xingchengma6.jpg,upload/jiashutanwang_xingchengma7.jpg,upload/jiashutanwang_xingchengma8.jpg','阴性','2023-05-13','备注6'),(177,'2023-05-13 04:25:22','老人编号7','老人姓名7','家属姓名7','手机号7','upload/jiashutanwang_jiankangma7.jpg,upload/jiashutanwang_jiankangma8.jpg,upload/jiashutanwang_jiankangma9.jpg','upload/jiashutanwang_xingchengma7.jpg,upload/jiashutanwang_xingchengma8.jpg,upload/jiashutanwang_xingchengma9.jpg','阴性','2023-05-13','备注7'),(178,'2023-05-13 04:25:22','老人编号8','老人姓名8','家属姓名8','手机号8','upload/jiashutanwang_jiankangma8.jpg,upload/jiashutanwang_jiankangma9.jpg,upload/jiashutanwang_jiankangma10.jpg','upload/jiashutanwang_xingchengma8.jpg,upload/jiashutanwang_xingchengma9.jpg,upload/jiashutanwang_xingchengma10.jpg','阴性','2023-05-13','备注8');
/*!40000 ALTER TABLE `jiashutanwang` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `laifangdengji`
--DROP TABLE IF EXISTS `laifangdengji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `laifangdengji` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`laifangfenlei` varchar(200) DEFAULT NULL COMMENT '来访分类',`laifangshijian` date DEFAULT NULL COMMENT '来访时间',`laifangguocheng` longtext COMMENT '来访过程',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8 COMMENT='来访登记';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `laifangdengji`
--LOCK TABLES `laifangdengji` WRITE;
/*!40000 ALTER TABLE `laifangdengji` DISABLE KEYS */;
INSERT INTO `laifangdengji` VALUES (161,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程1'),(162,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程2'),(163,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程3'),(164,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程4'),(165,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程5'),(166,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程6'),(167,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程7'),(168,'2023-05-13 04:25:22','志愿者','2023-05-13','来访过程8');
/*!40000 ALTER TABLE `laifangdengji` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `laoren`
--DROP TABLE IF EXISTS `laoren`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `laoren` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`laorenbianhao` varchar(200) DEFAULT NULL COMMENT '老人编号',`laorenxingming` varchar(200) NOT NULL COMMENT '老人姓名',`mima` varchar(200) DEFAULT NULL COMMENT '密码',`laorenxingbie` varchar(200) DEFAULT NULL COMMENT '老人性别',`laorennianling` varchar(200) DEFAULT NULL COMMENT '老人年龄',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`jiashuxingming` varchar(200) DEFAULT NULL COMMENT '家属姓名',`guanxi` varchar(200) DEFAULT NULL COMMENT '关系',`shoujihao` varchar(200) DEFAULT NULL COMMENT '手机号',`jiatingzhuzhi` varchar(200) DEFAULT NULL COMMENT '家庭住址',PRIMARY KEY (`id`),UNIQUE KEY `laorenbianhao` (`laorenbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='老人';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `laoren`
--LOCK TABLES `laoren` WRITE;
/*!40000 ALTER TABLE `laoren` DISABLE KEYS */;
INSERT INTO `laoren` VALUES (31,'2023-05-13 04:25:22','老人编号1','老人姓名1','123456','男','老人年龄1','13823888881','家属姓名1','关系1','手机号1','家庭住址1'),(32,'2023-05-13 04:25:22','老人编号2','老人姓名2','123456','男','老人年龄2','13823888882','家属姓名2','关系2','手机号2','家庭住址2'),(33,'2023-05-13 04:25:22','老人编号3','老人姓名3','123456','男','老人年龄3','13823888883','家属姓名3','关系3','手机号3','家庭住址3'),(34,'2023-05-13 04:25:22','老人编号4','老人姓名4','123456','男','老人年龄4','13823888884','家属姓名4','关系4','手机号4','家庭住址4'),(35,'2023-05-13 04:25:22','老人编号5','老人姓名5','123456','男','老人年龄5','13823888885','家属姓名5','关系5','手机号5','家庭住址5'),(36,'2023-05-13 04:25:22','老人编号6','老人姓名6','123456','男','老人年龄6','13823888886','家属姓名6','关系6','手机号6','家庭住址6'),(37,'2023-05-13 04:25:22','老人编号7','老人姓名7','123456','男','老人年龄7','13823888887','家属姓名7','关系7','手机号7','家庭住址7'),(38,'2023-05-13 04:25:22','老人编号8','老人姓名8','123456','男','老人年龄8','13823888888','家属姓名8','关系8','手机号8','家庭住址8');
/*!40000 ALTER TABLE `laoren` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `qingjiashenqing`
--DROP TABLE IF EXISTS `qingjiashenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qingjiashenqing` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yihugonghao` varchar(200) DEFAULT NULL COMMENT '医护工号',`yihuxingming` varchar(200) DEFAULT NULL COMMENT '医护姓名',`qingjialeixing` varchar(200) DEFAULT NULL COMMENT '请假类型',`qishishijian` date DEFAULT NULL COMMENT '起始时间',`jieshushijian` date DEFAULT NULL COMMENT '结束时间',`qingjiashiyou` longtext COMMENT '请假事由',`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8 COMMENT='请假申请';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `qingjiashenqing`
--LOCK TABLES `qingjiashenqing` WRITE;
/*!40000 ALTER TABLE `qingjiashenqing` DISABLE KEYS */;
INSERT INTO `qingjiashenqing` VALUES (181,'2023-05-13 04:25:22','医护工号1','医护姓名1','事假','2023-05-13','2023-05-13','请假事由1','是',''),(182,'2023-05-13 04:25:22','医护工号2','医护姓名2','事假','2023-05-13','2023-05-13','请假事由2','是',''),(183,'2023-05-13 04:25:22','医护工号3','医护姓名3','事假','2023-05-13','2023-05-13','请假事由3','是',''),(184,'2023-05-13 04:25:22','医护工号4','医护姓名4','事假','2023-05-13','2023-05-13','请假事由4','是',''),(185,'2023-05-13 04:25:22','医护工号5','医护姓名5','事假','2023-05-13','2023-05-13','请假事由5','是',''),(186,'2023-05-13 04:25:22','医护工号6','医护姓名6','事假','2023-05-13','2023-05-13','请假事由6','是',''),(187,'2023-05-13 04:25:22','医护工号7','医护姓名7','事假','2023-05-13','2023-05-13','请假事由7','是',''),(188,'2023-05-13 04:25:22','医护工号8','医护姓名8','事假','2023-05-13','2023-05-13','请假事由8','是','');
/*!40000 ALTER TABLE `qingjiashenqing` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `shanshixinxi`
--DROP TABLE IF EXISTS `shanshixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shanshixinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`biaoti` varchar(200) DEFAULT NULL COMMENT '标题',`riqi` date DEFAULT NULL COMMENT '日期',`zaocan` varchar(200) DEFAULT NULL COMMENT '早餐',`wucan` varchar(200) DEFAULT NULL COMMENT '午餐',`wancan` varchar(200) DEFAULT NULL COMMENT '晚餐',`dianxin` varchar(200) DEFAULT NULL COMMENT '点心',`shuiguo` varchar(200) DEFAULT NULL COMMENT '水果',`jiage` varchar(200) DEFAULT NULL COMMENT '价格',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='膳食信息';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `shanshixinxi`
--LOCK TABLES `shanshixinxi` WRITE;
/*!40000 ALTER TABLE `shanshixinxi` DISABLE KEYS */;
INSERT INTO `shanshixinxi` VALUES (101,'2023-05-13 04:25:22','标题1','2023-05-13','早餐1','午餐1','晚餐1','点心1','水果1','价格1'),(102,'2023-05-13 04:25:22','标题2','2023-05-13','早餐2','午餐2','晚餐2','点心2','水果2','价格2'),(103,'2023-05-13 04:25:22','标题3','2023-05-13','早餐3','午餐3','晚餐3','点心3','水果3','价格3'),(104,'2023-05-13 04:25:22','标题4','2023-05-13','早餐4','午餐4','晚餐4','点心4','水果4','价格4'),(105,'2023-05-13 04:25:22','标题5','2023-05-13','早餐5','午餐5','晚餐5','点心5','水果5','价格5'),(106,'2023-05-13 04:25:22','标题6','2023-05-13','早餐6','午餐6','晚餐6','点心6','水果6','价格6'),(107,'2023-05-13 04:25:22','标题7','2023-05-13','早餐7','午餐7','晚餐7','点心7','水果7','价格7'),(108,'2023-05-13 04:25:22','标题8','2023-05-13','早餐8','午餐8','晚餐8','点心8','水果8','价格8');
/*!40000 ALTER TABLE `shanshixinxi` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `sheshixinxi`
--DROP TABLE IF EXISTS `sheshixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheshixinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`sheshibianhao` varchar(200) DEFAULT NULL COMMENT '设施编号',`sheshimingcheng` varchar(200) DEFAULT NULL COMMENT '设施名称',`zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',`shiyongnianxian` varchar(200) DEFAULT NULL COMMENT '使用年限',`xiangqing` longtext COMMENT '详情',PRIMARY KEY (`id`),UNIQUE KEY `sheshibianhao` (`sheshibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='设施信息';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `sheshixinxi`
--LOCK TABLES `sheshixinxi` WRITE;
/*!40000 ALTER TABLE `sheshixinxi` DISABLE KEYS */;
INSERT INTO `sheshixinxi` VALUES (41,'2023-05-13 04:25:22','1111111111','设施名称1','正常','使用年限1','详情1'),(42,'2023-05-13 04:25:22','2222222222','设施名称2','正常','使用年限2','详情2'),(43,'2023-05-13 04:25:22','3333333333','设施名称3','正常','使用年限3','详情3'),(44,'2023-05-13 04:25:22','4444444444','设施名称4','正常','使用年限4','详情4'),(45,'2023-05-13 04:25:22','5555555555','设施名称5','正常','使用年限5','详情5'),(46,'2023-05-13 04:25:22','6666666666','设施名称6','正常','使用年限6','详情6'),(47,'2023-05-13 04:25:22','7777777777','设施名称7','正常','使用年限7','详情7'),(48,'2023-05-13 04:25:22','8888888888','设施名称8','正常','使用年限8','详情8');
/*!40000 ALTER TABLE `sheshixinxi` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `storeup`
--DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`userid` bigint(20) NOT NULL COMMENT '用户id',`refid` bigint(20) DEFAULT NULL COMMENT '商品id',`tablename` varchar(200) DEFAULT NULL COMMENT '表名',`name` varchar(200) NOT NULL COMMENT '名称',`picture` longtext NOT NULL COMMENT '图片',`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注)',`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',`remark` varchar(200) DEFAULT NULL COMMENT '备注',PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `storeup`
--LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `token`
--DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`userid` bigint(20) NOT NULL COMMENT '用户id',`username` varchar(100) NOT NULL COMMENT '用户名',`tablename` varchar(100) DEFAULT NULL COMMENT '表名',`role` varchar(100) DEFAULT NULL COMMENT '角色',`token` varchar(200) NOT NULL COMMENT '密码',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `token`
--LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1,'admin','users','管理员','2molr15qwyz6g1ru30x0v5jbklvucug8','2023-05-13 04:29:22','2023-05-13 05:29:22'),(2,38,'老人编号8','laoren','老人','f8uf7nm1i0e65mkn5zgxwh8q9yaprcu6','2023-05-13 04:30:59','2023-05-13 05:31:00');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `users`
--DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(100) NOT NULL COMMENT '用户名',`password` varchar(100) NOT NULL COMMENT '密码',`role` varchar(100) DEFAULT '管理员' COMMENT '角色',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `users`
--LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','管理员','2023-05-13 04:25:23');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `wuzichuku`
--DROP TABLE IF EXISTS `wuzichuku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wuzichuku` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`chukubianhao` varchar(200) DEFAULT NULL COMMENT '出库编号',`wuzibianhao` varchar(200) DEFAULT NULL COMMENT '物资编号',`wuzimingcheng` varchar(200) DEFAULT NULL COMMENT '物资名称',`wuzifenlei` varchar(200) DEFAULT NULL COMMENT '物资分类',`wuzishuliang` int(11) DEFAULT NULL COMMENT '物资数量',`chukushijian` datetime DEFAULT NULL COMMENT '出库时间',`beizhu` longtext COMMENT '备注',PRIMARY KEY (`id`),UNIQUE KEY `chukubianhao` (`chukubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8 COMMENT='物资出库';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `wuzichuku`
--LOCK TABLES `wuzichuku` WRITE;
/*!40000 ALTER TABLE `wuzichuku` DISABLE KEYS */;
INSERT INTO `wuzichuku` VALUES (131,'2023-05-13 04:25:22','1111111111','物资编号1','物资名称1','物资分类1',1,'2023-05-13 12:25:22','备注1'),(132,'2023-05-13 04:25:22','2222222222','物资编号2','物资名称2','物资分类2',2,'2023-05-13 12:25:22','备注2'),(133,'2023-05-13 04:25:22','3333333333','物资编号3','物资名称3','物资分类3',3,'2023-05-13 12:25:22','备注3'),(134,'2023-05-13 04:25:22','4444444444','物资编号4','物资名称4','物资分类4',4,'2023-05-13 12:25:22','备注4'),(135,'2023-05-13 04:25:22','5555555555','物资编号5','物资名称5','物资分类5',5,'2023-05-13 12:25:22','备注5'),(136,'2023-05-13 04:25:22','6666666666','物资编号6','物资名称6','物资分类6',6,'2023-05-13 12:25:22','备注6'),(137,'2023-05-13 04:25:22','7777777777','物资编号7','物资名称7','物资分类7',7,'2023-05-13 12:25:22','备注7'),(138,'2023-05-13 04:25:22','8888888888','物资编号8','物资名称8','物资分类8',8,'2023-05-13 12:25:22','备注8');
/*!40000 ALTER TABLE `wuzichuku` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `wuzifenlei`
--DROP TABLE IF EXISTS `wuzifenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wuzifenlei` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`wuzifenlei` varchar(200) DEFAULT NULL COMMENT '物资分类',PRIMARY KEY (`id`),UNIQUE KEY `wuzifenlei` (`wuzifenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='物资分类';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `wuzifenlei`
--LOCK TABLES `wuzifenlei` WRITE;
/*!40000 ALTER TABLE `wuzifenlei` DISABLE KEYS */;
INSERT INTO `wuzifenlei` VALUES (111,'2023-05-13 04:25:22','物资分类1'),(112,'2023-05-13 04:25:22','物资分类2'),(113,'2023-05-13 04:25:22','物资分类3'),(114,'2023-05-13 04:25:22','物资分类4'),(115,'2023-05-13 04:25:22','物资分类5'),(116,'2023-05-13 04:25:22','物资分类6'),(117,'2023-05-13 04:25:22','物资分类7'),(118,'2023-05-13 04:25:22','物资分类8');
/*!40000 ALTER TABLE `wuzifenlei` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `wuziruku`
--DROP TABLE IF EXISTS `wuziruku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wuziruku` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`rukubianhao` varchar(200) DEFAULT NULL COMMENT '入库编号',`wuzimingcheng` varchar(200) DEFAULT NULL COMMENT '物资名称',`wuzishuliang` int(11) DEFAULT NULL COMMENT '物资数量',`rukuriqi` date DEFAULT NULL COMMENT '入库日期',`beizhu` longtext COMMENT '备注',PRIMARY KEY (`id`),UNIQUE KEY `rukubianhao` (`rukubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COMMENT='物资入库';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `wuziruku`
--LOCK TABLES `wuziruku` WRITE;
/*!40000 ALTER TABLE `wuziruku` DISABLE KEYS */;
INSERT INTO `wuziruku` VALUES (141,'2023-05-13 04:25:22','1111111111','物资名称1',1,'2023-05-13','备注1'),(142,'2023-05-13 04:25:22','2222222222','物资名称2',2,'2023-05-13','备注2'),(143,'2023-05-13 04:25:22','3333333333','物资名称3',3,'2023-05-13','备注3'),(144,'2023-05-13 04:25:22','4444444444','物资名称4',4,'2023-05-13','备注4'),(145,'2023-05-13 04:25:22','5555555555','物资名称5',5,'2023-05-13','备注5'),(146,'2023-05-13 04:25:22','6666666666','物资名称6',6,'2023-05-13','备注6'),(147,'2023-05-13 04:25:22','7777777777','物资名称7',7,'2023-05-13','备注7'),(148,'2023-05-13 04:25:22','8888888888','物资名称8',8,'2023-05-13','备注8');
/*!40000 ALTER TABLE `wuziruku` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `wuzixinxi`
--DROP TABLE IF EXISTS `wuzixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wuzixinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`wuzibianhao` varchar(200) DEFAULT NULL COMMENT '物资编号',`wuzimingcheng` varchar(200) DEFAULT NULL COMMENT '物资名称',`wuzifenlei` varchar(200) DEFAULT NULL COMMENT '物资分类',`wuzishuliang` int(11) DEFAULT NULL COMMENT '物资数量',`gongyingshang` varchar(200) DEFAULT NULL COMMENT '供应商',`cunfangweizhi` varchar(200) DEFAULT NULL COMMENT '存放位置',PRIMARY KEY (`id`),UNIQUE KEY `wuzibianhao` (`wuzibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='物资信息';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `wuzixinxi`
--LOCK TABLES `wuzixinxi` WRITE;
/*!40000 ALTER TABLE `wuzixinxi` DISABLE KEYS */;
INSERT INTO `wuzixinxi` VALUES (121,'2023-05-13 04:25:22','1111111111','物资名称1','物资分类1',1,'供应商1','存放位置1'),(122,'2023-05-13 04:25:22','2222222222','物资名称2','物资分类2',2,'供应商2','存放位置2'),(123,'2023-05-13 04:25:22','3333333333','物资名称3','物资分类3',3,'供应商3','存放位置3'),(124,'2023-05-13 04:25:22','4444444444','物资名称4','物资分类4',4,'供应商4','存放位置4'),(125,'2023-05-13 04:25:22','5555555555','物资名称5','物资分类5',5,'供应商5','存放位置5'),(126,'2023-05-13 04:25:22','6666666666','物资名称6','物资分类6',6,'供应商6','存放位置6'),(127,'2023-05-13 04:25:22','7777777777','物资名称7','物资分类7',7,'供应商7','存放位置7'),(128,'2023-05-13 04:25:22','8888888888','物资名称8','物资分类8',8,'供应商8','存放位置8');
/*!40000 ALTER TABLE `wuzixinxi` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `yihudengji`
--DROP TABLE IF EXISTS `yihudengji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yihudengji` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yihudengji` varchar(200) NOT NULL COMMENT '医护等级',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='医护等级';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `yihudengji`
--LOCK TABLES `yihudengji` WRITE;
/*!40000 ALTER TABLE `yihudengji` DISABLE KEYS */;
INSERT INTO `yihudengji` VALUES (11,'2023-05-13 04:25:22','医护等级1'),(12,'2023-05-13 04:25:22','医护等级2'),(13,'2023-05-13 04:25:22','医护等级3'),(14,'2023-05-13 04:25:22','医护等级4'),(15,'2023-05-13 04:25:22','医护等级5'),(16,'2023-05-13 04:25:22','医护等级6'),(17,'2023-05-13 04:25:22','医护等级7'),(18,'2023-05-13 04:25:22','医护等级8');
/*!40000 ALTER TABLE `yihudengji` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `yihurenyuan`
--DROP TABLE IF EXISTS `yihurenyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yihurenyuan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yihugonghao` varchar(200) NOT NULL COMMENT '医护工号',`mima` varchar(200) NOT NULL COMMENT '密码',`yihuxingming` varchar(200) NOT NULL COMMENT '医护姓名',`yihuxingbie` varchar(200) DEFAULT NULL COMMENT '医护性别',`yihudengji` varchar(200) DEFAULT NULL COMMENT '医护等级',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',PRIMARY KEY (`id`),UNIQUE KEY `yihugonghao` (`yihugonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='医护人员';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `yihurenyuan`
--LOCK TABLES `yihurenyuan` WRITE;
/*!40000 ALTER TABLE `yihurenyuan` DISABLE KEYS */;
INSERT INTO `yihurenyuan` VALUES (21,'2023-05-13 04:25:22','医护工号1','123456','医护姓名1','男','医护等级1','13823888881','440300199101010001'),(22,'2023-05-13 04:25:22','医护工号2','123456','医护姓名2','男','医护等级2','13823888882','440300199202020002'),(23,'2023-05-13 04:25:22','医护工号3','123456','医护姓名3','男','医护等级3','13823888883','440300199303030003'),(24,'2023-05-13 04:25:22','医护工号4','123456','医护姓名4','男','医护等级4','13823888884','440300199404040004'),(25,'2023-05-13 04:25:22','医护工号5','123456','医护姓名5','男','医护等级5','13823888885','440300199505050005'),(26,'2023-05-13 04:25:22','医护工号6','123456','医护姓名6','男','医护等级6','13823888886','440300199606060006'),(27,'2023-05-13 04:25:22','医护工号7','123456','医护姓名7','男','医护等级7','13823888887','440300199707070007'),(28,'2023-05-13 04:25:22','医护工号8','123456','医护姓名8','男','医护等级8','13823888888','440300199808080008');
/*!40000 ALTER TABLE `yihurenyuan` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `yuangongdangan`
--DROP TABLE IF EXISTS `yuangongdangan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuangongdangan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yihugonghao` varchar(200) DEFAULT NULL COMMENT '医护工号',`yihuxingming` varchar(200) DEFAULT NULL COMMENT '医护姓名',`yihuxingbie` varchar(200) DEFAULT NULL COMMENT '医护性别',`zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',`ruzhishijian` datetime DEFAULT NULL COMMENT '入职时间',`lizhishijian` datetime DEFAULT NULL COMMENT '离职时间',`beizhu` longtext COMMENT '备注',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8 COMMENT='员工档案';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `yuangongdangan`
--LOCK TABLES `yuangongdangan` WRITE;
/*!40000 ALTER TABLE `yuangongdangan` DISABLE KEYS */;
INSERT INTO `yuangongdangan` VALUES (151,'2023-05-13 04:25:22','医护工号1','医护姓名1','医护性别1','职称1','13823888881','2023-05-13 12:25:22','2023-05-13 12:25:22','备注1'),(152,'2023-05-13 04:25:22','医护工号2','医护姓名2','医护性别2','职称2','13823888882','2023-05-13 12:25:22','2023-05-13 12:25:22','备注2'),(153,'2023-05-13 04:25:22','医护工号3','医护姓名3','医护性别3','职称3','13823888883','2023-05-13 12:25:22','2023-05-13 12:25:22','备注3'),(154,'2023-05-13 04:25:22','医护工号4','医护姓名4','医护性别4','职称4','13823888884','2023-05-13 12:25:22','2023-05-13 12:25:22','备注4'),(155,'2023-05-13 04:25:22','医护工号5','医护姓名5','医护性别5','职称5','13823888885','2023-05-13 12:25:22','2023-05-13 12:25:22','备注5'),(156,'2023-05-13 04:25:22','医护工号6','医护姓名6','医护性别6','职称6','13823888886','2023-05-13 12:25:22','2023-05-13 12:25:22','备注6'),(157,'2023-05-13 04:25:22','医护工号7','医护姓名7','医护性别7','职称7','13823888887','2023-05-13 12:25:22','2023-05-13 12:25:22','备注7'),(158,'2023-05-13 04:25:22','医护工号8','医护姓名8','医护性别8','职称8','13823888888','2023-05-13 12:25:22','2023-05-13 12:25:22','备注8');
/*!40000 ALTER TABLE `yuangongdangan` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on
5、关键代码
5.1 服务工单Controller模块
package com.controller;import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;import com.entity.FuwugongdanEntity;
import com.entity.view.FuwugongdanView;import com.service.FuwugongdanService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;/*** 服务工单* 后端接口* @author * @email * @date 2023-05-13 12:25:08*/
@RestController
@RequestMapping("/fuwugongdan")
public class FuwugongdanController {@Autowiredprivate FuwugongdanService fuwugongdanService;/*** 后端列表*/@RequestMapping("/page")public R page(@RequestParam Map<String, Object> params,FuwugongdanEntity fuwugongdan,HttpServletRequest request){String tableName = request.getSession().getAttribute("tableName").toString();if(tableName.equals("yihurenyuan")) {fuwugongdan.setYihugonghao((String)request.getSession().getAttribute("username"));}if(tableName.equals("laoren")) {fuwugongdan.setLaorenbianhao((String)request.getSession().getAttribute("username"));}EntityWrapper<FuwugongdanEntity> ew = new EntityWrapper<FuwugongdanEntity>();PageUtils page = fuwugongdanService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, fuwugongdan), params), params));return R.ok().put("data", page);}/*** 前端列表*/@IgnoreAuth@RequestMapping("/list")public R list(@RequestParam Map<String, Object> params,FuwugongdanEntity fuwugongdan, HttpServletRequest request){EntityWrapper<FuwugongdanEntity> ew = new EntityWrapper<FuwugongdanEntity>();PageUtils page = fuwugongdanService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, fuwugongdan), params), params));return R.ok().put("data", page);}/*** 列表*/@RequestMapping("/lists")public R list( FuwugongdanEntity fuwugongdan){EntityWrapper<FuwugongdanEntity> ew = new EntityWrapper<FuwugongdanEntity>();ew.allEq(MPUtil.allEQMapPre( fuwugongdan, "fuwugongdan")); return R.ok().put("data", fuwugongdanService.selectListView(ew));}/*** 查询*/@RequestMapping("/query")public R query(FuwugongdanEntity fuwugongdan){EntityWrapper< FuwugongdanEntity> ew = new EntityWrapper< FuwugongdanEntity>();ew.allEq(MPUtil.allEQMapPre( fuwugongdan, "fuwugongdan")); FuwugongdanView fuwugongdanView = fuwugongdanService.selectView(ew);return R.ok("查询服务工单成功").put("data", fuwugongdanView);}/*** 后端详情*/@RequestMapping("/info/{id}")public R info(@PathVariable("id") Long id){FuwugongdanEntity fuwugongdan = fuwugongdanService.selectById(id);return R.ok().put("data", fuwugongdan);}/*** 前端详情*/@IgnoreAuth@RequestMapping("/detail/{id}")public R detail(@PathVariable("id") Long id){FuwugongdanEntity fuwugongdan = fuwugongdanService.selectById(id);return R.ok().put("data", fuwugongdan);}/*** 后端保存*/@RequestMapping("/save")public R save(@RequestBody FuwugongdanEntity fuwugongdan, HttpServletRequest request){fuwugongdan.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(fuwugongdan);fuwugongdanService.insert(fuwugongdan);return R.ok();}/*** 前端保存*/@RequestMapping("/add")public R add(@RequestBody FuwugongdanEntity fuwugongdan, HttpServletRequest request){fuwugongdan.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(fuwugongdan);fuwugongdanService.insert(fuwugongdan);return R.ok();}/*** 修改*/@RequestMapping("/update")@Transactionalpublic R update(@RequestBody FuwugongdanEntity fuwugongdan, HttpServletRequest request){//ValidatorUtils.validateEntity(fuwugongdan);fuwugongdanService.updateById(fuwugongdan);//全部更新return R.ok();}/*** 删除*/@RequestMapping("/delete")public R delete(@RequestBody Long[] ids){fuwugongdanService.deleteBatchIds(Arrays.asList(ids));return R.ok();}}
5.2 服务工单Service模块
package com.service;import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.FuwugongdanEntity;
import java.util.List;
import java.util.Map;
import com.entity.vo.FuwugongdanVO;
import org.apache.ibatis.annotations.Param;
import com.entity.view.FuwugongdanView;/*** 服务工单** @author * @email * @date 2023-05-13 12:25:08*/
public interface FuwugongdanService extends IService<FuwugongdanEntity> {PageUtils queryPage(Map<String, Object> params);List<FuwugongdanVO> selectListVO(Wrapper<FuwugongdanEntity> wrapper);FuwugongdanVO selectVO(@Param("ew") Wrapper<FuwugongdanEntity> wrapper);List<FuwugongdanView> selectListView(Wrapper<FuwugongdanEntity> wrapper);FuwugongdanView selectView(@Param("ew") Wrapper<FuwugongdanEntity> wrapper);PageUtils queryPage(Map<String, Object> params,Wrapper<FuwugongdanEntity> wrapper);}5.3 服务工单ServiceImpl模块
package com.service.impl;import org.springframework.stereotype.Service;
import java.util.Map;
import java.util.List;import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.utils.PageUtils;
import com.utils.Query;import com.dao.FuwugongdanDao;
import com.entity.FuwugongdanEntity;
import com.service.FuwugongdanService;
import com.entity.vo.FuwugongdanVO;
import com.entity.view.FuwugongdanView;@Service("fuwugongdanService")
public class FuwugongdanServiceImpl extends ServiceImpl<FuwugongdanDao, FuwugongdanEntity> implements FuwugongdanService {@Overridepublic PageUtils queryPage(Map<String, Object> params) {Page<FuwugongdanEntity> page = this.selectPage(new Query<FuwugongdanEntity>(params).getPage(),new EntityWrapper<FuwugongdanEntity>());return new PageUtils(page);}@Overridepublic PageUtils queryPage(Map<String, Object> params, Wrapper<FuwugongdanEntity> wrapper) {Page<FuwugongdanView> page =new Query<FuwugongdanView>(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil = new PageUtils(page);return pageUtil;}@Overridepublic List<FuwugongdanVO> selectListVO(Wrapper<FuwugongdanEntity> wrapper) {return baseMapper.selectListVO(wrapper);}@Overridepublic FuwugongdanVO selectVO(Wrapper<FuwugongdanEntity> wrapper) {return baseMapper.selectVO(wrapper);}@Overridepublic List<FuwugongdanView> selectListView(Wrapper<FuwugongdanEntity> wrapper) {return baseMapper.selectListView(wrapper);}@Overridepublic FuwugongdanView selectView(Wrapper<FuwugongdanEntity> wrapper) {return baseMapper.selectView(wrapper);}}
5.4 服务工单Dao模块
package com.dao;import com.entity.FuwugongdanEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;import org.apache.ibatis.annotations.Param;
import com.entity.vo.FuwugongdanVO;
import com.entity.view.FuwugongdanView;/*** 服务工单* * @author * @email * @date 2023-05-13 12:25:08*/
public interface FuwugongdanDao extends BaseMapper<FuwugongdanEntity> {List<FuwugongdanVO> selectListVO(@Param("ew") Wrapper<FuwugongdanEntity> wrapper);FuwugongdanVO selectVO(@Param("ew") Wrapper<FuwugongdanEntity> wrapper);List<FuwugongdanView> selectListView(@Param("ew") Wrapper<FuwugongdanEntity> wrapper);List<FuwugongdanView> selectListView(Pagination page,@Param("ew") Wrapper<FuwugongdanEntity> wrapper);FuwugongdanView selectView(@Param("ew") Wrapper<FuwugongdanEntity> wrapper);}
6、论文目录结构
7、源码获取
感谢大家的阅读，如有不懂的问题可以评论区交流或私聊!
喜欢文章可以点赞、收藏、关注、评论啦
→获取源码请私信←
相关文章：
计算机毕业设计 基于SpringBoot的敬老院管理系统的设计与实现 Java实战项目 附源码+文档+视频讲解
博主介绍：✌从事软件开发10年之余，专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ 🍅文末获取源码联系🍅 👇🏻 精…...
精调llama模型
github地址：https://github.com/facebookresearch/llama-recipes github:https://github.com/facebookresearch/llama import torch from transformers import LlamaForCausalLM, LlamaTokenizer#model_id"./models_hf/7B" # 可以从huggingface上面下载模…...
【C语言】深入理解C语言中的数学运算和类型转换
文章目录 引言取负运算的奥秘源码探索分析与解读 浮点数运算的精细差异源码分析精度损失与隐式类型转换 精度和除零运算探究float类型和double类型的精度各是多少（即十进制有效位的位数）？在你的机器上，“负数开方”是如何处理的&a…...
基于javaweb的宠物服务商城系统设计与开发
摘 要 最近几年以来，宠物在人们的日常生活中所占的地位越来越重要了，它们不仅仅是我们的朋友，也成为了我们家庭中的一份子。21世纪，信息技术飞速发展，计算机行业日新月异，极大地带动了信息的流动ÿ…...
LeetCode-470. 用 Rand7() 实现 Rand10()【数学 拒绝采样 概率与统计 随机化】
LeetCode-470. 用 Rand7 实现 Rand10【数学 拒绝采样 概率与统计 随机化】 题目描述：解题思路一：首先说一个结论就是(rand_X() - 1) Y rand_Y() > [1,X*Y]，即可以等概率的生成[1, X * Y]范围的随机数，其实就像军训的时候报数…...
通达信指标公式19：龙虎榜股票池——主力控盘度的计算方法
0.小红牛本指标，选股的思路说明：控盘度，又称主力控盘，是指主力控制了某只股票的大部分流通股，从而控制了股票的价格。主力控盘的目的通常是为了获取更多的收益，通过控制股票价格来实现其策略。所以首要分析…...
手搓图片滑动验证码_JavaScript进阶
手搓图片滑动验证码 背景代码效果图展示网站 背景 在做前端项目开发的时候，少不了登录注册部分，既然有登录注册就少不了机器人验证，验证的方法有很多种，比如短信验证码、邮箱验证码、图片滑动、图片验证码等。 由于鄙人在开发中…...
Linux服务器超级实用的脚本
1.使用INOTIFY+RSYNC自动实时同步数据 代码执行： bash inotify_rsyncs.sh ：cat inotify_rsyncs.sh 脚本内容如下： #!bing/bash # Author: reyn #检测/data路径下的文件变化，排除Temp目录 INOTIFY_CMD="inotifywait -mrq -e modify,create,move,delete /data/ --exc…...
IntelliJ IDEA安装使用教程#intellij idea
做为基础开发软件，idea、pycharm、phpstorm是高级企业级开发中常用的图形化工具。 安装非常简单：去官网下载即可，有社区版本、有企业版本： IntelliJ IDEA – 领先的 Java 和 Kotlin IDE 因版权问题：这里不方面多讲。…...
【组合数学】容斥鸽巢原理
目录 1. 容斥原理容斥原理三种形式 2. 容斥原理应用有限重复数的多重集合的 r 组合数错排问题 3. 鸽巢原理4. Ramsey 定理 1. 容斥原理 容斥原理提供了一种通过计算每个单独集合的大小，然后修正重复计数的方法，从而得到多个集合并集大小的计算方法。它通…...
视频后期特效处理软件 Motion 5 mac中文版
Motion mac是一款运动图形和视频合成软件，适用于Mac OS平台。 Motion mac软件特点 - 精美的效果：Motion提供了多种高质量的运动图形和视频效果，例如3D效果、烟雾效果、粒子效果等，方便用户制作出丰富多彩的视频和动画。 - 高效的工…...
【智能家居】一、工厂模式实现继电器灯控制
用户手册对应的I/O 工厂模式实现继电器灯控制 代码段 controlDevice.h（设备设备）main.c（主函数）bathroomLight.c（浴室灯）bedroomLight.c（卧室灯）restaurantLight.c（餐厅…...
第三节：提供者、消费者、Eureka
一、 提供者 消费者（就是个说法、定义，以防别人叭叭时听不懂） 服务提供者：业务中被其他微服务调用的服务。（提供接口给其他服务调用）服务消费者：业务中调用其他微服务的服务。（调用…...
Leetcode刷题详解——等差数列划分
1. 题目链接：413. 等差数列划分 2. 题目描述： 如果一个数列 至少有三个元素 ，并且任意两个相邻元素之差相同，则称该数列为等差数列。 例如，[1,3,5,7,9]、[7,7,7,7] 和 [3,-1,-5,-9] 都是等差数列。 给你一个整数数组 …...
导出主机上所有docker 镜像并导入到其它主机
保存镜像列表到文件 docker images --format “{{.Repository}}:{{.Tag}}” > image_list.txt 导出列表中所有镜像到tar文件 cat image_list.txt | xargs -L 1 docker save -o all_images.tar 导入tar包中所有镜像 docker load -i all_images.tar...
HTML5+CSS3+JS小实例：焦点图波浪切换动画特效
实例：焦点图波浪切换动画特效 技术栈：HTML+CSS+JS 字体图标库：Font Awesome 效果： 源码： 【HTML】 <!DOCTYPE html> <html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"><meta name=&…...
Mac电脑如何安装git
一、简介 在Mac上安装Git之前，可以先使用git --version来查看一下是否安装了Git，因为Mac系统可能自带了Git，或者在你安装XCode（或者XCode的命令行工具）时，可能已经安装了 Git。 如果Mac还没有安装Git的话&…...
macOS本地调试k8s源码
目录 准备工作创建集群注意点1. kubeconfig未正常加载2. container runtime is not running3. The connection to the server 172.16.190.132:6443 was refused - did you specify the right host or port?4. 集群重置5.加入子节点 代码调试 准备工作 apple m1芯片 安装vmwa…...
JS 实现一键复制文本内容
1、演示： 2、代码 <!DOCTYPE html> <html lang"en"><head><meta charset"UTF-8"><meta name"viewport" content"widthdevice-width, initial-scale1.0"><title>一键复制</title&g…...
【Linux】echo命令使用
echo命令 功能是在显示器上显示一段文字，一般起到一个提示的作用。此外，也可以直接在文件中写入要写的内容。也可以用于脚本编程时显示某一个变量的值，或者直接输出指定的字符串。 著者 由布莱恩福克斯和切特拉米撰写。 语法 echo […...
Appium+python自动化（十六）- ADB命令
简介 Android 调试桥(adb)是多种用途的工具，该工具可以帮助你你管理设备或模拟器 的状态。 adb ( Android Debug Bridge)是一个通用命令行工具，其允许您与模拟器实例或连接的 Android 设备进行通信。它可为各种设备操作提供便利，如安装和调试…...
React Native 开发环境搭建（全平台详解）
React Native 开发环境搭建（全平台详解） 在开始使用 React Native 开发移动应用之前，正确设置开发环境是至关重要的一步。本文将为你提供一份全面的指南，涵盖 macOS 和 Windows 平台的配置步骤，如何在 Android 和 iOS…...
2025年能源电力系统与流体力学国际会议 (EPSFD 2025)
2025年能源电力系统与流体力学国际会议（EPSFD 2025）将于本年度在美丽的杭州盛大召开。作为全球能源、电力系统以及流体力学领域的顶级盛会，EPSFD 2025旨在为来自世界各地的科学家、工程师和研究人员提供一个展示最新研究成果、分享实践经验及…...
Mybatis逆向工程，动态创建实体类、条件扩展类、Mapper接口、Mapper.xml映射文件
今天呢，博主的学习进度也是步入了Java Mybatis 框架，目前正在逐步杨帆旗航。 那么接下来就给大家出一期有关 Mybatis 逆向工程的教学，希望能对大家有所帮助，也特别欢迎大家指点不足之处，小生很乐意接受正确的建议&…...
全面解析各类VPN技术：GRE、IPsec、L2TP、SSL与MPLS VPN对比
目录 引言 VPN技术概述 GRE VPN 3.1 GRE封装结构 3.2 GRE的应用场景 GRE over IPsec 4.1 GRE over IPsec封装结构 4.2 为什么使用GRE over IPsec？ IPsec VPN 5.1 IPsec传输模式（Transport Mode） 5.2 IPsec隧道模式（Tunne…...
如何理解 IP 数据报中的 TTL？
目录 前言理解 前言 面试灵魂一问：说说对 IP 数据报中 TTL 的理解？我们都知道，IP 数据报由首部和数据两部分组成，首部又分为两部分：固定部分和可变部分，共占 20 字节，而即将讨论的 TTL 就位于首…...
C# 求圆面积的程序（Program to find area of a circle）
给定半径r，求圆的面积。圆的面积应精确到小数点后5位。 例子： 输入：r 5 输出：78.53982 解释：由于面积 PI * r * r 3.14159265358979323846 * 5 * 5 78.53982，因为我们只保留小数点后 5 位数字。 输…...
Java线上CPU飙高问题排查全指南
一、引言 在Java应用的线上运行环境中，CPU飙高是一个常见且棘手的性能问题。当系统出现CPU飙高时，通常会导致应用响应缓慢，甚至服务不可用，严重影响用户体验和业务运行。因此，掌握一套科学有效的CPU飙高问题排查方法&…...
深度学习习题2
1.如果增加神经网络的宽度，精确度会增加到一个特定阈值后，便开始降低。造成这一现象的可能原因是什么？ A、即使增加卷积核的数量，只有少部分的核会被用作预测 B、当卷积核数量增加时，神经网络的预测能力会降低 C、当卷…...
JVM 内存结构 详解
内存结构 运行时数据区： Java虚拟机在运行Java程序过程中管理的内存区域。 程序计数器： 线程私有，程序控制流的指示器，分支、循环、跳转、异常处理、线程恢复等基础功能都依赖这个计数器完成。 每个线程都有一个程序计数…...