/hospital-management-java

Hotel Magament program made with Java, Java Swing and MySQL

Primary LanguageJava

Hospital Administration System

In order to run this project, the Database should be created with the following Query (In this project we are using MySQL)

CREATE DATABASE `hospitaladministration` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

CCREATE TABLE `patients` (
  `ID` varchar(10) NOT NULL,
  `Lastname` varchar(45) NOT NULL,
  `Name` varchar(45) NOT NULL,
  `History` longtext,
  `Gender` varchar(2) NOT NULL DEFAULT 'F',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_UNIQUE` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `users` (
  `ID` varchar(100) NOT NULL,
  `Name` varchar(45) NOT NULL,
  `Lastname` varchar(45) NOT NULL,
  `Password` varchar(45) NOT NULL,
  `Specialty` varchar(45) DEFAULT NULL,
  `Price` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_UNIQUE` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `users` VALUES ('1','Admin','Lemon','admin',NULL,0),('2','Doctor','Lemon','admin','Pediatra',1000);


CREATE TABLE `schedule` (
  `id` int NOT NULL AUTO_INCREMENT,
  `doctor` varchar(100) NOT NULL,
  `patient` varchar(100) DEFAULT NULL,
  `date` datetime NOT NULL,
  `taken` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Functionality

  • There's 2 types of Users, the Doctor and the Administrator
  • The administrator can add Doctors, add other Administrators, add Patients, Generate Reports, manage the schedule for the patients and check data
  • The Doctor can edit a patient, administrate his/her schedule and generate reports