【原创】SSM医院预约挂号系统(SSM医院预约挂号系统毕业设计)

项目介绍:基于SSM的医院预约挂号系统设计3个使用角色:管理员、用户、医生。基础的功能模块包括医生排班、在线预约挂号、缴费、病历查询、配药查看等。与其他的信息管理系统相比,该系统拥有更多的特别功能,比如科室筛选医生、病历查询等,用户在线上预约,不需要现场排队挂号等待,这样可以使病人合理安排来医院检查的时间。并且病人可以在线上直接查到自己的检查报告等信息。

项目类型:SSM源码 

用户类型:3个角色(管理员+医生+用户)

主要技术:SSM+MySQL+Jquery

开发工具:Eclipse/Idea均可使用,有两个不同的版本

数据库:MySQL

数据库表:12张

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

01管理员端

1.0系统登录

1.1后台首页

1.2数据统计模块

1.3用户管理模块

1.4医生管理模块

1.5科室管理模块

1.6通知管理模块

1.7排班管理模块

1.8添加医生排班

1.9药品管理模块

1.10医生请假管理模块

02用户端

2.1 挂号查询

2.2挂号管理

2.3病历管理

2.4配药查询

03医生端

3.1挂号受理

3.2 病历录入

3.3病历管理

3.4药品分配

3.5请假申请

04项目结构

05数据库设计

 06完整的程序目录

07演示视频


01管理员端

1.0系统登录

1.1后台首页

1.2数据统计模块

1.3用户管理模块

1.4医生管理模块

1.5科室管理模块

1.6通知管理模块

1.7排班管理模块

1.8添加医生排班

1.9药品管理模块

1.10医生请假管理模块

02用户端

2.1 挂号查询

2.2挂号管理

2.3病历管理

2.4配药查询

03医生端

3.1挂号受理

3.2 病历录入

3.3病历管理

3.4药品分配

3.5请假申请

04项目结构

05数据库设计

 06完整的程序目录

07演示视频

【原创】ssm医院预约挂号系统(毕设源代码)


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for bingli
-- ----------------------------
DROP TABLE IF EXISTS `bingli`;
CREATE TABLE `bingli`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '病历id',
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `did` int(11) DEFAULT NULL COMMENT '医生id',
  `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
  `describes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '病情描述',
  `result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '诊断结果',
  `treat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '治疗意见',
  `rid` int(11) DEFAULT NULL COMMENT '门诊预约id',
  `rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '病历单号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for classes
-- ----------------------------
DROP TABLE IF EXISTS `classes`;
CREATE TABLE `classes`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `collegeid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for college
-- ----------------------------
DROP TABLE IF EXISTS `college`;
CREATE TABLE `college`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for doctor
-- ----------------------------
DROP TABLE IF EXISTS `doctor`;
CREATE TABLE `doctor`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '医生id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
  `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
  `job` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '职位',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `cid` int(11) DEFAULT NULL COMMENT '主科室',
  `userno` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编号',
  `classesid` int(11) DEFAULT NULL COMMENT '子科室',
  `jieshao` varchar(2552) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '介绍',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for medicine
-- ----------------------------
DROP TABLE IF EXISTS `medicine`;
CREATE TABLE `medicine`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '药品id',
  `mtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '药品类型',
  `mname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '药品名称',
  `price` double(10, 2) DEFAULT NULL COMMENT '价格',
  `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '介绍',
  `numbers` int(11) DEFAULT NULL COMMENT '库存',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `times` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for prescription
-- ----------------------------
DROP TABLE IF EXISTS `prescription`;
CREATE TABLE `prescription`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '配药id',
  `bid` int(255) DEFAULT NULL COMMENT '病历id',
  `mid` int(11) DEFAULT NULL COMMENT '药品id',
  `mnumber` int(11) DEFAULT NULL COMMENT '药品数量',
  `totalmoney` double(255, 0) DEFAULT NULL COMMENT '总价格',
  `uid` int(11) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qingjia
-- ----------------------------
DROP TABLE IF EXISTS `qingjia`;
CREATE TABLE `qingjia`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `did` int(11) DEFAULT NULL,
  `qdate` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `state` int(255) DEFAULT NULL,
  `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for records
-- ----------------------------
DROP TABLE IF EXISTS `records`;
CREATE TABLE `records`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '预约记录id',
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `did` int(11) DEFAULT NULL COMMENT '医生id',
  `dodate` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约日期',
  `state` int(255) DEFAULT NULL COMMENT '预约状态',
  `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '操作时间',
  `cid` int(11) DEFAULT NULL COMMENT '主科室',
  `classesid` int(11) DEFAULT NULL COMMENT '子科室',
  `shijian` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间段',
  `money` double(255, 2) DEFAULT NULL COMMENT '金额',
  `sid` int(11) DEFAULT NULL COMMENT '排班表id',
  `islr` int(255) DEFAULT NULL COMMENT '是否录入病历',
  `rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '挂号单号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for schedule
-- ----------------------------
DROP TABLE IF EXISTS `schedule`;
CREATE TABLE `schedule`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '排班id',
  `did` int(11) DEFAULT NULL COMMENT '医生id',
  `dodate` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '排班日期',
  `total` int(255) DEFAULT NULL COMMENT '总数量',
  `shijian` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间段',
  `classesid` int(11) DEFAULT NULL COMMENT '子科室',
  `cid` int(11) DEFAULT NULL COMMENT '主科室',
  `money` double(255, 2) DEFAULT NULL COMMENT '费用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
  `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '籍贯',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `userno` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
  `money` double(255, 2) DEFAULT NULL COMMENT '余额',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

  • 1
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

那条学长V

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值