# 江科大健康驿站管理系统 **Repository Path**: zzc987/software ## Basic Information - **Project Name**: 江科大健康驿站管理系统 - **Description**: 医疗管理系统 - **Primary Language**: JavaScript - **License**: MulanPSL-2.0 - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 9 - **Forks**: 1 - **Created**: 2023-05-31 - **Last Updated**: 2024-12-24 ## Categories & Tags **Categories**: Uncategorized **Tags**: SpringBoot, Vue, MySQL, MyBatis ## README # 江科大健康驿站管理系统 ## 数据库设计 ![输入图片说明](%E8%AE%BE%E8%AE%A1%E6%96%87%E6%A1%A3%E5%9B%BE%E7%89%87%E6%96%87%E4%BB%B6%E5%A4%B9/%E7%97%85%E4%BA%BA%E5%85%A5%E4%BD%8F%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9FER%E5%9B%BE(zys).png) 关系模式如下（红色表示主键，黄色表示外键）： 病人表（ **病号** ，姓名，性别，年龄，入住时间，病因） 出站表（**病号** ，姓名，性别，年龄，入住时间，病因，出院时间） 病房表（ **区号，房号**） 入住表（ **病号** ，区号，房号 ，床号） 护士表（ **工号** ，姓名，性别，年龄，电话） 生理状态表（ **病号，日期** ，体温，心率，血压，血糖） 药品表（ **药品编号，** 药品名称，厂家，处方类型，价格，库存量） 用药表（ **病号，药品编号，日期** ，用药量） **PS：其中病房区号分为A、B、C三个分区，每个病区的病房号从101至110为合法房号，每个病房有3张床位，床号分别对应1、2、3。** ### drug表数据插入 ``` insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('1','云南白药膏药','云南白药股份有限公司','非处方','20.00','36'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('2','阿莫西林','上海医药集团有限公司','处方','16.00','18'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('3','莲花清瘟胶囊','石家庄以岭药业股份有限公司','非处方','7.00','60'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('4','感冒灵颗粒','广东新峰药业股份有限公司','非处方','22.00','20'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('5','复方氨酚胶囊','海南亚洲制药','处方','20.00','8'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('6','布洛芬缓释胶囊','吉林道君药业股份有限公司','非处方','26.00','22'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('7','胃康灵颗粒','葵花药业','非处方','36.00','10'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('8','铝碳酸镁咀嚼片','山东鑫齐药业有限公司','处方','4.90','6'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('9','肝胃气痛片','葵花药业','非处方','7.20','7'); insert into `drug` (`drugNumber`, `drugName`, `factory`, `pType`, `price`, `inventory`) values('10','腹可安片','广东康奇力药业股份有限公司','非处方','12.00','12'); ``` ### nurse表数据录入 ``` insert into `nurse` (`nurseID`, `nurseName`, `nurseSex`, `nurseAge`, `nurseTel`) values('202301','李晓红','女','28','13698506943'); insert into `nurse` (`nurseID`, `nurseName`, `nurseSex`, `nurseAge`, `nurseTel`) values('202302','徐丽丽','女','27','18652740826'); insert into `nurse` (`nurseID`, `nurseName`, `nurseSex`, `nurseAge`, `nurseTel`) values('202303','王静','女','29','16666666666'); insert into `nurse` (`nurseID`, `nurseName`, `nurseSex`, `nurseAge`, `nurseTel`) values('202304','陈欣','女','30','13645947982'); insert into `nurse` (`nurseID`, `nurseName`, `nurseSex`, `nurseAge`, `nurseTel`) values('202305','周鹏','男','28','19794256921'); insert into `nurse` (`nurseID`, `nurseName`, `nurseSex`, `nurseAge`, `nurseTel`) values('202306','张松','男','32','13945578767'); ``` ### ward表数据插入（已更新至6.9） ``` insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','101','2','0','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','102','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','103','1','1','0','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','104','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','105','2','0','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','106','2','1','1','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','107','0','0','0','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','108','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','109','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('A','110','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','101','2','0','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','102','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','103','2','0','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','104','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','105','0','0','0','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','106','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','107','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','108','0','0','0','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','109','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('B','110','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','101','2','0','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','102','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','103','0','0','0','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','104','2','1','1','0'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','105','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','106','2','1','0','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','107','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','108','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','109','3','1','1','1'); insert into `ward` (`areaCode`, `roomNumber`, `numbers`, `empty1`, `empty2`, `empty3`) values('C','110','1','0','0','1'); ``` ### 入住表in数据插入（已更新至6.9） ``` insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('123222200705051658','A','107','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('130124198603030914','A','101','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('130134199805120914','A','102','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('260334199805120517','A','103','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('260356200104143984','A','103','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('260356200304123684','A','104','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('310569200511253654','A','105','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('310632200907092366','A','107','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('320156200003236765','A','106','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('370321200606161674','A','107','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('620123200212063685','A','109','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('620123200311062644','A','110','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('160123199905245576','B','101','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('220135200001012545','B','103','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('220143200012051236','B','105','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('220143200110051236','B','105','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('220143200511191256','B','105','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('260123201202306297','B','110','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('320123200208193858','B','102','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('320263199906303691','B','108','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('340121199907215679','B','108','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('340121200303116548','B','108','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('360123200003160915','B','106','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('120123200602281697','C','110','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('120220200406062684','C','110','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('220156200411041256','C','106','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('220630199812061917','C','104','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('360123200203121697','C','101','1'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('360233200006163489','C','102','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('370111199511205237','C','103','3'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('370112197912261032','C','103','2'); insert into `in` (`patientID`, `areaCode`, `roomNumber`, `bedNumber`) values('370121197707211040','C','103','1'); ``` ### 生理信息表数据插入（只能查询这五个人：张三（130124198603030914）、王涛（260123201202306297）、陈颖（310569200511253654）、张小东（320156200003236765）、王伟（320263199906303691））（已更新至6.9） ``` insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-05-31','38.50','85','142','3.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-01','38.00','82','120','4.00'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-02','38.20','75','110','4.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-03','39.00','78','100','6.00'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-04','37.50','80','110','5.20'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-05','37.00','83','90','4.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-06','37.20','73','95','6.30'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-07','38.50','85','120','4.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-08','36.80','83','112','6.10'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('130124198603030914','2023-06-09','36.20','92','90','5.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('260123201202306297','2023-06-04','40.00','80','112','5.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('260123201202306297','2023-06-05','39.00','75','105','5.30'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('260123201202306297','2023-06-06','38.20','78','96','6.20'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('260123201202306297','2023-06-07','38.10','95','100','4.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('260123201202306297','2023-06-08','37.60','110','120','5.60'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('260123201202306297','2023-06-09','37.20','85','130','6.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('310569200511253654','2023-06-07','39.00','80','105','3.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('310569200511253654','2023-06-08','39.50','90','100','5.00'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('310569200511253654','2023-06-09','38.60','85','99','4.00'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320156200003236765','2023-06-04','37.50','89','130','2.60'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320156200003236765','2023-06-05','37.20','75','145','3.00'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320156200003236765','2023-06-06','36.80','88','135','4.50'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320156200003236765','2023-06-07','36.50','82','120','3.60'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320156200003236765','2023-06-08','36.00','84','135','4.20'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320156200003236765','2023-06-09','35.80','75','130','4.60'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320263199906303691','2023-06-06','36.60','68','100','5.60'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320263199906303691','2023-06-07','36.80','75','120','6.20'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320263199906303691','2023-06-08','37.20','69','110','4.90'); insert into `physiology` (`patientID`, `date`, `temperature`, `heartRate`, `bloodPressure`, `bloodSugar`) values('320263199906303691','2023-06-09','35.80','70','115','5.50'); ``` ### 病人表数据插入（已更新至6.9） ``` insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('130124198603030914','张三','男','37','2023-05-27','发烧'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('130134199805120914','张榆嵩','男','25','2023-05-27','胸痛'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('260334199805120517','熊玮','男','25','2023-05-27','发热'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('360123200003160915','李四','男','23','2023-05-27','感冒'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('360123200203121697','熊杰','男','21','2023-05-27','咽喉疼痛'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('370111199511205237','赵书林','男','28','2023-05-28','心绞疼'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('370112197912261032','谢娜','女','44','2023-05-28','感冒'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('370121197707211040','谢莺莺','女','46','2023-05-29','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('340121199907215679','翟大饼','男','24','2023-05-30','病毒性肝炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('220143200012051236','鲜娜','女','23','2023-05-31','胸痛'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('220143200511191256','鲜大东','男','18','2023-05-31','干咳'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('220156200411041256','吴美丽','女','19','2023-05-31','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('340121200303116548','张婷婷','女','20','2023-05-31','心脏悸动'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('220143200110051236','鲜慧慧','女','22','2023-06-01','鼻塞'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('320156200003236765','张小东','男','23','2023-06-01','头晕'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('260356200104143984','张海洋','男','22','2023-06-02','肌肉拉伤'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('260356200304123684','王家赫','男','20','2023-06-02','腿部骨折'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('360233200006163489','李丽','女','23','2023-06-02','腹泻'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('320263199906303691','王伟','男','24','2023-06-03','脑震荡'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('220630199812061917','陈帅','男','25','2023-06-04','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('260123201202306297','王涛','男','11','2023-06-04','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('310569200511253654','陈颖','女','18','2023-06-04','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('120123200602281697','翟婷','女','17','2023-06-05','咳嗽'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('120220200406062684','袁丽娜','女','19','2023-06-06','感冒'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('123222200705051658','王浩','男','16','2023-06-07','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('310632200907092366','陈晨','男','14','2023-06-07','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('370321200606161674','陈浩','男','17','2023-06-07','肌肉拉伤'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('620123200212063685','张杰','男','21','2023-06-07','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('620123200311062644','王佳静','女','20','2023-06-07','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('160123199905245576','邓浩','男','24','2023-06-08','新冠肺炎'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('320123200208193858','郑丽','女','21','2023-06-08','感冒'); insert into `patient` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`) values('220135200001012545','李磊','男','23','2023-06-09','新冠肺炎'); ``` ### 出院表数据插入（已更新至6.9） ``` insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('230255200609293245','张丽','女','17','2023-05-22','新冠肺炎','2023-05-27'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('514626199904251647','王辰','男','24','2023-05-26','新冠肺炎','2023-05-29'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('370260199804243698','鲜达','男','25','2023-05-24','发热','2023-05-30'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('512123200409236541','王洁','女','19','2023-05-26','新冠肺炎','2023-05-31'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('520126200011255423','李丞','男','23','2023-05-29','胸闷','2023-05-31'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('560154199705136428','王珂','女','26','2023-05-28','新冠肺炎','2023-05-31'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('350123200212081916','李湘','女','21','2023-05-25','新冠肺炎','2023-06-01'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('163123199909193126','熊帅','男','24','2023-05-27','胃炎','2023-06-02'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('230163200210021936','王祥','男','21','2023-05-27','手部骨折','2023-06-02'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('250162200108183691','陈凯','男','22','2023-05-29','新冠肺炎','2023-06-02'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('143123198909193126','王洋','女','34','2023-05-29','感冒','2023-06-03'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('153123198909193126','熊栋','男','34','2023-05-30','肠胃炎','2023-06-03'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('220360200607171264','周慧慧','女','17','2023-06-02','新冠肺炎','2023-06-04'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('310269199906142697','李扬','男','24','2023-05-30','发烧','2023-06-04'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('310581200505123214','袁杰','男','18','2023-06-01','新冠肺炎','2023-06-04'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('320269199906142697','陈阳','男','24','2023-05-31','头晕','2023-06-04'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('315233200101116745','翟辉','男','22','2023-05-20','心绞疼','2023-06-06'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('650222199902123645','李晖','男','24','2023-05-21','新冠肺炎','2023-06-06'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('420123200212051619','陈梦','女','21','2023-06-01','新冠肺炎','2023-06-07'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('112123200112123655','蒋天宇','男','22','2023-06-02','新冠肺炎','2023-06-09'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('122123200012013555','王嘉宇','男','23','2023-06-04','新冠肺炎','2023-06-09'); insert into `out` (`patientID`, `patientName`, `patientSex`, `patientAge`, `patientInTime`, `patientWhy`, `patientOutTime`) values('123123200111113655','陈宇','男','22','2023-06-02','发烧','2023-06-09'); ``` ### 建表sql代码 ``` DROP DATABASE `jkyz`; CREATE DATABASE `jkyz`; USE `jkyz`; ``` ``` DROP TABLE IF EXISTS `out`; -- 创建出站表 DROP TABLE IF EXISTS `out`; -- 创建出站表 CREATE TABLE `out` ( `patientID` VARCHAR(18) NOT NULL COMMENT "身份证号", `patientName` VARCHAR(20) DEFAULT NULL COMMENT "名字", `patientSex` CHAR(1) DEFAULT NULL COMMENT "性别", `patientAge` SMALLINT DEFAULT NULL COMMENT "年龄", `patientInTime` DATE DEFAULT NULL COMMENT "入住时间", `patientWhy` VARCHAR(100) DEFAULT NULL COMMENT "病因", `patientOutTime` DATE COMMENT "出院时间", PRIMARY KEY (`patientID`,`patientOutTime`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; ``` ``` -- 创建病人表 DROP TABLE IF EXISTS patient; CREATE TABLE `patient` ( `patientID` VARCHAR(18) NOT NULL COMMENT "身份证号", `patientName` VARCHAR(20) DEFAULT NULL COMMENT "名字", `patientSex` CHAR(1) DEFAULT NULL COMMENT "性别", `patientAge` SMALLINT(3) DEFAULT NULL COMMENT "年龄", `patientInTime` DATE DEFAULT NULL COMMENT "入住时间", `patientWhy` VARCHAR(100) DEFAULT NULL COMMENT "病因", PRIMARY KEY (`patientID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- 病房表 DROP TABLE IF EXISTS ward; CREATE TABLE `ward` ( `areaCode` CHAR(1) NOT NULL COMMENT "区号", `roomNumber` VARCHAR(10) NOT NULL COMMENT "房号", `numbers` INT(1) NOT NULL DEFAULT 3 COMMENT "房价剩余床位数量,空时为3", `empty1` BOOLEAN DEFAULT TRUE COMMENT "一号床位是否为空", `empty2` BOOLEAN DEFAULT TRUE COMMENT "二号床位是否为空", `empty3` BOOLEAN DEFAULT TRUE COMMENT "三号床位是否为空", PRIMARY KEY (`areaCode`,`roomNumber`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- 入住表 DROP TABLE IF EXISTS `in`; CREATE TABLE `in` ( `patientID` VARCHAR(18) NOT NULL COMMENT "身份证号", `areaCode` CHAR(1) DEFAULT NULL COMMENT "区号", `roomNumber` CHAR(10) DEFAULT NULL COMMENT "房号", `bedNumber` CHAR(1) DEFAULT NULL COMMENT "床号", PRIMARY KEY (`patientID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- 护士表 DROP TABLE IF EXISTS `nurse`; CREATE TABLE `nurse` ( `nurseID` VARCHAR(10) NOT NULL COMMENT "工号", `nurseName` VARCHAR(20) DEFAULT NULL COMMENT "姓名", `nurseSex` CHAR(1) DEFAULT NULL COMMENT "性别", `nurseAge` SMALLINT(3) DEFAULT NULL COMMENT "年龄", `nurseTel` CHAR(11) DEFAULT NULL COMMENT "电话", PRIMARY KEY (`nurseID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- 生理状态表 DROP TABLE IF EXISTS `physiology`; CREATE TABLE `physiology` ( `patientID` VARCHAR(18) NOT NULL COMMENT "身份证号", `date` DATE NOT NULL COMMENT "日期", `temperature` FLOAT(4,2) DEFAULT NULL COMMENT "体温", `heartRate` INT(3) DEFAULT NULL COMMENT "心率", `bloodPressure` INT(3) DEFAULT NULL COMMENT "血压", `bloodSugar` FLOAT(4,2) DEFAULT NULL COMMENT "血糖", PRIMARY KEY (`patientID`,`date`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- 药品表 DROP TABLE IF EXISTS `drug`; CREATE TABLE `drug` ( `drugNumber` INT(10) NOT NULL COMMENT "药品编号", `drugName` VARCHAR(20) DEFAULT NULL COMMENT "药品名称", `factory` VARCHAR(20) DEFAULT NULL COMMENT "厂商", `pType` VARCHAR(20) DEFAULT NULL COMMENT "处方类型", `price` DOUBLE(10,2) DEFAULT NULL COMMENT "价格", `inventory` INT(10) DEFAULT NULL COMMENT "库存量", PRIMARY KEY (`drugNumber`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- 用药表 DROP TABLE IF EXISTS `usedrug`; CREATE TABLE `usedrug` ( `patientID` VARCHAR(18) NOT NULL COMMENT "身份证号", `drugNumber` INT NOT NULL COMMENT "药品编号", `date` DATE NOT NULL COMMENT "日期", `dosage` INT DEFAULT NULL COMMENT "用药量", PRIMARY KEY (`patientID`,`drugNumber`,`date`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; ``` ## 1. 系统首页（数据统计分析页） >- 男性占比和女性占比（统计在院病人表中男和女性人数除以在院总人数） >- 统计近6个月入院的总人数并绘制折线图（按月份统计病人表中人数，包括在院和出院的病人） >- 统计入住率（在院病人占驿站总病床数的占比） >- 分别统计A、B、C区病房的入住率（A、B、C区入住病人数占该区病床数的占比） >- 统计总入站人数（有史以来所有入站的人数，包括所有在院和出院的病人） >- 统计总出站人数（统计已出院的人数） >- 目前在站人数（统计总在院人数） >- 空床位数（驿站总床位数（3个区一个区10间病房一间病房3个床位，所以默认为90）-在站人数） >- 今日出站人数（统计出院表中今日出站人数） ![输入图片说明](%E8%AE%BE%E8%AE%A1%E6%96%87%E6%A1%A3%E5%9B%BE%E7%89%87%E6%96%87%E4%BB%B6%E5%A4%B9/11EC2E39E80A46E7407D73938D397669.jpg) ------------------------------------------------------------------------------------------------- ## 2. 患者管理——病人表的增删查改功能 >- 查：按病号查询、按性别查询、按入住时间查询 >- 增：病人入站（病人表的insert操作） >- 改：每个患者行后设置“修改”按钮，修改病人信息 >- 删：每个患者行后设置“出院”按钮，单击按钮后弹出窗口输入出院时间后将病人信息增加到出院表中，并删除该病人在病人表中的信息和入住表中的信息。 ![输入图片说明](%E8%AE%BE%E8%AE%A1%E6%96%87%E6%A1%A3%E5%9B%BE%E7%89%87%E6%96%87%E4%BB%B6%E5%A4%B9/X8C%60%7BVOYGIA1R$S5XDUCW8E.png) ------------------------------------------------------------------------------------------------- ## 3. 出院信息——出院表的查询（根据常理出院表不具有增删改功能） >- 查：按病号查询、按姓名查询、按入院时间查询、按出院时间查询 ------------------------------------------------------------------------------------------------- ## 4. 入住信息管理——入住表的增删查改功能 >- 查：按病号查询、按区号查询、按房号查询、按床号查询，最好能够与病人表级联显示更多病人详细信息 >- 增：录入病人入住信息，根据常理每当在病人表录入一个病人，就必须为该病人分配一张床位。 >- 该：每行后设置“修改”按钮，修改病人的入住信息。 >- **该表无需删除功能，在病人表的出院按钮按下时，自动完成该病人入住信息的删除** ------------------------------------------------------------------------------------------------- ## 5. 护士信息管理——护士表的增删查改操作 >- 查：按工号查询，按姓名查询，按性别查询 >- 增：录入护士信息 >- 删：每个护士行后设置“解聘”按钮，单击按钮后将该护士从表中删除。 >- 改：每行后设置“修改”按钮，修改护士信息。 ------------------------------------------------------------------------------------------------- ## 6. 生理状态管理——生理状态表的增删查改操作 >- 查：按病号查询，按日期查询 >- 增：录入生理状态信息 >- 删：每个生理状态行后设置“删除”按钮。 >- 改：每行后设置“修改”按钮，修改某个病人某天的生理信息。 >- **可视化功能：根据病号查询后，设置另外按钮实现：根据该病人近几天的生理信息绘制折线图** ------------------------------------------------------------------------------------------------- ## 7.药品管理——药品表的增删查改操作 >- 查：按药品编号查询，按药品名称模糊查询，按厂家模糊查询，按处方类型查询 >- 增：录入药品信息 >- 删：每个药品行后设置“删除”按钮。 >- 改：每行后设置“修改”按钮，修改药品信息。 >- **可视化：对所有药品库存量进行绘制柱状图** #### 参与贡献 1. Fork 本仓库 2. 新建 Feat_xxx 分支 3. 提交代码 4. 新建 Pull Request #### 特技 1. 使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md 2. Gitee 官方博客 [blog.gitee.com](https://blog.gitee.com) 3. 你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解 Gitee 上的优秀开源项目 4. [GVP](https://gitee.com/gvp) 全称是 Gitee 最有价值开源项目，是综合评定出的优秀开源项目 5. Gitee 官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help) 6. Gitee 封面人物是一档用来展示 Gitee 会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)