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 having The Functionalities Like Patient login/signup, Admin login, Doctor Registration, Book Appointments and Store data in MySQL Database.
To Run or Build Project In Your Local System you need some Pre requisite platforms which download links also given Below
S.no | Technology | Platform | Download Link |
---|---|---|---|
1 | Java | Eclipse For Java Developer | Link |
2 | SQL | MySQL 8.0 | Link |
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.
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.
For Admin Table | For Patients Table | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
For Appointments Table | For Doctor Table | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
The Output of the Program will be