Project Introduction
: The system is designed with three user roles: administrator, user, and doctor. Basic functional modules include doctor scheduling, online appointment registration, payment, medical record inquiry, prescription viewing, etc. Compared with other information management systems, this system has more special functions, such as department screening of doctors, medical record inquiry, etc. Users can make appointments online without queuing up to register and wait on site, which allows patients to reasonably arrange their time to come to the hospital for examination. . And patients can directly check their examination reports and other information online.
Project type: SSM source code
User type: 3 roles (Administrator + Doctor + User)
Main technologies: SSM + MySQL + Jquery
Development tools: Eclipse/Idea can be used, with two different versions
Database: MySQL
Database table: 12 tables
Table of Contents
00Complete program directory
01Admin terminal
1.0 system login
1.1 Backend home page
1.2 Data statistics module
1.3 User management module
1.4 Doctor management module
1.5 Department Management Module
1.6 Notification management module
1.7 Shift management module
1.8 Add doctor schedule
1.9 Drug Management Module
1.10 Doctor’s leave management module
02 Client
2.1 Registration inquiry
2.2 Registration management
2.3 Medical record management
2.4 Dispensing inquiry
03Doctor side
3.1 Registration acceptance
3.2 Medical record entry
3.3 Medical record management
3.4 Drug distribution
3.5 Leave application
04Project structure
05Database design
06Demo video
00 Complete program directory
01 Administrator
1.0 system login
1.1 Backstage Home Page
1.2 Data statistics module
1.3 User Management Module ?
1.4 Doctor Management Module
1.5 Department Management Module
1.6 Notification Management Module
1.7 Shift Management Module
1.8 Add doctor schedule
1.9 Drug Management Module
1.10 Doctor’s Leave Management Module
02 Client
2.1 Registration inquiry
2.2 Registration Management
2.3 Medical record management
2.4 Dispensing Query
03 Doctor’s End
3.1 Registration acceptance
3.2 Medical record entry
3.3 Medical record management
3.4 Drug Distribution
3.5 Leave application
04 Project Structure
05 Database Design
06 Demonstration Video
[Original] ssm hospital appointment registration system (complete source code)
?
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 'Medical record id', `uid` int(11) DEFAULT NULL COMMENT 'userid', `did` int(11) DEFAULT NULL COMMENT 'doctor id', `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Entry time', `describes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Condition description', `result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'diagnosis result', `treat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Treatment Opinions', `rid` int(11) DEFAULT NULL COMMENT 'outpatient appointment id', `rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Medical record number', 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 'doctor id', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'name', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'password', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Mailbox', `times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'Entry time', `job` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'position', `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'gender', `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'mobile phone', `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'avatar', `cid` int(11) DEFAULT NULL COMMENT 'Main Department', `userno` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'number', `classesid` int(11) DEFAULT NULL COMMENT 'child
Project acquisition:
https://gitee.com/sinonfin/L-javaWebSha/tree/master