java—Web（项目）—数据库（插入数据）

最新推荐文章于 2022-10-07 15:56:53 发布
新时代的农民工
最新推荐文章于 2022-10-07 15:56:53 发布
阅读量1.5k
点赞数
文章标签：数据库 mysql
本文链接：https://blog.csdn.net/jxcncb/article/details/109061854
版权
实现代码：
CREATE TABLE `allot` (
  `allotId` int(8) default NULL COMMENT 'ID',
  `hospitalId` int(4) default NULL COMMENT '医院ID',
  `originNum` date default NULL COMMENT '起点库房编号',
  `endNum` float default NULL COMMENT '终点库房编号',
  `drugNum` int(8) NOT NULL COMMENT '药品编号',
  `allotDate` int(4) default NULL COMMENT '调拨时间',
  `allotNumber` int(4) default NULL COMMENT '数量',
  `unit` int(4) default NULL COMMENT '单位',
  PRIMARY KEY  (`drugNum`),
  CONSTRAINT `FK_allot_drugmessage` FOREIGN KEY (`drugNum`) REFERENCES `drugmessage` (`drugNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='调拨表';

/*Data for the table `allot` */

/*Table structure for table `beput` */

CREATE TABLE `beput` (
  `bePutId` int(8) NOT NULL auto_increment COMMENT '入库单',
  `drugNum` int(8) NOT NULL COMMENT '药品编号',
  `bePutDate` date default NULL COMMENT '入库日期',
  `primeCost` float default NULL COMMENT '进货价格',
  `primeNumber` int(4) default NULL COMMENT '进货数量',
  `unitName` int(4) default NULL COMMENT '单位编号',
  `staffNum` int(8) default NULL COMMENT '员工编号（管理员）',
  `supplierId` int(4) default NULL COMMENT '供应商',
  `birthDate` date default NULL COMMENT '生产日期',
  `indate` date default NULL COMMENT '有效期',
  PRIMARY KEY  (`drugNum`),
  KEY `bePutId` (`bePutId`),
  CONSTRAINT `FK_beput_drugmessage` FOREIGN KEY (`drugNum`) REFERENCES `drugmessage` (`drugNum`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='入库单表';

/*Data for the table `beput` */

insert  into `beput`(`bePutId`,`drugNum`,`bePutDate`,`primeCost`,`primeNumber`,`unitName`,`staffNum`,`supplierId`,`birthDate`,`indate`) values (1,1001,'2020-10-12',20,5000,1,2,3306,'2020-09-12','2025-10-01'),(2,1002,'2020-10-12',25,5000,1,2,3306,'2020-10-08','2023-08-16'),(3,1003,'2020-10-12',30,5000,1,2,3306,'2020-09-10','2024-07-01'),(4,1004,'2020-10-12',20,5000,1,2,3306,'2020-10-07','2023-10-12'),(5,1005,'2020-10-12',30,5000,1,2,3306,'2020-10-01','2023-10-11'),(6,1006,'2020-10-12',20,5000,1,2,3306,'2020-10-02','2023-01-01'),(7,1007,'2020-10-12',30,5000,1,2,3306,'2020-10-08','2022-11-18'),(8,1008,'2020-10-12',20,5000,1,2,3306,'2020-10-08','2025-03-12'),(9,1009,'2020-10-12',30,5000,1,2,3306,'2020-10-03','2024-04-03'),(10,1010,'2020-10-12',20,5000,1,2,3306,'2020-10-05','2023-11-17'),(11,1011,'2020-10-12',30,5000,1,2,3306,'2020-09-30','2023-01-13'),(12,1012,'2020-10-12',20,5000,1,2,3306,'2020-10-08','2021-11-20'),(13,1013,'2020-10-12',30,5000,1,2,3306,'2020-10-02','2022-08-20');

/*Table structure for table `drugbreak` */

CREATE TABLE `drugbreak` (
  `breakId` int(8) NOT NULL auto_increment COMMENT '报损ID',
  `hospitalId` int(8) default NULL COMMENT '医院ID',
  `drugNum` int(8) NOT NULL COMMENT '药品编号',
  `breakNumber` int(8) default NULL COMMENT '报损数量',
  `unitNum` int(4) default NULL COMMENT '单位编号',
  `brealReason` varchar(50) default NULL COMMENT '报损原因',
  `breakDate` date default NULL COMMENT '报损日期',
  `declarant` char(20) default NULL COMMENT '申报人',
  `auditor` char(20) default NULL COMMENT '审核人',
  `declareDate` date default NULL COMMENT '申报日期',
  PRIMARY KEY  (`drugNum`),
  KEY `breakId` (`breakId`),
  CONSTRAINT `FK_drugbreak_drugmessage` FOREIGN KEY (`drugNum`) REFERENCES `drugmessage` (`drugNum`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='药品报损表';

/*Data for the table `drugbreak` */

insert  into `drugbreak`(`breakId`,`hospitalId`,`drugNum`,`breakNumber`,`unitNum`,`brealReason`,`breakDate`,`declarant`,`auditor`,`declareDate`) values (1,110,1001,150,3306,'过期','2020-10-12','何德克','李梅','2020-10-13');

/*Table structure for table `drugmessage` */

CREATE TABLE `drugmessage` (
  `drugNum` int(8) NOT NULL COMMENT '药品编号',
  `sortNum` int(8) NOT NULL COMMENT '类别编号',
  `drugName` varchar(50) default NULL COMMENT '药品名称',
  `unit` double default NULL COMMENT '单价',
  `size` varchar(50) default NULL COMMENT '规格',
  `drugStock` float default NULL COMMENT '库存量',
  `drugDate` date default NULL COMMENT '日期',
  PRIMARY KEY  (`drugNum`,`sortNum`),
  KEY `FK_drugmessage_bePut` (`drugName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='药品信息表';

/*Data for the table `drugmessage` */

insert  into `drugmessage`(`drugNum`,`sortNum`,`drugName`,`unit`,`size`,`drugStock`,`drugDate`) values (1001,1,'感通片',20,'0.32g*20s',5000,'2020-10-12'),(1002,2,'双歧杆菌活菌三联活菌散',25,'1g*7袋/盒',5000,'2020-10-12'),(1003,3,'西瓜霜清咽含片',30,'1.8g*16/盒',5000,'2020-10-12'),(1004,4,'硫酸镁',150,'500g',5000,'2020-10-12'),(1005,5,'奥美拉唑',70,'40mg*14',5000,'2020-10-12'),(1006,6,'小儿化食口服液',46,'10ml×10支',5000,'2020-10-12'),(1007,7,'养血安神糖浆',88,'100ml/瓶',5000,'2020-10-12'),(1008,8,'谷维素（片剂）',56,'10mg*100/盒 ',5000,'2020-10-12'),(1009,9,'三九胃泰颗粒',42,'20g*10包',5000,'2020-10-12'),(1010,10,'妇科千金胶囊',99,'0.4g*24粒/盒',5000,'2020-10-12'),(1011,11,'头孢克肟颗粒',54,'50mg*12/瓶',5000,'2020-10-12'),(1012,12,'人用狂犬疫苗',180,'0.5mg*5支/盒',5000,'2020-10-12'),(1013,13,'注射用丹参',45,'400mg',5000,'2020-10-12');

/*Table structure for table `drugsort` */

CREATE TABLE `drugsort` (
  `sortNum` int(8) default NULL COMMENT '类别编号',
  `sortName` varchar(50) default NULL COMMENT '类别名称',
  KEY `FK_drugsort_drugmessage` (`sortNum`),
  CONSTRAINT `FK_drugsort_drugmessage` FOREIGN KEY (`sortNum`) REFERENCES `drugmessage` (`drugNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='药品类别表';

/*Data for the table `drugsort` */

insert  into `drugsort`(`sortNum`,`sortName`) values (1001,'感冒药'),(1003,'炎症'),(1006,'消化药'),(1002,'重症药'),(1004,'重症药'),(1005,'重症药'),(1013,'重症药'),(1012,'重症药'),(1007,'重症药'),(1008,'感冒药'),(1011,'感冒药'),(1009,'胃药');

/*Table structure for table `drugstorage` */

CREATE TABLE `drugstorage` (
  `houseId` int(4) default NULL COMMENT '库/房',
  `hospital` int(4) default NULL COMMENT '医院',
  `staffNum` int(8) NOT NULL COMMENT '员工编号（管理员）',
  `drugStorage` varchar(50) default NULL COMMENT '药库/房名称',
  PRIMARY KEY  (`staffNum`),
  CONSTRAINT `FK_drugstorage_hospitalstaff` FOREIGN KEY (`staffNum`) REFERENCES `hospitalstaff` (`staffNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='药库/房表';

/*Data for the table `drugstorage` */

insert  into `drugstorage`(`houseId`,`hospital`,`staffNum`,`drugStorage`) values (1,1,1,'中心药房'),(2,2,2,'门诊药房'),(3,3,3,'住院药房');

/*Table structure for table `feesdetails` */

CREATE TABLE `feesdetails` (
  `ID` int(4) default NULL COMMENT '收费项目',
  `drugNum` varchar(10) collate utf8_unicode_ci default NULL COMMENT '药品编号',
  `amount` float default NULL COMMENT '数量',
  `total` float default NULL COMMENT '小计',
  KEY `FK_feesdetails_payitems` (`ID`),
  CONSTRAINT `FK_feesdetails_payitems` FOREIGN KEY (`ID`) REFERENCES `payitems` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='收费详情表';

/*Data for the table `feesdetails` */

insert  into `feesdetails`(`ID`,`drugNum`,`amount`,`total`) values (1,'001',10,100),(2,'002',10,150),(3,'006',15,10000),(4,'010',200,500000),(5,'004',20,10000),(6,'009',40,80000);

/*Table structure for table `hospitalmessage` */

CREATE TABLE `hospitalmessage` (
  `hospitalId` int(8) NOT NULL COMMENT '医院ID',
  `hospitalName` varchar(20) default NULL COMMENT '名称',
  `hospitalHome` varchar(20) default NULL COMMENT '地址',
  `hospitalBoss` varchar(20) default NULL COMMENT '院长',
  `rank` int(4) default NULL COMMENT '等级',
  `hospitalTelphone` varchar(20) default NULL COMMENT '联系电话',
  PRIMARY KEY  (`hospitalId`),
  CONSTRAINT `FK_hospitalmessage_hospitalstaff` FOREIGN KEY (`hospitalId`) REFERENCES `hospitalstaff` (`hospitalId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='医院信息表';

/*Data for the table `hospitalmessage` */

insert  into `hospitalmessage`(`hospitalId`,`hospitalName`,`hospitalHome`,`hospitalBoss`,`rank`,`hospitalTelphone`) values (110,'好再来医院','西安市友谊路11号','刘涛',5,'010-254621');

/*Table structure for table `hospitalstaff` */

CREATE TABLE `hospitalstaff` (
  `staffNum` int(8) NOT NULL COMMENT '员工编号',
  `hospitalId` int(8) NOT NULL COMMENT '医院ID',
  `postNum` int(8) NOT NULL COMMENT '职位编号',
  `section` int(8) NOT NULL COMMENT '科室编号',
  `staffName` varchar(50) default NULL COMMENT '姓名',
  `staffSex` varchar(50) default NULL COMMENT '性别',
  `staffAge` int(4) default NULL COMMENT '年龄',
  `birth` date default NULL COMMENT '出生日期',
  `staffHome` varchar(50) default NULL COMMENT '家庭住址',
  `fixedTelephone` varchar(50) default NULL COMMENT '固定电话',
  `moveTelephone` varchar(50) default NULL COMMENT '移动电话',
  PRIMARY KEY  (`staffNum`,`hospitalId`,`postNum`,`section`),
  KEY `FK_hospitalstaff_section` (`section`),
  KEY `FK_hospitalstaff_post` (`postNum`),
  KEY `FK_hospitalstaff_hospitalmessage` (`hospitalId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='医院员工信息表';

/*Data for the table `hospitalstaff` */

insert  into `hospitalstaff`(`staffNum`,`hospitalId`,`postNum`,`section`,`staffName`,`staffSex`,`staffAge`,`birth`,`staffHome`,`fixedTelephone`,`moveTelephone`) values (1,110,1,401,'刘涛','男',50,'2012-09-12','北京市房山','010-254621','13456666666'),(2,110,2,401,'李梅','女',48,'2008-05-20','江苏','025-154314','15486864566'),(3,110,3,401,'郑国强','男',65,'2010-03-20','辽宁省沈阳市','038-215435','18932658524'),(4,110,4,402,'王珂','女',49,'2009-12-15','河北省唐山市','049-214624','17532689742'),(5,110,5,402,'何德克','男',51,'1984-06-13','山东省青岛市','030-212354','15325489654'),(6,110,6,402,'吴大海','男',62,'1973-07-13','江苏省南京市','028-445123','17926512574');

/*Table structure for table `loginmessage` */

CREATE TABLE `loginmessage` (
  `number` int(8) default NULL COMMENT '编号',
  `userNum` int(8) NOT NULL COMMENT '用户编号',
  `online` date default NULL COMMENT '上线时间',
  PRIMARY KEY  (`userNum`),
  CONSTRAINT `FK_loginmessage_loginuser` FOREIGN KEY (`userNum`) REFERENCES `loginuser` (`userNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录详情表';

/*Data for the table `loginmessage` */

insert  into `loginmessage`(`number`,`userNum`,`online`) values (1,1,'2020-10-13'),(2,2,'2020-10-15'),(3,3,'2020-10-01'),(4,4,'2020-10-28'),(5,5,'2020-10-27'),(6,6,'2020-10-28');

/*Table structure for table `loginuser` */

CREATE TABLE `loginuser` (
  `userNum` int(8) NOT NULL COMMENT '用户编号',
  `staffNum` int(8) default NULL COMMENT '员工编号',
  `userName` varchar(50) collate utf8_unicode_ci default NULL COMMENT '用户名',
  `pwd` varchar(50) collate utf8_unicode_ci default NULL COMMENT '密码',
  `power` int(4) default NULL COMMENT '权限',
  PRIMARY KEY  (`userNum`),
  KEY `FK_loginuser_hospitalstaff` (`staffNum`),
  CONSTRAINT `FK_loginuser_hospitalstaff` FOREIGN KEY (`staffNum`) REFERENCES `hospitalstaff` (`staffNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `loginuser` */

insert  into `loginuser`(`userNum`,`staffNum`,`userName`,`pwd`,`power`) values (1,1,'刘涛','123',1),(2,2,'李梅','456',2),(3,3,'郑国强','789',2),(4,4,'王珂','147',3),(5,5,'何德克','258',3),(6,6,'吴大海','369',3);

/*Table structure for table `payitems` */

CREATE TABLE `payitems` (
  `ID` int(4) NOT NULL auto_increment COMMENT '收费项目编号',
  `payName` char(6) default NULL COMMENT '收费名称',
  `sickNum` int(8) NOT NULL COMMENT '挂号编号（病人编号）',
  `payDate` date default NULL COMMENT '收费日期',
  `payPeople` varchar(20) default NULL COMMENT '收费人',
  `cost` float default NULL COMMENT '费用',
  PRIMARY KEY  (`ID`,`sickNum`),
  KEY `FK_payItems_sickMessage` (`sickNum`),
  CONSTRAINT `FK_payItems_sickMessage` FOREIGN KEY (`sickNum`) REFERENCES `sickmessage` (`sickNum`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='收费项目表';

/*Data for the table `payitems` */

insert  into `payitems`(`ID`,`payName`,`sickNum`,`payDate`,`payPeople`,`cost`) values (1,'流感',1,'2020-11-01','王语嫣',108),(2,'包扎伤口',2,'2020-11-11','王语嫣',200),(3,'骨折手术',3,'2021-08-12','刘美倩',10236),(4,'心脏搭桥',4,'2021-07-15','刘美倩',502360),(5,'小儿麻痹',5,'2023-10-13','周芷梦',10352),(6,'肿瘤',6,'2021-05-26','韩映岚',NULL);

/*Table structure for table `post` */

CREATE TABLE `post` (
  `postNum` int(8) NOT NULL COMMENT '职位编号',
  `postName` char(4) default NULL COMMENT '职称',
  PRIMARY KEY  (`postNum`),
  CONSTRAINT `FK_post_hospitalstaff` FOREIGN KEY (`postNum`) REFERENCES `hospitalstaff` (`postNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='职位表';

/*Data for the table `post` */

insert  into `post`(`postNum`,`postName`) values (1,'院长'),(2,'副院长'),(3,'专家'),(4,'主治医师'),(5,'医生'),(6,NULL);

/*Table structure for table `registeredtype` */

CREATE TABLE `registeredtype` (
  `registeredType` int(8) NOT NULL auto_increment COMMENT '类型编号',
  `type` varchar(20) default NULL COMMENT '类型',
  `price` float default NULL COMMENT '价钱',
  PRIMARY KEY  (`registeredType`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='挂号类型表';

/*Data for the table `registeredtype` */

insert  into `registeredtype`(`registeredType`,`type`,`price`) values (1,'感冒',8),(2,'门诊',8),(3,'急诊',30),(4,'儿科',18),(5,'鼻科',18),(6,'心脏科',58),(7,'骨科',48),(8,'胸腔科',38);

/*Table structure for table `returncrgo` */

CREATE TABLE `returncrgo` (
  `returnId` int(8) NOT NULL auto_increment COMMENT '退货单ID',
  `hospitalId` int(8) default NULL COMMENT '医院ID',
  `drugNum` int(8) NOT NULL COMMENT '药品编号',
  `returnPrice` float default NULL COMMENT '退货单价',
  `returnNumber` int(4) default NULL COMMENT '退货数量',
  `unitNum` int(4) default NULL COMMENT '单位编号',
  `returnReason` varchar(50) default NULL COMMENT '原因',
  `returnDate` date default NULL COMMENT '退货日期',
  PRIMARY KEY  (`drugNum`),
  KEY `returnId` (`returnId`),
  CONSTRAINT `FK_returncrgo_drugmessage` FOREIGN KEY (`drugNum`) REFERENCES `drugmessage` (`drugNum`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='退货单表';

/*Data for the table `returncrgo` */

insert  into `returncrgo`(`returnId`,`hospitalId`,`drugNum`,`returnPrice`,`returnNumber`,`unitNum`,`returnReason`,`returnDate`) values (1,110,1001,15,100,3306,'包装损坏','2020-10-13');

/*Table structure for table `section` */

CREATE TABLE `section` (
  `section` int(8) NOT NULL COMMENT '科室编号',
  `sectionType` char(4) default NULL COMMENT '科室类型',
  PRIMARY KEY  (`section`),
  CONSTRAINT `FK_section_hospitalstaff` FOREIGN KEY (`section`) REFERENCES `hospitalstaff` (`section`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科室表';

/*Data for the table `section` */

insert  into `section`(`section`,`sectionType`) values (401,'院领导'),(402,'专家科室');

/*Table structure for table `sickbednum` */

CREATE TABLE `sickbednum` (
  `sickBedNum` int(8) NOT NULL COMMENT '病床编号',
  `sickBedCode` varchar(50) default NULL COMMENT '病床代号',
  `occupy` int(4) default NULL COMMENT '是否被占用',
  PRIMARY KEY  (`sickBedNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='病床表';

/*Data for the table `sickbednum` */

insert  into `sickbednum`(`sickBedNum`,`sickBedCode`,`occupy`) values (101,'感冒',1),(102,'骨折',1),(107,'重症',1),(111,'重症',1),(121,'重症',1),(131,'重症',1);

/*Table structure for table `sickhospitalmessage` */

CREATE TABLE `sickhospitalmessage` (
  `hospitalId` int(8) default NULL COMMENT '医院ID',
  `sickNum` int(8) default NULL COMMENT '病人编号',
  `sickBedNum` int(8) NOT NULL COMMENT '病床编号',
  `doctorNum` int(8) default NULL COMMENT '医生编号',
  `nurseNum` int(8) default NULL COMMENT '护士编号',
  `sickName` char(8) default NULL COMMENT '姓名',
  `sickSex` char(2) default '男' COMMENT '性别',
  `sickAge` int(4) default NULL COMMENT '年龄',
  `beHospital` date default NULL COMMENT '入院日期',
  `leaveHospital` date default NULL COMMENT '出院日期',
  `sickHome` varchar(50) default NULL COMMENT '家庭住址',
  `contact` varchar(50) default NULL COMMENT '联系方式',
  `bondsman` char(4) default NULL COMMENT '担保人',
  `leaveHospitalSay` varchar(50) default NULL COMMENT '出院结论',
  `cash` float default NULL COMMENT '押金',
  PRIMARY KEY  (`sickBedNum`),
  KEY `FK_sickhospitalmessage_payitems` (`sickNum`),
  CONSTRAINT `FK_sickhospitalmessage_payitems` FOREIGN KEY (`sickNum`) REFERENCES `payitems` (`sickNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='住院病人基本信息表';

/*Data for the table `sickhospitalmessage` */

insert  into `sickhospitalmessage`(`hospitalId`,`sickNum`,`sickBedNum`,`doctorNum`,`nurseNum`,`sickName`,`sickSex`,`sickAge`,`beHospital`,`leaveHospital`,`sickHome`,`contact`,`bondsman`,`leaveHospitalSay`,`cash`) values (110,3,101,202,303,'葛二蛋','男',26,'2020-10-15','2021-09-23','云南省昆明','13466554865','李江','已完全恢复',10000),(110,1,102,201,306,'陈真','男',28,'2020-10-13','2021-01-01','北京市四平','17849600821','榛子单','已完全恢复',100),(110,4,107,204,305,'秀琴','女',32,'2020-10-28','2022-05-11','山西省平安县','18465254653','李运龙','已完全恢复',20000),(110,2,111,203,301,'吴刚','男',42,'2020-10-12','2021-03-17','辽宁省铁岭','15651325689','赵大山','已完全恢复',200),(110,5,121,206,307,'卓别林','男',45,'2020-10-26','2021-07-15','新疆省维吾尔族','135464856548','杰森','已完全恢复',10000),(110,6,131,211,311,'马嘉诚','女',76,'2020-10-27','2022-04-14','香港九龙','132146564854','章国荣','已完全恢复',20000);

/*Table structure for table `sickmessage` */

CREATE TABLE `sickmessage` (
  `sickNum` int(8) NOT NULL auto_increment COMMENT '挂号编号',
  `hospitalId` int(10) default NULL COMMENT '医院ID',
  `registeredType` int(8) default NULL COMMENT '挂号类型',
  `sickName` varchar(50) default NULL COMMENT '姓名',
  `sickSex` char(2) default '男' COMMENT '性别',
  `sickAge` int(4) default NULL COMMENT '年龄',
  `registeredDate` date default NULL COMMENT '挂号日期',
  `registeredNum` int(8) default NULL COMMENT '挂号人编号',
  PRIMARY KEY  (`sickNum`),
  KEY `FK_sickMessage_registeredtype` (`registeredType`),
  CONSTRAINT `FK_sickMessage_registeredtype` FOREIGN KEY (`registeredType`) REFERENCES `registeredtype` (`registeredType`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='病人基本信息表';

/*Data for the table `sickmessage` */

insert  into `sickmessage`(`sickNum`,`hospitalId`,`registeredType`,`sickName`,`sickSex`,`sickAge`,`registeredDate`,`registeredNum`) values (1,110,1,'陈真','男',28,'2020-10-13',1),(2,110,3,'吴刚','男',42,'2020-10-12',2),(3,110,7,'葛二蛋','男',26,'2020-10-15',3),(4,110,6,'秀琴','女',32,'2020-10-28',4),(5,110,4,'卓别林','男',45,'2020-10-26',5),(6,110,8,'马嘉诚','女',76,'2020-10-27',6);

/*Table structure for table `sickroommessage` */

CREATE TABLE `sickroommessage` (
  `hospitalId` int(8) default NULL COMMENT '医院ID',
  `sickBedNum` int(8) default NULL COMMENT '病房编号',
  `section` int(8) NOT NULL COMMENT '科室编号',
  `sickRoomBedNum` int(4) default NULL COMMENT '病房病床数',
  `residueBedNum` int(4) default NULL COMMENT '剩余病床数',
  `price` float default NULL COMMENT '价位',
  PRIMARY KEY  (`section`),
  KEY `FK_sickroommessage_sickbednum` (`sickBedNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='病房信息表';

insert  into `sickroommessage`(`hospitalId`,`sickBedNum`,`section`,`sickRoomBedNum`,`residueBedNum`,`price`) values (110,101,401,6,4,10),(110,102,405,6,4,10),(110,111,411,6,5,30),(110,107,412,6,5,20),(110,131,414,6,5,50),(110,121,416,6,5,30);
实现效果：
在这里插入图片描述
在这里插入图片描述
以上均为个人所写，如有错误，欢迎指正，谢谢！
新时代的农民工
关注
0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
java—Web（项目）—数据库（插入数据）

实现代码：CREATE TABLE `allot` ( `allotId` int(8) default NULL COMMENT 'ID', `hospitalId` int(4) default NULL COMMENT '医院ID', `originNum` date default NULL COMMENT '起点库房编号', `endNum` float default NULL COMMENT '终点库房编号', `drugNum` int(8) NOT NULL COMM
复制链接

扫一扫