Note

Please note that all files have been built and run in my local environment. You may need to make adjustments for your specific environment.

Hospital Management System

Hospital Management System having The Functionalities Like Patient login/signup, Admin login, Doctor Registration, Book Appointments and Store data in MySQL Database.

Prerequisite

To Run or Build Project In Your Local System you need some Pre requisite platforms which download links also given Below

Technologies and Platforms

S.no	Technology	Platform	Download Link
1	Java	Eclipse For Java Developer	Link
2	SQL	MySQL 8.0	Link

Java Packages Used

1. java.sql.Connection:- is used for Establishing Connection,Executing SQL Statements or commands against the database and Transaction Management
2. java.sql.DriverManager:- is used for class that manages a list of database drivers. It is part of the Java Database Connectivity (JDBC) API, which provides a standard interface for connecting to and interacting with databases.
3. java.sql.PreparedStatement:- This class represents a precompiled SQL statement. It extends the java.sql.Statement interface and is used to execute parameterized SQL queries against a database. PreparedStatement objects are preferred over Statement objects when you need to execute the same SQL statement multiple times with different parameters, as they provide better performance and security through parameterized queries.
4. java.sql.ResultSet:- This interface represents the result set of a database query. It provides methods for traversing the rows of the result set, accessing column values, and performing various operations on the data retrieved from the database. ResultSet objects are typically obtained by executing SQL queries using Statement or PreparedStatement objects.
5. java.util.Scanner:- This class is used for parsing primitive types and strings from input streams (including text files, network connections, and other input sources) using regular expressions.

Database

To Build with project we need to create Several tables in the MySQL Database to Store the Data and need to reuse According to the needs for the user/developer.

Here are the tables and Schema of the Tables

For Admin Table	For Patients Table
Field Type Null Key Default Extra id int YES NULL password varchar(255) YES NULL	Field Type Null Key Default Extra id int YES NULL name varchar(255) YES NULL phonenumber bigint YES NULL password varchar(255) YES NULL

For Appointments Table	For Doctor Table
Field Type Null Key Default Extra id int YES NULL name varchar(255) YES NULL phonenumber bigint YES NULL Mail varchar(255) YES NULL ap_date date YES NULL catgroy varchar(255) YES NULL	Field Type Null Key Default Extra id int YES NULL doctor_name varchar(255) YES NULL phonenumber bigint YES NULL mail varchar(255) YES NULL spc varchar(255) YES NULL password varchar(255) YES NULL

The Output of the Program will be