/TEP-medical-app

Javafx database application

Primary LanguageJava

alt title

TEP Medical Database

Table of Contents
  1. About The Project
  2. Details
  3. How to run
  4. Images

About The Project

TEP is a desktop application made to help organise and manage basic data of a medical institute or hospital. Made for admins, they can manage staff info, patients info, exams done, employee shifts, medicine given and more. They can also see statistics of the database. The application has five major segments Schedule, Patients, Staff, Examinations and Database Statistics which will be shown in more detail below.

(back to top)

Built With

(back to top)

Details

The project is a maven structured javafx application connected with a mySQL database. Database's ER model and Attribute Connections can be seen in the pdf files.

(back to top)

How to run

  • open XAMPP control panel and start Apache, mySQL and Tomcat
  • download and put javafx library one directory out of TEP
  • open TEP with any IDE (pref. IntelliJ)
  • run src/HY360/Main.java

(back to top)

Images

Login

The first thing you'll see is the login screen that has 3 fields, your database name, the database's username and password (default for mysql if you haven't set it up is username="root" and password=""). By pressing Create Tables you generate all needed database tables. To test the database you can press the Insert Values button that fills the tables with some random data.

Schedule

In this section you can manage employee shifts. The employees are referenced using their ID which can be seen at the top table first column.

(back to top)

Patients

Here you can see and update patient information, the patients are referenced with their AMKA. and also find the best doctor for each disease symptom, sending patients to the correct doctors.

(back to top)

Staff

Search Employee

Show All Staff

(back to top)

Examinations

Diseases

Medicines

Procedures

Doctor Exam Form

(back to top)

Database Statistics

Status of Visits Today

Per Date Statistics

Number of Incidents

Diseases Diagnosed

Exams Completed

(back to top)

Medicines Prescribed

Execute direct SQL Queries to the database

(back to top)