开源项目-HIS医院管理系统

一.项目简介

基本介绍

HIS系统（Hospital Information System，医院信息系统）是一种集成化的信息管理平台，旨在通过计算机技术和网络通信手段，对医院各部门的医疗、管理、财务等信息进行全面的采集、存储、处理和共享，以提高医院运营效率、优化医疗服务质量、降低管理成本。HIS系统通常涵盖门诊、住院、药房、检验、影像、财务等多个模块，支持患者挂号、医嘱执行、病历管理、药品库存管理、费用结算等功能，实现医院内部信息的无缝连接与协同工作。通过HIS系统，医院能够实现医疗流程的标准化、数据的实时监控与分析，为决策提供科学依据，同时提升患者就医体验。HIS系统是现代医院数字化、智能化管理的核心工具，也是医疗信息化建设的重要组成部分。

项目环境

工具	版本号
jdk	1.8
mysql	8.0
maven	3.6
node	16.20

技术栈 ：SpringBoot + MySQL + MyBatis + Layui

二.功能介绍

• 后台首页（就诊/住院人数、排班信息）
• 门诊管理（用户挂号、处方/项目划价、项目缴费/检查、门诊患者库）
• 住院管理（入院登记、缴费管理、药品记账、项目记账、出院结算）
• 系统管理（菜单管理、角色管理、医院基本信息维护）
• 统计管理（门诊月度/年度统计、住院月度/年度统计、门诊当天统计）
• 数据中心（科室中心、医生列表、药品产地、项目大类、挂号类型、仓库、药品分类）
• 排班管理（医生排班）
• 仓库管理（入库单、库存查询、出库单、库存不足、过期提醒、药品回收、操作记录）
• 药房管理（药房详情、门诊取药、住院取药）

三.系统演示

四.安装教程

1.克隆代码到本地

原作者代码仓库地址：https://github.com/lyd-520/hisSaas

Gitee备份仓库地址：https://gitee.com/JasonsGong/hisSaas

git clone https://gitee.com/JasonsGong/hisSaas.git

2.创建数据库

数据库文件在项目doc/sql目录下

-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: 192.168.200.101    Database: his
-- ------------------------------------------------------
-- Server version	8.4.3

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `area` (
  `areaId` int NOT NULL AUTO_INCREMENT,
  `areaName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`areaId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area`
--

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;
INSERT INTO `area` (`areaId`, `areaName`) VALUES (4,'河南省a有限公司 ');
/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ban`
--

DROP TABLE IF EXISTS `ban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ban` (
  `bid` int NOT NULL AUTO_INCREMENT,
  `bname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`bid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ban`
--

LOCK TABLES `ban` WRITE;
/*!40000 ALTER TABLE `ban` DISABLE KEYS */;
INSERT INTO `ban` (`bid`, `bname`) VALUES (1,'有班'),(2,'无班');
/*!40000 ALTER TABLE `ban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `baoque`
--

DROP TABLE IF EXISTS `baoque`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `baoque` (
  `baoqueid` int NOT NULL AUTO_INCREMENT,
  `baoqueName` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `baoqueNum` int DEFAULT NULL,
  PRIMARY KEY (`baoqueid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `baoque`
--

LOCK TABLES `baoque` WRITE;
/*!40000 ALTER TABLE `baoque` DISABLE KEYS */;
/*!40000 ALTER TABLE `baoque` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bed`
--

DROP TABLE IF EXISTS `bed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bed` (
  `bedId` int NOT NULL AUTO_INCREMENT,
  `bedname` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `departmentId` int NOT NULL,
  `state` int DEFAULT NULL,
  `Price` double DEFAULT NULL,
  PRIMARY KEY (`bedId`) USING BTREE,
  KEY `fk_bedDepartmentid` (`departmentId`) USING BTREE,
  CONSTRAINT `fk_bedDepartmentid` FOREIGN KEY (`departmentId`) REFERENCES `departments` (`departmentId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bed`
--

LOCK TABLES `bed` WRITE;
/*!40000 ALTER TABLE `bed` DISABLE KEYS */;
INSERT INTO `bed` (`bedId`, `bedname`, `departmentId`, `state`, `Price`) VALUES (8,'外科1',8,0,10),(9,'内科一',7,0,10),(10,'耳鼻喉科1',9,0,10),(11,'儿科1',10,0,10);
/*!40000 ALTER TABLE `bed` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `caigou`
--

DROP TABLE IF EXISTS `caigou`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `caigou` (
  `caigouid` int NOT NULL AUTO_INCREMENT,
  `caigouname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gonghuoshang` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `danwei` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `candi` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `leixing` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `shuliang` int DEFAULT NULL,
  PRIMARY KEY (`caigouid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `caigou`
--

LOCK TABLES `caigou` WRITE;
/*!40000 ALTER TABLE `caigou` DISABLE KEYS */;
INSERT INTO `caigou` (`caigouid`, `caigouname`, `gonghuoshang`, `danwei`, `candi`, `leixing`, `shuliang`) VALUES (16,'阿莫西林','春天大药房 ','盒','河南省a有限公司 ','西药',20);
/*!40000 ALTER TABLE `caigou` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cashier`
--

DROP TABLE IF EXISTS `cashier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cashier` (
  `cashier` int NOT NULL AUTO_INCREMENT,
  `reportId` int NOT NULL,
  `durgname` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `durgnum` int NOT NULL,
  `repiceprice` double NOT NULL,
  `repicetotal` double NOT NULL,
  `state` int DEFAULT NULL,
  `ctime` date DEFAULT NULL,
  `ostate` int DEFAULT NULL,
  `jie` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `mstate` int DEFAULT NULL,
  PRIMARY KEY (`cashier`) USING BTREE,
  KEY `fk_reportId` (`reportId`) USING BTREE,
  CONSTRAINT `fk_reportId` FOREIGN KEY (`reportId`) REFERENCES `report` (`reportId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cashier`
--

LOCK TABLES `cashier` WRITE;
/*!40000 ALTER TABLE `cashier` DISABLE KEYS */;
INSERT INTO `cashier` (`cashier`, `reportId`, `durgname`, `durgnum`, `repiceprice`, `repicetotal`, `state`, `ctime`, `ostate`, `jie`, `mstate`) VALUES (34,28,'板蓝根',1,30,30,0,'2019-11-21',NULL,NULL,NULL),(35,28,'阿莫西林',1,30,30,0,'2019-11-21',NULL,NULL,NULL),(36,28,'挂号费',1,30,30,2,'2019-11-21',NULL,NULL,NULL),(37,29,'ct',1,100,100,1,'2019-11-21',1,'脑部肿瘤',1),(38,29,'打针',1,20,20,1,'2019-11-21',0,NULL,1),(39,30,'阿莫西林',1,30,30,0,'2019-11-21',NULL,NULL,NULL),(40,30,'ct',1,100,100,1,'2019-11-21',1,'良好',1),(41,30,'挂号费',1,30,30,2,'2019-11-21',NULL,NULL,NULL),(43,31,'ct',1,100,100,1,'2019-11-26',1,'良好',1),(44,31,'打针',1,20,20,1,'2019-11-26',0,NULL,1),(45,33,'板蓝根',2,30,60,0,'2022-11-17',NULL,NULL,NULL),(46,33,'阿莫西林',3,30,90,0,'2022-11-17',NULL,NULL,NULL),(47,33,'打针',1,20,20,1,'2022-11-17',0,NULL,1),(48,33,'ct',1,100,100,1,'2022-11-17',1,'感冒，流鼻涕',1),(49,33,'挂号费',1,20,20,2,'2022-11-17',NULL,NULL,NULL);
/*!40000 ALTER TABLE `cashier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `checkup`
--

DROP TABLE IF EXISTS `checkup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `checkup` (
  `cid` int NOT NULL AUTO_INCREMENT,
  `registerid` int DEFAULT NULL,
  `content` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `ctime` datetime DEFAULT NULL,
  PRIMARY KEY (`cid`) USING BTREE,
  KEY `fk_rid` (`registerid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `checkup`
--

LOCK TABLES `checkup` WRITE;
/*!40000 ALTER TABLE `checkup` DISABLE KEYS */;
/*!40000 ALTER TABLE `checkup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `departments` (
  `departmentId` int NOT NULL AUTO_INCREMENT,
  `department` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`departmentId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departments`
--

LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` (`departmentId`, `department`) VALUES (7,'内科'),(8,'外科'),(9,'耳鼻喉科'),(10,'儿科');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `doctor`
--

DROP TABLE IF EXISTS `doctor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `doctor` (
  `doctorId` int NOT NULL AUTO_INCREMENT,
  `doctorName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `departmentId` int NOT NULL,
  `registeredId` int NOT NULL,
  `dstate` int DEFAULT NULL,
  `amStartTime` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '8:00',
  `amEndTime` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '12:00',
  `pmStartTime` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '14:00',
  `pmEndTime` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '18:00',
  PRIMARY KEY (`doctorId`) USING BTREE,
  KEY `fk_department` (`departmentId`) USING BTREE,
  KEY `fk_registeredtype` (`registeredId`) USING BTREE,
  CONSTRAINT `fk_department` FOREIGN KEY (`departmentId`) REFERENCES `departments` (`departmentId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_registeredtype` FOREIGN KEY (`registeredId`) REFERENCES `registeredtype` (`registeredId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `doctor`
--

LOCK TABLES `doctor` WRITE;
/*!40000 ALTER TABLE `doctor` DISABLE KEYS */;
INSERT INTO `doctor` (`doctorId`, `doctorName`, `departmentId`, `registeredId`, `dstate`, `amStartTime`, `amEndTime`, `pmStartTime`, `pmEndTime`) VALUES (13,'华佗',7,5,0,'8:00','12:00','14:00','18:00'),(14,'扁鹊',7,6,0,'8:00','12:00','14:00','18:00'),(15,'张春明',7,5,1,'8:00','12:00','14:00','18:00'),(16,'王二',8,5,1,'8:00','12:00','14:00','18:00'),(17,'孙思邈',9,5,0,'8:00','12:00','14:00','18:00'),(18,'张仲景',9,6,0,'8:00','12:00','14:00','18:00'),(19,'钱乙',10,5,0,'8:00','12:00','14:00','18:00'),(20,'宋慈',10,6,0,'8:00','12:00','14:00','18:00'),(21,'李时珍',9,5,1,'8:00','12:00','14:00','18:00'),(22,'吴谦',9,6,1,'8:00','12:00','14:00','18:00'),(23,'葛洪',7,6,0,'8:00','12:00','14:00','18:00');
/*!40000 ALTER TABLE `doctor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `drugdictionary`
--

DROP TABLE IF EXISTS `drugdictionary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drugdictionary` (
  `drugId` int NOT NULL AUTO_INCREMENT,
  `drugName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `unitId` int NOT NULL,
  `sellingPrice` double NOT NULL,
  `areaId` int NOT NULL,
  `typeId` int NOT NULL,
  PRIMARY KEY (`drugId`) USING BTREE,
  KEY `fk_unitid` (`unitId`) USING BTREE,
  KEY `fk_areaId` (`areaId`) USING BTREE,
  KEY `fk_typeId` (`typeId`) USING BTREE,
  CONSTRAINT `fk_areaId` FOREIGN KEY (`areaId`) REFERENCES `area` (`areaId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_typeId` FOREIGN KEY (`typeId`) REFERENCES `type` (`typeId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_unitid` FOREIGN KEY (`unitId`) REFERENCES `unit` (`unitId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `drugdictionary`
--

LOCK TABLES `drugdictionary` WRITE;
/*!40000 ALTER TABLE `drugdictionary` DISABLE KEYS */;
INSERT INTO `drugdictionary` (`drugId`, `drugName`, `unitId`, `sellingPrice`, `areaId`, `typeId`) VALUES (9,'阿莫西林',7,30,4,5),(10,'板蓝根',9,30,4,5);
/*!40000 ALTER TABLE `drugdictionary` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `drugstore`
--

DROP TABLE IF EXISTS `drugstore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `drugstore` (
  `rugstoreId` int NOT NULL AUTO_INCREMENT,
  `drugstoreName` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `supplierId` int DEFAULT NULL,
  `skullId` int DEFAULT NULL,
  `warehouseId` int DEFAULT NULL,
  `unit` int NOT NULL,
  `tradePrice` double NOT NULL,
  `sellingPrice` double NOT NULL,
  `area` int NOT NULL,
  `type` int NOT NULL,
  `produceDate` date NOT NULL,
  `validDate` date NOT NULL,
  `drugstorenum` int NOT NULL,
  `batch` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`rugstoreId`) USING BTREE,
  KEY `fk_supplierId` (`supplierId`) USING BTREE,
  KEY `fk_skullId` (`skullId`) USING BTREE,
  KEY `fk_warehouseId` (`warehouseId`) USING BTREE,
  KEY `fk_dgarea` (`area`) USING BTREE,
  KEY `fk_dgunit` (`unit`) USING BTREE,
  KEY `fk_dtype` (`type`) USING BTREE,
  CONSTRAINT `fk_dgarea` FOREIGN KEY (`area`) REFERENCES `area` (`areaId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_dgunit` FOREIGN KEY (`unit`) REFERENCES `unit` (`unitId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_dtype` FOREIGN KEY (`type`) REFERENCES `type` (`typeId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_skullId` FOREIGN KEY (`skullId`) REFERENCES `skull` (`skullId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_supplierId` FOREIGN KEY (`supplierId`) REFERENCES `upplier` (`supplierId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_warehouseId` FOREIGN KEY (`warehouseId`) REFERENCES `warehuose` (`warehouseId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `drugstore`
--

LOCK TABLES `drugstore` WRITE;
/*!40000 ALTER TABLE `drugstore` DISABLE KEYS */;
INSERT INTO `drugstore` (`rugstoreId`, `drugstoreName`, `supplierId`, `skullId`, `warehouseId`, `unit`, `tradePrice`, `sellingPrice`, `area`, `type`, `produceDate`, `validDate`, `drugstorenum`, `batch`) VALUES (15,'阿莫西林',5,4,2,7,12,30,4,5,'2022-10-12','2022-12-15',18,'20221117'),(37,'板蓝根',5,4,2,9,29,30,4,5,'2022-11-09','2022-11-26',100,'20221117');
/*!40000 ALTER TABLE `drugstore` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `home`
--

DROP TABLE IF EXISTS `home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `home` (
  `homeId` int NOT NULL AUTO_INCREMENT,
  `homeName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sex` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `carId` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`homeId`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `home`
--

LOCK TABLES `home` WRITE;
/*!40000 ALTER TABLE `home` DISABLE KEYS */;
INSERT INTO `home` (`homeId`, `homeName`, `sex`, `age`, `carId`, `phone`) VALUES (73,'敲门','男',19,NULL,NULL),(74,'魏坚','男',19,'412823199912242414','17634525258');
/*!40000 ALTER TABLE `home` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hospitalmeta`
--

DROP TABLE IF EXISTS `hospitalmeta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hospitalmeta` (
  `hospitalId` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `hospitalName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '医院名',
  `hospitalAddress` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '医院地址',
  `mysqlUrl` varchar(127) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'mysql地址',
  `mysqlSchema` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'mysql库名',
  `mysqlUsername` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'mysql用户名',
  `mysqlPassword` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'mysql密码',
  `mysqlStatus` int DEFAULT NULL COMMENT '0-未建库;1-已建库',
  PRIMARY KEY (`hospitalId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hospitalmeta`
--

LOCK TABLES `hospitalmeta` WRITE;
/*!40000 ALTER TABLE `hospitalmeta` DISABLE KEYS */;
/*!40000 ALTER TABLE `hospitalmeta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hospitalprice`
--

DROP TABLE IF EXISTS `hospitalprice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hospitalprice` (
  `hospitalpriceid` int NOT NULL AUTO_INCREMENT,
  `registerId` int NOT NULL,
  `durgname` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `durgnum` int NOT NULL,
  `repiceprice` double NOT NULL,
  `repicetotal` double NOT NULL,
  `htime` datetime DEFAULT NULL,
  `state` int DEFAULT NULL,
  PRIMARY KEY (`hospitalpriceid`) USING BTREE,
  KEY `fk_registerId` (`registerId`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hospitalprice`
--

LOCK TABLES `hospitalprice` WRITE;
/*!40000 ALTER TABLE `hospitalprice` DISABLE KEYS */;
INSERT INTO `hospitalprice` (`hospitalpriceid`, `registerId`, `durgname`, `durgnum`, `repiceprice`, `repicetotal`, `htime`, `state`) VALUES (104,12,'开颅手术',1,500,500,'2019-11-21 15:12:26',1),(105,12,'阿莫西林',2,30,60,'2019-11-21 15:13:47',2),(106,13,'板蓝根',1,30,30,'2022-11-17 17:21:51',2),(107,13,'阿莫西林',2,30,60,'2022-11-17 17:21:51',2),(108,13,'开颅手术',1,500,500,'2022-11-17 17:13:50',1);
/*!40000 ALTER TABLE `hospitalprice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `huishou`
--

DROP TABLE IF EXISTS `huishou`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `huishou` (
  `huishouid` int NOT NULL AUTO_INCREMENT,
  `huishouname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `huishounumber` int NOT NULL,
  `huishoupihao` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `jbr` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `beizhu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`huishouid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `huishou`
--

LOCK TABLES `huishou` WRITE;
/*!40000 ALTER TABLE `huishou` DISABLE KEYS */;
/*!40000 ALTER TABLE `huishou` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inhospitaltype`
--

DROP TABLE IF EXISTS `inhospitaltype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inhospitaltype` (
  `inhospitalId` int NOT NULL AUTO_INCREMENT,
  `projectName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `unit` int NOT NULL,
  `price` double NOT NULL,
  `bigprojectId` int NOT NULL,
  PRIMARY KEY (`inhospitalId`) USING BTREE,
  KEY `fk_inhospitaltype` (`bigprojectId`) USING BTREE,
  KEY `fk_inhunit` (`unit`) USING BTREE,
  CONSTRAINT `fk_inhospitaltype` FOREIGN KEY (`bigprojectId`) REFERENCES `projecttype` (`projectId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_inhunit` FOREIGN KEY (`unit`) REFERENCES `unit` (`unitId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inhospitaltype`
--

LOCK TABLES `inhospitaltype` WRITE;
/*!40000 ALTER TABLE `inhospitaltype` DISABLE KEYS */;
/*!40000 ALTER TABLE `inhospitaltype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inoutpatienttype`
--

DROP TABLE IF EXISTS `inoutpatienttype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inoutpatienttype` (
  `inoutpatientId` int NOT NULL AUTO_INCREMENT,
  `projectName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `unit` int NOT NULL,
  `bigproJectId` int NOT NULL,
  `price` double NOT NULL,
  PRIMARY KEY (`inoutpatientId`) USING BTREE,
  KEY `fk_inoutpatienttype` (`bigproJectId`) USING BTREE,
  KEY `fk_intunit` (`unit`) USING BTREE,
  CONSTRAINT `fk_inoutpatienttype` FOREIGN KEY (`bigproJectId`) REFERENCES `projecttype` (`projectId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_intunit` FOREIGN KEY (`unit`) REFERENCES `unit` (`unitId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inoutpatienttype`
--

LOCK TABLES `inoutpatienttype` WRITE;
/*!40000 ALTER TABLE `inoutpatienttype` DISABLE KEYS */;
INSERT INTO `inoutpatienttype` (`inoutpatientId`, `projectName`, `unit`, `bigproJectId`, `price`) VALUES (5,'开颅手术',8,1,500);
/*!40000 ALTER TABLE `inoutpatienttype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jilu`
--

DROP TABLE IF EXISTS `jilu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jilu` (
  `jiluid` int NOT NULL AUTO_INCREMENT,
  `jiluname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `jilutime` datetime NOT NULL,
  `jilutype` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `jilupeople` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `jilunumber` int DEFAULT NULL,
  `jilupihao` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`jiluid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=242 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jilu`
--

LOCK TABLES `jilu` WRITE;
/*!40000 ALTER TABLE `jilu` DISABLE KEYS */;
INSERT INTO `jilu` (`jiluid`, `jiluname`, `jilutime`, `jilutype`, `jilupeople`, `jilunumber`, `jilupihao`) VALUES (187,'板蓝根','2019-11-21 14:58:00','常规入库','门诊',100,'20191121'),(188,'阿莫西林','2019-11-21 14:58:46','常规入库','门诊',30,'20191121'),(189,'阿莫西林','2019-11-21 14:59:42','正常出库','门诊',20,'20191121'),(190,'板蓝根','2019-11-21 14:59:49','正常出库','门诊',50,'20191121'),(191,'板蓝根','2019-11-21 15:17:48','紧急补给药房','门诊',10,'20191121'),(192,'阿莫西林','2019-11-21 15:24:55','正常出库','门诊',10,'20191121'),(193,'板蓝根','2022-11-17 17:34:51','常规入库','超级管理员',25,'20221117'),(194,'阿莫西林','2022-11-17 17:36:38','常规入库','超级管理员',20,'20221117'),(195,'阿莫西林','2022-11-17 17:36:38','常规入库','超级管理员',20,'20221117'),(196,'阿莫西林','2022-11-17 17:36:38','常规入库','超级管理员',20,'20221117'),(197,'阿莫西林','2022-11-17 17:36:38','常规入库','超级管理员',20,'20221117'),(198,'阿莫西林','2022-11-17 17:36:38','常规入库','超级管理员',20,'20221117'),(199,'阿莫西林','2022-11-17 17:36:38','常规入库','超级管理员',20,'20221117'),(200,'阿莫西林','2022-11-17 17:37:15','常规入库','超级管理员',32,'20221117'),(201,'阿莫西林','2022-11-17 17:37:15','常规入库','超级管理员',32,'20221117'),(202,'阿莫西林','2022-11-17 17:37:15','常规入库','超级管理员',32,'20221117'),(203,'阿莫西林','2022-11-17 17:37:15','常规入库','超级管理员',32,'20221117'),(204,'阿莫西林','2022-11-17 17:37:15','常规入库','超级管理员',32,'20221117'),(205,'阿莫西林','2022-11-17 17:37:15','常规入库','超级管理员',32,'20221117'),(206,'板蓝根','2022-11-17 17:37:50','常规入库','超级管理员',22,'20221117'),(207,'板蓝根','2022-11-17 17:37:50','常规入库','超级管理员',22,'20221117'),(208,'板蓝根','2022-11-17 17:37:50','常规入库','超级管理员',22,'20221117'),(209,'板蓝根','2022-11-17 17:37:50','常规入库','超级管理员',22,'20221117'),(210,'板蓝根','2022-11-17 17:37:50','常规入库','超级管理员',22,'20221117'),(211,'板蓝根','2022-11-17 17:37:50','常规入库','超级管理员',22,'20221117'),(212,'阿莫西林','2022-11-17 17:38:23','常规入库','超级管理员',12,'20221117'),(213,'阿莫西林','2022-11-17 17:38:23','常规入库','超级管理员',12,'20221117'),(214,'阿莫西林','2022-11-17 17:38:23','常规入库','超级管理员',12,'20221117'),(215,'阿莫西林','2022-11-17 17:38:23','常规入库','超级管理员',12,'20221117'),(216,'阿莫西林','2022-11-17 17:38:23','常规入库','超级管理员',12,'20221117'),(217,'阿莫西林','2022-11-17 17:38:23','常规入库','超级管理员',12,'20221117'),(218,'阿莫西林','2022-11-17 17:38:24','常规入库','超级管理员',12,'20221117'),(219,'阿莫西林','2022-11-17 17:38:24','常规入库','超级管理员',12,'20221117'),(220,'阿莫西林','2022-11-17 17:38:24','常规入库','超级管理员',12,'20221117'),(221,'阿莫西林','2022-11-17 17:38:24','常规入库','超级管理员',12,'20221117'),(222,'板蓝根','2022-11-17 17:38:57','常规入库','超级管理员',22,'20221117'),(223,'板蓝根','2022-11-17 17:38:57','常规入库','超级管理员',22,'20221117'),(224,'板蓝根','2022-11-17 17:38:57','常规入库','超级管理员',22,'20221117'),(225,'板蓝根','2022-11-17 17:38:57','常规入库','超级管理员',22,'20221117'),(226,'板蓝根','2022-11-17 17:38:58','常规入库','超级管理员',22,'20221117'),(227,'板蓝根','2022-11-17 17:38:58','常规入库','超级管理员',22,'20221117'),(228,'板蓝根','2022-11-17 17:38:58','常规入库','超级管理员',22,'20221117'),(229,'板蓝根','2022-11-17 17:38:58','常规入库','超级管理员',22,'20221117'),(230,'板蓝根','2022-11-17 17:38:58','常规入库','超级管理员',22,'20221117'),(231,'板蓝根','2022-11-17 17:38:58','常规入库','超级管理员',22,'20221117'),(232,'阿莫西林','2022-11-17 19:13:16','常规入库','超级管理员',28,'20221117'),(233,'阿莫西林','2022-11-17 19:13:17','常规入库','超级管理员',28,'20221117'),(234,'阿莫西林','2022-11-17 19:14:07','正常出库','超级管理员',10,'20221117'),(235,'阿莫西林','2022-11-17 19:21:13','处理回收药品','超级管理员',17,'20191121'),(236,'板蓝根','2022-11-17 19:21:55','正常出库','超级管理员',10,'20221117'),(237,'板蓝根','2022-11-17 19:22:28','销毁过期药品','超级管理员',40,'20191121'),(238,'阿莫西林','2022-11-17 19:23:13','正常出库','超级管理员',400,'20221117'),(239,'板蓝根','2022-11-17 19:29:34','销毁过期药品','超级管理员',423,'20221117'),(240,'板蓝根','2022-11-17 19:44:34','常规入库','超级管理员',100,'20221117'),(241,'阿莫西林','2022-11-17 19:49:24','处理回收药品','超级管理员',414,'20191121');
/*!40000 ALTER TABLE `jilu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moneytype`
--

DROP TABLE IF EXISTS `moneytype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moneytype` (
  `MoneyId` int NOT NULL AUTO_INCREMENT,
  `Moneytype` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `Percent` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`MoneyId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moneytype`
--

LOCK TABLES `moneytype` WRITE;
/*!40000 ALTER TABLE `moneytype` DISABLE KEYS */;
INSERT INTO `moneytype` (`MoneyId`, `Moneytype`, `Percent`) VALUES (10,'无','0%'),(11,'城镇社保','30%'),(12,'农村医疗合作社','35%');
/*!40000 ALTER TABLE `moneytype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outpatienttype`
--

DROP TABLE IF EXISTS `outpatienttype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outpatienttype` (
  `outpatientId` int NOT NULL AUTO_INCREMENT,
  `projectName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `unit` int NOT NULL,
  `bigprojectId` int NOT NULL,
  `price` double NOT NULL,
  `ostate` int DEFAULT NULL,
  PRIMARY KEY (`outpatientId`) USING BTREE,
  KEY `fk_outpatienttype` (`bigprojectId`) USING BTREE,
  KEY `fk_outunit` (`unit`) USING BTREE,
  CONSTRAINT `fk_outpatienttype` FOREIGN KEY (`bigprojectId`) REFERENCES `projecttype` (`projectId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_outunit` FOREIGN KEY (`unit`) REFERENCES `unit` (`unitId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outpatienttype`
--

LOCK TABLES `outpatienttype` WRITE;
/*!40000 ALTER TABLE `outpatienttype` DISABLE KEYS */;
INSERT INTO `outpatienttype` (`outpatientId`, `projectName`, `unit`, `bigprojectId`, `price`, `ostate`) VALUES (7,'ct',8,2,100,1),(8,'打针',8,2,20,0);
/*!40000 ALTER TABLE `outpatienttype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paiban`
--

DROP TABLE IF EXISTS `paiban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `paiban` (
  `paiId` int NOT NULL AUTO_INCREMENT,
  `one` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `two` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `three` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `four` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `five` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `six` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `seven` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '无班',
  `doctorId` int DEFAULT NULL,
  PRIMARY KEY (`paiId`) USING BTREE,
  KEY `fk_paiId` (`doctorId`) USING BTREE,
  CONSTRAINT `fk_paiId` FOREIGN KEY (`doctorId`) REFERENCES `doctor` (`doctorId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paiban`
--

LOCK TABLES `paiban` WRITE;
/*!40000 ALTER TABLE `paiban` DISABLE KEYS */;
INSERT INTO `paiban` (`paiId`, `one`, `two`, `three`, `four`, `five`, `six`, `seven`, `doctorId`) VALUES (12,'有班','有班','有班','有班','有班','无班','无班',16),(13,'无班','无班','有班','有班','有班','有班','有班',15),(14,'有班','有班','无班','无班','有班','有班','有班',14),(15,'有班','有班','有班','有班','无班','无班','有班',13);
/*!40000 ALTER TABLE `paiban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pay`
--

DROP TABLE IF EXISTS `pay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pay` (
  `payid` int NOT NULL AUTO_INCREMENT,
  `registerid` int DEFAULT NULL,
  `money` double DEFAULT NULL,
  `payDate` datetime DEFAULT NULL,
  PRIMARY KEY (`payid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pay`
--

LOCK TABLES `pay` WRITE;
/*!40000 ALTER TABLE `pay` DISABLE KEYS */;
INSERT INTO `pay` (`payid`, `registerid`, `money`, `payDate`) VALUES (9,12,10,'2019-11-21 15:13:09'),(10,13,10,'2019-11-26 09:44:56'),(11,13,200,'2022-11-17 17:13:29');
/*!40000 ALTER TABLE `pay` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pharmacy`
--

DROP TABLE IF EXISTS `pharmacy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pharmacy` (
  `pharmacyId` int NOT NULL AUTO_INCREMENT,
  `pharmacyName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `drugstoreId` int DEFAULT NULL,
  `skullId` int DEFAULT NULL,
  `warehouseId` int DEFAULT NULL,
  `unit` int NOT NULL,
  `sellingPrice` double NOT NULL,
  `area` int NOT NULL,
  `type` int NOT NULL,
  `produceDate` date NOT NULL,
  `validDate` date NOT NULL,
  `drugstorenum` int NOT NULL,
  `skullbatch` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`pharmacyId`) USING BTREE,
  KEY `fk_drugstoreIdp` (`drugstoreId`) USING BTREE,
  KEY `fk_skullIdp` (`skullId`) USING BTREE,
  KEY `fk_warehouseIdp` (`warehouseId`) USING BTREE,
  KEY `fk_dgareap` (`area`) USING BTREE,
  KEY `fk_unitp` (`unit`) USING BTREE,
  KEY `fk_typep` (`type`) USING BTREE,
  CONSTRAINT `fk_dgareap` FOREIGN KEY (`area`) REFERENCES `area` (`areaId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_drugstoreIdp` FOREIGN KEY (`drugstoreId`) REFERENCES `drugstore` (`rugstoreId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_skullIdp` FOREIGN KEY (`skullId`) REFERENCES `skull` (`skullId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_typep` FOREIGN KEY (`type`) REFERENCES `type` (`typeId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_unitp` FOREIGN KEY (`unit`) REFERENCES `unit` (`unitId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_warehouseIdp` FOREIGN KEY (`warehouseId`) REFERENCES `warehuose` (`warehouseId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pharmacy`
--

LOCK TABLES `pharmacy` WRITE;
/*!40000 ALTER TABLE `pharmacy` DISABLE KEYS */;
INSERT INTO `pharmacy` (`pharmacyId`, `pharmacyName`, `drugstoreId`, `skullId`, `warehouseId`, `unit`, `sellingPrice`, `area`, `type`, `produceDate`, `validDate`, `drugstorenum`, `skullbatch`) VALUES (11,'板蓝根',NULL,4,2,9,30,4,5,'2019-10-30','2020-01-04',66,'20191121');
/*!40000 ALTER TABLE `pharmacy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projecttype`
--

DROP TABLE IF EXISTS `projecttype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `projecttype` (
  `projectId` int NOT NULL AUTO_INCREMENT,
  `projectName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`projectId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projecttype`
--

LOCK TABLES `projecttype` WRITE;
/*!40000 ALTER TABLE `projecttype` DISABLE KEYS */;
INSERT INTO `projecttype` (`projectId`, `projectName`) VALUES (1,'住院医疗综合服务类'),(2,'门诊医疗综合服务类');
/*!40000 ALTER TABLE `projecttype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `register`
--

DROP TABLE IF EXISTS `register`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `register` (
  `registerid` int NOT NULL AUTO_INCREMENT,
  `userName` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `age` int NOT NULL,
  `sex` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `department` int NOT NULL,
  `doctor` int NOT NULL,
  `diagnose` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `address` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Phone` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Idcard` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `registerDate` datetime DEFAULT NULL,
  `bedNum` int DEFAULT NULL,
  `Operator` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `money` double DEFAULT NULL,
  `state` int DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `price` double unsigned DEFAULT NULL,
  `discount` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `zhuan` datetime DEFAULT NULL,
  PRIMARY KEY (`registerid`) USING BTREE,
  KEY `fk_regdepartment` (`department`) USING BTREE,
  KEY `fk_regdoctor` (`doctor`) USING BTREE,
  CONSTRAINT `fk_regdepartment` FOREIGN KEY (`department`) REFERENCES `departments` (`departmentId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_regdoctor` FOREIGN KEY (`doctor`) REFERENCES `doctor` (`doctorId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `register`
--

LOCK TABLES `register` WRITE;
/*!40000 ALTER TABLE `register` DISABLE KEYS */;
INSERT INTO `register` (`registerid`, `userName`, `age`, `sex`, `department`, `doctor`, `diagnose`, `address`, `Phone`, `Idcard`, `registerDate`, `bedNum`, `Operator`, `money`, `state`, `endDate`, `price`, `discount`, `zhuan`) VALUES (12,'李福州',20,'男',7,15,'脑部肿瘤','河南','15565792390','412827199605062586','2019-11-21 15:11:17',9,'门诊',10010,1,'2019-11-21 15:14:05',392,'30%',NULL),(13,'song',12,'男',7,15,'良好','河南','13271678052','412702199902080557','2019-11-26 09:39:50',9,'超级管理员',1210,1,'2022-11-17 17:22:26',7449,'35%',NULL);
/*!40000 ALTER TABLE `register` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `registeredtype`
--

DROP TABLE IF EXISTS `registeredtype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `registeredtype` (
  `registeredId` int NOT NULL AUTO_INCREMENT,
  `type` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `price` double NOT NULL,
  PRIMARY KEY (`registeredId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `registeredtype`
--

LOCK TABLES `registeredtype` WRITE;
/*!40000 ALTER TABLE `registeredtype` DISABLE KEYS */;
INSERT INTO `registeredtype` (`registeredId`, `type`, `price`) VALUES (5,'普通挂号',20),(6,'专家号',30);
/*!40000 ALTER TABLE `registeredtype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `report`
--

DROP TABLE IF EXISTS `report`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `report` (
  `reportId` int NOT NULL AUTO_INCREMENT,
  `reportName` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sex` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `department` int DEFAULT NULL,
  `doctor` int DEFAULT NULL,
  `reportType` int DEFAULT NULL,
  `price` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `users` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `state` int DEFAULT NULL,
  `phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `carid` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `zhuan` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`reportId`) USING BTREE,
  KEY `fk_departmentr` (`department`) USING BTREE,
  KEY `fk_doctor` (`doctor`) USING BTREE,
  KEY `fk_reportType` (`reportType`) USING BTREE,
  CONSTRAINT `fk_departmentr` FOREIGN KEY (`department`) REFERENCES `departments` (`departmentId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_doctor` FOREIGN KEY (`doctor`) REFERENCES `doctor` (`doctorId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_reportType` FOREIGN KEY (`reportType`) REFERENCES `registeredtype` (`registeredId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `report`
--

LOCK TABLES `report` WRITE;
/*!40000 ALTER TABLE `report` DISABLE KEYS */;
INSERT INTO `report` (`reportId`, `reportName`, `sex`, `age`, `department`, `doctor`, `reportType`, `price`, `time`, `users`, `state`, `phone`, `carid`, `zhuan`) VALUES (28,'送高帅','男',20,7,14,6,30,'2019-11-21 14:00:00',NULL,3,'13183380740','412827199807156595','头痛，发烧'),(29,'李福州','男',20,7,14,6,30,'2019-11-21 15:04:50','门诊',5,'15565792390','412827199605062586','脑部肿瘤'),(30,'杨帅','男',20,7,14,6,30,'2019-11-21 14:00:00',NULL,3,'13183380740','412369199512023695','头痛'),(31,'song','男',12,7,13,5,20,'2019-11-26 09:16:47','超级管理员',5,'13271678052','412702199902080557','良好'),(32,'adf','女',33,7,14,6,30,'2022-11-15 22:05:48','超级管理员',0,'13888888888','431234182389281823',NULL),(33,'病人1','男',35,7,13,5,20,'2022-11-17 16:55:37','超级管理员',3,'13888887777','431928198209199823','感冒');
/*!40000 ALTER TABLE `report` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `skull`
--

DROP TABLE IF EXISTS `skull`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `skull` (
  `skullId` int NOT NULL AUTO_INCREMENT,
  `skullName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`skullId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `skull`
--

LOCK TABLES `skull` WRITE;
/*!40000 ALTER TABLE `skull` DISABLE KEYS */;
INSERT INTO `skull` (`skullId`, `skullName`) VALUES (4,'张山');
/*!40000 ALTER TABLE `skull` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pid` int DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `href` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `spread` int DEFAULT NULL COMMENT '0不展开1展开',
  `target` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `available` int DEFAULT NULL COMMENT '0不可用1可用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_menu`
--

LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
INSERT INTO `sys_menu` (`id`, `pid`, `title`, `href`, `spread`, `target`, `icon`, `available`) VALUES (1,0,'医院管理系统','',1,NULL,'',1),(2,1,'门诊管理','',0,NULL,'',1),(3,1,'住院管理','',0,NULL,'',1),(4,1,'系统管理','',0,'','',1),(5,1,'统计管理','',0,NULL,'',1),(6,2,'用户挂号','../outpaient/index',0,NULL,'',1),(7,2,'处方划价','../outpaientcc/cc',0,NULL,'',1),(8,3,'入院登记','../inpaient/admin',0,NULL,'',1),(9,3,'缴费管理','../inpaient/pay',0,NULL,'',1),(11,3,'药品记账','../inpaient/drug',0,NULL,'',1),(12,4,'菜单管理','../toMenuManager',0,NULL,'',1),(13,4,'角色管理','../toLoadAllRole',0,'','',1),(14,4,'用户管理','../toLoadAllUser',0,NULL,'',1),(15,4,'图标管理','../icon',0,NULL,'',1),(18,5,'门诊月度统计','../toReportFinance',0,NULL,'',1),(19,5,'住院月度统计','../toZhuYaunManage',0,NULL,'',1),(20,5,'门诊年度统计','../toBingYear',0,NULL,'',1),(27,2,'项目划价','../outpaientout/xiang',0,NULL,'',1),(28,2,'项目缴费','../xpay/xiangpay',0,NULL,'',1),(30,1,'数据中心','',0,NULL,'',1),(31,30,'科室中心','../toDepartments',0,NULL,'',1),(32,30,'医生列表','../toDoctor',0,NULL,'',1),(33,30,'药品产地','../toArea',0,NULL,'',1),(36,30,'项目大类','../toProjectTypeManage',0,NULL,'',1),(37,30,'挂号类型','../toRegisteredType',0,NULL,'',1),(40,30,'仓库','../toWarehuose',0,NULL,'',1),(41,30,'经办人','../toSkull',0,NULL,'',1),(42,30,'计量单位','../toUnit',0,NULL,'',1),(43,30,'供货商','../toSupply',0,NULL,'',1),(44,30,'药品分类','../toType',0,NULL,'',1),(46,1,'排班管理','1',0,NULL,'',1),(47,46,'医生排班','../toPaiban',0,NULL,'',1),(48,30,'药品字典','../toDrugdictionary',0,NULL,'',1),(49,3,'项目记账','../inpaient/item',0,NULL,'',1),(52,5,'住院年度统计','../toBing2',0,NULL,'',1),(53,2,'项目检查','../xpay/seljian',0,NULL,'',1),(54,1,'仓库管理','',0,NULL,'',1),(55,54,'入库单','../dsnavigation/beputinstorage',0,NULL,'',1),(56,5,'医生统计对比','../toDoctorDuibi',0,NULL,'',1),(57,54,'库存查询','../dsnavigation/selectdurg',0,NULL,'',1),(58,54,'出库单','../dsnavigation/selectchuku',0,NULL,'',1),(59,54,'库存不足','../dsnavigation/selectless',0,NULL,'',1),(60,54,'过期提醒','../dsnavigation/seldrugDate',0,NULL,'',1),(61,1,'药房管理','',0,NULL,'',1),(62,61,'药房详情','../dsnavigation/pharymacyhtml',0,NULL,'',1),(64,2,'药品缴费','../outpaientout/out',0,NULL,'',1),(65,5,'门诊当天统计','../toCurrent',0,NULL,'',1),(69,2,'门诊患者库','../outpaienttake/haun',0,NULL,'',1),(70,54,'操作记录','../dsnavigation/record',0,NULL,'',1),(71,54,'药品回收','../dsnavigation/recycle',0,NULL,'',1),(72,61,'门诊取药','../outpaienttake/seltake',0,NULL,'',1),(73,61,'住院取药','../inpaient/pharmacy',0,NULL,'',1),(86,3,'出院结算','../inpaient/leave',0,NULL,'',1),(90,2,'test','',0,NULL,'',1),(92,4,'医院基础信息维护','../toHospitalManage',0,NULL,'',1);
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role` (
  `roleid` int NOT NULL AUTO_INCREMENT,
  `rolename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `roledesc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `available` int DEFAULT NULL,
  PRIMARY KEY (`roleid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` (`roleid`, `rolename`, `roledesc`, `available`) VALUES (1,'超级管理员','拥有所有菜单权限',1),(4,'门诊管理','拥有门诊管理的权限',1),(5,'住院管理','拥有住院部全部权限',1),(6,'仓库管理','拥有仓库管理全部权限',1);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_menu`
--

DROP TABLE IF EXISTS `sys_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role_menu` (
  `rid` int NOT NULL,
  `mid` int NOT NULL,
  PRIMARY KEY (`rid`,`mid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_menu`
--

LOCK TABLES `sys_role_menu` WRITE;
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
INSERT INTO `sys_role_menu` (`rid`, `mid`) VALUES (1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,11),(1,12),(1,13),(1,14),(1,15),(1,18),(1,19),(1,20),(1,27),(1,28),(1,30),(1,31),(1,32),(1,33),(1,36),(1,37),(1,40),(1,41),(1,42),(1,43),(1,44),(1,46),(1,47),(1,48),(1,49),(1,52),(1,53),(1,54),(1,55),(1,56),(1,57),(1,58),(1,59),(1,60),(1,61),(1,62),(1,64),(1,65),(1,69),(1,70),(1,71),(1,72),(1,73),(1,86),(1,92),(4,1),(4,2),(4,6),(4,7),(4,27),(4,28),(4,53),(4,61),(4,64),(4,69),(4,72),(4,90),(5,1),(5,3),(5,8),(5,9),(5,11),(5,49),(5,61),(5,73),(5,86),(6,1),(6,54),(6,55),(6,57),(6,58),(6,59),(6,60),(6,61),(6,62),(6,70),(6,71);
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_user`
--

DROP TABLE IF EXISTS `sys_role_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role_user` (
  `uid` int NOT NULL,
  `rid` int NOT NULL,
  PRIMARY KEY (`uid`,`rid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_user`
--

LOCK TABLES `sys_role_user` WRITE;
/*!40000 ALTER TABLE `sys_role_user` DISABLE KEYS */;
INSERT INTO `sys_role_user` (`uid`, `rid`) VALUES (1,1),(9,1),(10,1),(11,1),(12,1),(13,1),(28,4),(29,5),(30,6);
/*!40000 ALTER TABLE `sys_role_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user` (
  `userid` int NOT NULL AUTO_INCREMENT,
  `loginname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `identity` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `realname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sex` int DEFAULT NULL COMMENT '0女1男',
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `position` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `type` int DEFAULT '2' COMMENT '1，超级管理员,2，系统用户',
  `available` int DEFAULT NULL,
  `salt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`userid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` (`userid`, `loginname`, `identity`, `realname`, `sex`, `address`, `phone`, `pwd`, `position`, `type`, `available`, `salt`) VALUES (1,'admin','412365199601236544','超级管理员',1,'武汉','13183380740','6af4d08340b548cbcce38353d9bcaab4','CEO',1,1,'d21fd4'),(28,'mz','412827199807156565','门诊',1,'河南','13183365365','3a24ab463a062b254ba97893416fcb3c','门诊管理员',2,1,'b16016'),(29,'zy','412827199807156565','住院',1,'长沙','13888887777','0b9e490e5b6642d665fd3d80a3aece8e','住院部管理员',2,1,'7ecf4c'),(30,'ck','412827199807156565','仓库',1,'长沙','13888886666','605602bcdf19ff0afc2eb0bfc38d0d3d','仓库管理员',2,1,'df3e98');
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type`
--

DROP TABLE IF EXISTS `type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `type` (
  `typeId` int NOT NULL AUTO_INCREMENT,
  `typeName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`typeId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type`
--

LOCK TABLES `type` WRITE;
/*!40000 ALTER TABLE `type` DISABLE KEYS */;
INSERT INTO `type` (`typeId`, `typeName`) VALUES (5,'西药'),(6,'中药');
/*!40000 ALTER TABLE `type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unit`
--

DROP TABLE IF EXISTS `unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `unit` (
  `unitId` int NOT NULL AUTO_INCREMENT,
  `unitName` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`unitId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit`
--

LOCK TABLES `unit` WRITE;
/*!40000 ALTER TABLE `unit` DISABLE KEYS */;
INSERT INTO `unit` (`unitId`, `unitName`) VALUES (7,'盒'),(8,'次'),(9,'袋');
/*!40000 ALTER TABLE `unit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upplier`
--

DROP TABLE IF EXISTS `upplier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `upplier` (
  `supplierId` int NOT NULL AUTO_INCREMENT,
  `supplierName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `supplierPhone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `supplierAddress` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `state` int DEFAULT NULL,
  PRIMARY KEY (`supplierId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upplier`
--

LOCK TABLES `upplier` WRITE;
/*!40000 ALTER TABLE `upplier` DISABLE KEYS */;
INSERT INTO `upplier` (`supplierId`, `supplierName`, `supplierPhone`, `supplierAddress`, `state`) VALUES (5,'春天大药房 ',NULL,NULL,0);
/*!40000 ALTER TABLE `upplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehuose`
--

DROP TABLE IF EXISTS `warehuose`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `warehuose` (
  `warehouseId` int NOT NULL AUTO_INCREMENT,
  `supplierName` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`warehouseId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `warehuose`
--

LOCK TABLES `warehuose` WRITE;
/*!40000 ALTER TABLE `warehuose` DISABLE KEYS */;
INSERT INTO `warehuose` (`warehouseId`, `supplierName`) VALUES (2,'仓库');
/*!40000 ALTER TABLE `warehuose` 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 2025-03-23 10:58:09

3.修改配置文件

修改数据库的url username password配置

spring:
  datasource:
    dynamic:
      strict: true
      datasource:
        master:
          url: jdbc:mysql://192.168.200.101:3306/his?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
          username: root
          password: mysql_7mWPJ8
          type: com.alibaba.druid.pool.DruidDataSource

4.启动项目测试

控制台显示如下信息即为启动成功

"C:\Program Files\Java\jdk1.8.0_131\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:5399,suspend=y,server=n -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-Dmanagement.endpoints.jmx.exposure.include=*" -javaagent:C:\Users\Jason\AppData\Local\JetBrains\IntelliJIdea2023.1\captureAgent\debugger-agent.jar -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_131\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\rt.jar;C:\Users\Jason\IdeaProjects\hisSaas\target\classes;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-thymeleaf\2.4.0\spring-boot-starter-thymeleaf-2.4.0.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter\2.4.0\spring-boot-starter-2.4.0.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-logging\2.4.0\spring-boot-starter-logging-2.4.0.jar;C:\Software\maven\maven-repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;C:\Software\maven\maven-repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;C:\Software\maven\maven-repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;C:\Software\maven\maven-repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;C:\Software\maven\maven-repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;C:\Software\maven\maven-repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Software\maven\maven-repository\org\springframework\spring-core\5.3.1\spring-core-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-jcl\5.3.1\spring-jcl-5.3.1.jar;C:\Software\maven\maven-repository\org\yaml\snakeyaml\1.27\snakeyaml-1.27.jar;C:\Software\maven\maven-repository\org\thymeleaf\thymeleaf-spring5\3.0.11.RELEASE\thymeleaf-spring5-3.0.11.RELEASE.jar;C:\Software\maven\maven-repository\org\thymeleaf\thymeleaf\3.0.11.RELEASE\thymeleaf-3.0.11.RELEASE.jar;C:\Software\maven\maven-repository\org\attoparser\attoparser\2.0.5.RELEASE\attoparser-2.0.5.RELEASE.jar;C:\Software\maven\maven-repository\org\unbescape\unbescape\1.1.6.RELEASE\unbescape-1.1.6.RELEASE.jar;C:\Software\maven\maven-repository\org\thymeleaf\extras\thymeleaf-extras-java8time\3.0.4.RELEASE\thymeleaf-extras-java8time-3.0.4.RELEASE.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-web\2.4.0\spring-boot-starter-web-2.4.0.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-json\2.4.0\spring-boot-starter-json-2.4.0.jar;C:\Software\maven\maven-repository\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;C:\Software\maven\maven-repository\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;C:\Software\maven\maven-repository\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;C:\Software\maven\maven-repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;C:\Software\maven\maven-repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;C:\Software\maven\maven-repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-tomcat\2.4.0\spring-boot-starter-tomcat-2.4.0.jar;C:\Software\maven\maven-repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.39\tomcat-embed-core-9.0.39.jar;C:\Software\maven\maven-repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;C:\Software\maven\maven-repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.39\tomcat-embed-websocket-9.0.39.jar;C:\Software\maven\maven-repository\org\springframework\spring-web\5.3.1\spring-web-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-beans\5.3.1\spring-beans-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-webmvc\5.3.1\spring-webmvc-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-aop\5.3.1\spring-aop-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-context\5.3.1\spring-context-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-expression\5.3.1\spring-expression-5.3.1.jar;C:\Software\maven\maven-repository\com\baomidou\mybatis-plus-boot-starter\3.5.2\mybatis-plus-boot-starter-3.5.2.jar;C:\Software\maven\maven-repository\com\baomidou\mybatis-plus\3.5.2\mybatis-plus-3.5.2.jar;C:\Software\maven\maven-repository\com\baomidou\mybatis-plus-extension\3.5.2\mybatis-plus-extension-3.5.2.jar;C:\Software\maven\maven-repository\com\baomidou\mybatis-plus-core\3.5.2\mybatis-plus-core-3.5.2.jar;C:\Software\maven\maven-repository\com\baomidou\mybatis-plus-annotation\3.5.2\mybatis-plus-annotation-3.5.2.jar;C:\Software\maven\maven-repository\org\mybatis\mybatis\3.5.10\mybatis-3.5.10.jar;C:\Software\maven\maven-repository\org\mybatis\mybatis-spring\2.0.7\mybatis-spring-2.0.7.jar;C:\Software\maven\maven-repository\org\jetbrains\kotlin\kotlin-stdlib-jdk8\1.4.10\kotlin-stdlib-jdk8-1.4.10.jar;C:\Software\maven\maven-repository\org\jetbrains\kotlin\kotlin-stdlib\1.4.10\kotlin-stdlib-1.4.10.jar;C:\Software\maven\maven-repository\org\jetbrains\kotlin\kotlin-stdlib-common\1.4.10\kotlin-stdlib-common-1.4.10.jar;C:\Software\maven\maven-repository\org\jetbrains\annotations\13.0\annotations-13.0.jar;C:\Software\maven\maven-repository\org\jetbrains\kotlin\kotlin-stdlib-jdk7\1.4.10\kotlin-stdlib-jdk7-1.4.10.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-autoconfigure\2.4.0\spring-boot-autoconfigure-2.4.0.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-jdbc\2.4.0\spring-boot-starter-jdbc-2.4.0.jar;C:\Software\maven\maven-repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;C:\Software\maven\maven-repository\com\baomidou\dynamic-datasource-spring-boot-starter\3.6.1\dynamic-datasource-spring-boot-starter-3.6.1.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-starter-aop\2.4.0\spring-boot-starter-aop-2.4.0.jar;C:\Software\maven\maven-repository\org\aspectj\aspectjweaver\1.9.6\aspectjweaver-1.9.6.jar;C:\Software\maven\maven-repository\com\alibaba\druid\1.2.9\druid-1.2.9.jar;C:\Software\maven\maven-repository\mysql\mysql-connector-java\8.0.16\mysql-connector-java-8.0.16.jar;C:\Software\maven\maven-repository\com\github\pagehelper\pagehelper-spring-boot-starter\1.2.3\pagehelper-spring-boot-starter-1.2.3.jar;C:\Software\maven\maven-repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\1.3.1\mybatis-spring-boot-starter-1.3.1.jar;C:\Software\maven\maven-repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\1.3.1\mybatis-spring-boot-autoconfigure-1.3.1.jar;C:\Software\maven\maven-repository\com\github\pagehelper\pagehelper-spring-boot-autoconfigure\1.2.3\pagehelper-spring-boot-autoconfigure-1.2.3.jar;C:\Software\maven\maven-repository\com\github\pagehelper\pagehelper\5.1.2\pagehelper-5.1.2.jar;C:\Software\maven\maven-repository\com\github\jsqlparser\jsqlparser\1.0\jsqlparser-1.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-core\1.7.0\shiro-core-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-lang\1.7.0\shiro-lang-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-cache\1.7.0\shiro-cache-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-crypto-hash\1.7.0\shiro-crypto-hash-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-crypto-core\1.7.0\shiro-crypto-core-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-crypto-cipher\1.7.0\shiro-crypto-cipher-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-config-core\1.7.0\shiro-config-core-1.7.0.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-config-ogdl\1.7.0\shiro-config-ogdl-1.7.0.jar;C:\Software\maven\maven-repository\commons-beanutils\commons-beanutils\1.9.4\commons-beanutils-1.9.4.jar;C:\Software\maven\maven-repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Software\maven\maven-repository\org\apache\shiro\shiro-event\1.7.0\shiro-event-1.7.0.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot-devtools\2.4.0\spring-boot-devtools-2.4.0.jar;C:\Software\maven\maven-repository\org\springframework\boot\spring-boot\2.4.0\spring-boot-2.4.0.jar;C:\Software\maven\maven-repository\com\github\drtrang\druid-spring-boot2-starter\1.1.9\druid-spring-boot2-starter-1.1.9.jar;C:\Software\maven\maven-repository\com\github\drtrang\druid-spring-boot2-autoconfigure\1.1.9\druid-spring-boot2-autoconfigure-1.1.9.jar;C:\Software\maven\maven-repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;C:\Software\maven\maven-repository\org\springframework\spring-jdbc\5.3.1\spring-jdbc-5.3.1.jar;C:\Software\maven\maven-repository\org\springframework\spring-tx\5.3.1\spring-tx-5.3.1.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2023.1.2\lib\idea_rt.jar" com.roy.HospitalApplication
已连接到目标 VM, 地址: ''127.0.0.1:5399'，传输: '套接字''
{spring.web.resources.chain.cache=false, spring.web.resources.cache.period=0}
2025-03-23 11:39:07.165  INFO 436 --- [  restartedMain] com.roy.HospitalApplication              : Starting HospitalApplication using Java 1.8.0_131 on DESKTOP-PC4GEUR with PID 436 (C:\Users\Jason\IdeaProjects\hisSaas\target\classes started by Jason in C:\Users\Jason\IdeaProjects\hisSaas)
2025-03-23 11:39:07.172  INFO 436 --- [  restartedMain] com.roy.HospitalApplication              : No active profile set, falling back to default profiles: default
2025-03-23 11:39:07.222  INFO 436 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2025-03-23 11:39:07.223  INFO 436 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2025-03-23 11:39:07.233  WARN 436 --- [kground-preinit] o.s.h.c.j.Jackson2ObjectMapperBuilder    : For Jackson Kotlin classes support please add "com.fasterxml.jackson.module:jackson-module-kotlin" to the classpath
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'areaMapper' and 'com.roy.mapper.AreaMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'CCashierMapper' and 'com.roy.mapper.CCashierMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'COutMapper' and 'com.roy.mapper.COutMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'CTakeMapper' and 'com.roy.mapper.CTakeMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'CXiangmuPayMapper' and 'com.roy.mapper.CXiangmuPayMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'checkupMapper' and 'com.roy.mapper.CheckupMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'creportMapper' and 'com.roy.mapper.CreportMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'departmentMapper' and 'com.roy.mapper.DepartmentMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'doctorMapper' and 'com.roy.mapper.DoctorMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'financeMapper' and 'com.roy.mapper.FinanceMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'hospitalMapper' and 'com.roy.mapper.HospitalMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'ladminMapper' and 'com.roy.mapper.LadminMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.188  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'ldrugMapper' and 'com.roy.mapper.LdrugMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'litemMapper' and 'com.roy.mapper.LitemMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'lleaveMapper' and 'com.roy.mapper.LleaveMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'lpayMapper' and 'com.roy.mapper.LpayMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'mainMapper' and 'com.roy.mapper.MainMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'menuMapper' and 'com.roy.mapper.MenuMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'outinstoreMapper' and 'com.roy.mapper.OutinstoreMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'paibanMapper' and 'com.roy.mapper.PaibanMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'pharmacyMapper' and 'com.roy.mapper.PharmacyMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'prjectTypeMapper' and 'com.roy.mapper.PrjectTypeMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'putinMapper' and 'com.roy.mapper.PutinMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'recordMapper' and 'com.roy.mapper.RecordMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'registeredTypeMapper' and 'com.roy.mapper.RegisteredTypeMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'roleMapper' and 'com.roy.mapper.RoleMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'sdrugdictionaryMapper' and 'com.roy.mapper.SdrugdictionaryMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'skullMapper' and 'com.roy.mapper.SkullMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'storeMapper' and 'com.roy.mapper.StoreMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'typeMapper' and 'com.roy.mapper.TypeMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'unitMapper' and 'com.roy.mapper.UnitMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'upplierMapper' and 'com.roy.mapper.UpplierMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'userMapper' and 'com.roy.mapper.UserMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.189  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : Skipping MapperFactoryBean with name 'warehuoseMapper' and 'com.roy.mapper.WarehuoseMapper' mapperInterface. Bean already defined with the same name!
2025-03-23 11:39:08.190  WARN 436 --- [  restartedMain] o.m.s.mapper.ClassPathMapperScanner      : No MyBatis mapper was found in '[com.roy.mapper]' package. Please check your configuration.
2025-03-23 11:39:08.355  INFO 436 --- [  restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'spring.datasource.dynamic-com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties' of type [com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-03-23 11:39:08.359  INFO 436 --- [  restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration' of type [com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration$$EnhancerBySpringCGLIB$$21c9965e] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-03-23 11:39:08.374  INFO 436 --- [  restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'dsProcessor' of type [com.baomidou.dynamic.datasource.processor.DsHeaderProcessor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-03-23 11:39:08.643  INFO 436 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2025-03-23 11:39:08.656  INFO 436 --- [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2025-03-23 11:39:08.657  INFO 436 --- [  restartedMain] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.39]
2025-03-23 11:39:08.755  INFO 436 --- [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2025-03-23 11:39:08.755  INFO 436 --- [  restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1532 ms
2025-03-23 11:39:08.964  INFO 436 --- [  restartedMain] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1,master} inited
2025-03-23 11:39:08.965  INFO 436 --- [  restartedMain] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource - add a datasource named [master] success
2025-03-23 11:39:08.966  INFO 436 --- [  restartedMain] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource initial loaded [1] datasource,primary datasource named [master]
 _ _   |_  _ _|_. ___ _ |    _ 
| | |\/|_)(_| | |_\  |_)||_|_\ 
     /               |         
                        3.5.2 
2025-03-23 11:39:10.207 DEBUG 436 --- [  restartedMain] c.roy.mapper.HospitalMapper.selectList   : ==>  Preparing: SELECT hospitalId,hospitalName,hospitalAddress,mysqlUrl,mysqlSchema,mysqlUsername,mysqlPassword,mysqlStatus FROM hospitalmeta WHERE (mysqlStatus = ?)
2025-03-23 11:39:10.231 DEBUG 436 --- [  restartedMain] c.roy.mapper.HospitalMapper.selectList   : ==> Parameters: 1(Integer)
2025-03-23 11:39:10.246 DEBUG 436 --- [  restartedMain] c.roy.mapper.HospitalMapper.selectList   : <==      Total: 0
2025-03-23 11:39:10.572  INFO 436 --- [  restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2025-03-23 11:39:10.677  INFO 436 --- [  restartedMain] o.s.b.a.w.s.WelcomePageHandlerMapping    : Adding welcome page template: index
2025-03-23 11:39:10.931  INFO 436 --- [  restartedMain] o.s.b.d.a.OptionalLiveReloadServer       : LiveReload server is running on port 35729
2025-03-23 11:39:10.978  INFO 436 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2025-03-23 11:39:10.988  INFO 436 --- [  restartedMain] com.roy.HospitalApplication              : Started HospitalApplication in 4.33 seconds (JVM running for 9.122)

5.浏览器访问项目

浏览器访问 http://localhost:8080 超级管理员账号：admin 密码：123456

五.视频讲解