java 项目源码 微信小程序的智慧医疗系统 医院 智能医疗 ssm jsp【项目源码+数据库脚本+项目说明+软件工具】毕设

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50639 Source Host : localhost:3306 Source Schema : hospital_order_db Target Server Type : MySQL Target Server Version : 50639 File Encoding : 65001 Date: 20/04/2021 14:39:06 */ drop database if exists hospital_order_db; create database hospital_order_db charset utf8; use hospital_order_db; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(32) DEFAULT NULL, PRIMARY KEY (`username`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of admin -- ---------------------------- BEGIN; INSERT INTO `admin` VALUES ('admin', 'admin'); COMMIT; -- ---------------------------- -- Table structure for t_department -- ---------------------------- DROP TABLE IF EXISTS `t_department`; CREATE TABLE `t_department` ( `departmentId` int(11) NOT NULL AUTO_INCREMENT COMMENT '科室id', `departmentName` varchar(20) NOT NULL COMMENT '科室名称', `departmentDesc` varchar(5000) DEFAULT NULL COMMENT '科室介绍', `birthDate` varchar(20) DEFAULT NULL COMMENT '成立日期', `chargeMan` varchar(20) DEFAULT NULL COMMENT '负责人', PRIMARY KEY (`departmentId`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of t_department -- ---------------------------- BEGIN; INSERT INTO `t_department` VALUES (1, '肝胆外科', '主要检查和治疗肝胆内脏疾病信息', '2021-11-02', '王晓婷'); INSERT INTO `t_department` VALUES (2, '消化内科', '消化内科各种疾病诊治', '2021-11-10', '李明德'); INSERT INTO `t_department` VALUES (3, '妇科', '妇科', '2021-10-19', '张小军'); INSERT INTO `t_department` VALUES (4, '耳鼻喉科', '耳鼻喉科', '2021-10-20', '谢洛'); COMMIT; -- ---------------------------- -- Table structure for t_doctor -- ---------------------------- DROP TABLE IF EXISTS `t_doctor`; CREATE TABLE `t_doctor` ( `doctorNumber` varchar(20) NOT NULL COMMENT 'doctorNumber', `password` varchar(20) DEFAULT NULL COMMENT '登录密码', `departmentObj` int(11) NOT NULL COMMENT '所在科室', `doctorName` varchar(20) NOT NULL COMMENT '医生姓名', `sex` varchar(4) NOT NULL COMMENT '性别', `doctorPhoto` varchar(60) NOT NULL COMMENT '医生照片', `birthDate` varchar(20) DEFAULT NULL COMMENT '出生日期', `position` varchar(20) NOT NULL COMMENT '医生职位', `experience` varchar(20) NOT NULL COMMENT '工作经验', `contactWay` varchar(20) DEFAULT NULL COMMENT '联系方式', `goodAt` varchar(200) DEFAULT NULL COMMENT '擅长', `doctorDesc` varchar(8000) NOT NULL COMMENT '医生介绍', PRIMARY KEY (`doctorNumber`) USING BTREE, KEY `departmentObj` (`departmentObj`) USING BTREE, CONSTRAINT `t_doctor_ibfk_1` FOREIGN KEY (`departmentObj`) REFERENCES `t_department` (`departmentId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of t_doctor -- ---------------------------- BEGIN; INSERT INTO `t_doctor` VALUES ('YS001', '123', 1, '王大山', '男', 'upload/aeb68b75-55a7-4c36-ab1a-fef3cd8fec16.jpg', '2021-10-19', '主任医师', '8年', '13508310123', '肝胆外科', '多年肝胆疾病临床经验，擅长各种肝病的治疗和胆结石的微创治疗！'); INSERT INTO `t_doctor` VALUES ('YS002', '123', 2, '张晓娜', '女', 'upload/a2cc71fb-2a1f-44dd-80d0-8dd5c14b395b.jpg', '2021-11-09', '一级专家', '5年', '13058021083', '内科', '5年临床经验，擅长各种内科疾病的诊治'); INSERT INTO `t_doctor` VALUES ('YS003', '123', 1, '李晓涛', '男', 'upload/f62b9193-f0e4-4398-b28c-3a187b135671.jpg', '2021-11-16', '二级专家', '6年', '13508021023', '慢性肝病和胆结石', '多年经验，丰富呢！'); COMMIT; -- ---------------------------- -- Table structure for t_leaveword -- ---------------------------- DROP TABLE IF EXISTS `t_leaveword`; CREATE TABLE `t_leaveword` ( `leaveWordId` int(11) NOT NULL AUTO_INCREMENT COMMENT '留言id', `leaveTitle` varchar(80) NOT NULL COMMENT '留言标题', `leaveContent` varchar(2000) NOT NULL COMMENT '留言内容', `userObj` varchar(30) NOT NULL COMMENT '留言人', `leaveTime` varchar(20) DEFAULT NULL COMMENT '留言时间', `replyContent` varchar(1000) DEFAULT NULL COMMENT '管理回复', `replyTime` varchar(20) DEFAULT NULL COMMENT '回复时间', PRIMARY KEY (`leaveWordId`) USING BTREE, KEY `userObj` (`userObj`) USING BTREE, CONSTRAINT `t_leaveword_ibfk_1` FOREIGN KEY (`userObj`) REFERENCES `t_userinfo` (`user_name`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of t_leaveword -- ---------------------------- BEGIN; INSERT INTO `t_leaveword` VALUES (1, '肚子一直疼，怎么办', '肚子一直疼，怎么办', '13508123423', '2021-11-18 19:45:15', '赶紧去医院吧', '2021-11-18 19:45:16'); INSERT INTO `t_leaveword` VALUES (2, '我想看胃病', '我的胃不太舒服！', '13649023423', '2021-11-19 19:27:06', '可以找医生看吧', '2021-11-19 19:44:05'); INSERT INTO `t_leaveword` VALUES (3, '可以帮家人挂号吗', '我家人要是不舒服可以挂号吗？', '13649023423', '2021-11-19 19:27:34', '--', '--'); COMMIT; -- ---------------------------- -- Table structure for t_news -- ---------------------------- DROP TABLE IF EXISTS `t_news`; CREATE TABLE `t_news` ( `newsId` int(11) NOT NULL AUTO_INCREMENT COMMENT '新闻id', `newsTitle` varchar(100) NOT NULL COMMENT '新闻标题', `newsPhoto` varchar(60) NOT NULL COMMENT '新闻图片', `newsContent` varchar(8000) NOT NULL COMMENT '新闻内容', `newsDate` varchar(20) DEFAULT NULL COMMENT '新闻日期', `newsFrom` varchar(30) DEFAULT NULL COMMENT '新闻来源', PRIMARY KEY (`newsId`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of t_news -- ---------------------------- BEGIN; INSERT INTO `t_news` VALUES (1, '医院预约小程序上线了', 'upload/d5e5050d-28b8-4d96-8960-91ca2d4db365.jpg', '朋友们以后可以通过这个平台预约医生了！', '2021-11-18', '官方'); INSERT INTO `t_news` VALUES (2, '小程序预约更方便', 'upload/eaf51e5b-ab34-47d2-989a-ed2eb11fd12f.jpg', '只要有微信就能关注我们小程序，预约看病更方便', '2021-11-16', '医院官方'); COMMIT; -- ---------------------------- -- Table structure for t_orderinfo -- ---------------------------- DROP TABLE IF EXISTS `t_orderinfo`; CREATE TABLE `t_orderinfo` ( `orderId` int(11) NOT NULL AUTO_INCREMENT COMMENT '预约id', `userObj` varchar(30) NOT NULL COMMENT '预约用户', `doctorObj` varchar(20) NOT NULL COMMENT '预约医生', `orderDate` varchar(20) DEFAULT NULL COMMENT '预约日期', `timeInterval` varchar(20) NOT NULL COMMENT '时段', `telephone` varchar(20) NOT NULL COMMENT '联系电话', `orderTime` varchar(20) DEFAULT NULL COMMENT '下单时间', `checkState` varchar(20) NOT NULL COMMENT '处理状态', `replyContent` varchar(800) NOT NULL COMMENT '医生回复', PRIMARY KEY (`orderId`) USING BTREE, KEY `userObj` (`userObj`) USING BTREE, KEY `doctorObj` (`doctorObj`) USING BTREE, CONSTRAINT `t_orderinfo_ibfk_1` FOREIGN KEY (`userObj`) REFERENCES `t_userinfo` (`user_name`), CONSTRAINT `t_orderinfo_ibfk_2` FOREIGN KEY (`doctorObj`) REFERENCES `t_doctor` (`doctorNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of t_orderinfo -- ---------------------------- BEGIN; INSERT INTO `t_orderinfo` VALUES (1, '13508123423', 'YS001', '2