JDBC Projects -

By Me 😎

📚 Table of Contents:

• Description
• Project Structure
• Installation
• Prerequisites
• Features
• Contact

---

📄 Description:

This repository contains multiple Java-based projects covering different functionalities such as banking management, batch processing, hospital management, hotel management, image handling, prepared statements, and transaction handling in JDBC.

---

🗂️ Project Structure

Java_JDBC_Projects
|
|---Banking_Management_System/
|                            |
|                            |---AccountManager.java
|                            |---Accounts.java
|                            |---BankingApp.java
|                            |---Read-Me-Banking-Manangement-System
|                            |---User.java
|
|---Basics_of_JDBC/
|                 |
|                 |---Basics.txt
|                 |---DeletionData.java
|                 |---InsertingData.java
|                 |---TestConnection.java
|                 |---UpdatingData.java
|
|---Batch_Processing/
|                   |
|                   |---BatchProcessing.java
|                   |---Read-Me-Batch-Processing
|
|---Hospital_Management_System/
|                             |
|                             |---Doctor.java
|                             |---HospitalManagementSystem.java
|                             |---Patient.java
|                             |---Read-Me-Hospital-Management
|
|---Hotel_Management_System/
|                          |
|                          |---HotelManagement
|                          |---HotelManagement.java
|
|---Image_Handling_JDBC/
|                      |
|                      |---Image_Handling.java
|                      |---Read-Me-Image_handling
|
|---Prepared_Statement/
|                     |
|                     |---Prepared_Statement.java
|                     |---Read-Me-Prepared-Statement
|
|---Transiction_Handling_JDBC/
                             |
                             |---Read-Me-Transictional-Handling
                             |---Transaction_Handling.java
                             

---

⚙️ Installation

Follow these steps to set up and run the project locally:

1. Clone the repository:

      git clone https://github.com/HariomSinghalPuri/Java_JDBC_Projects.git
      cd Java_JDBC_Projects

---

🚀 Prerequisites:

• Before running any of these projects, ensure you have the following installed:
• Java Development Kit (JDK) 8 or later
• MySQL or any compatible relational database
• JDBC Driver for MySQL (or the corresponding driver for your database)
• An IDE such as IntelliJ IDEA, Eclipse, or NetBeans

---

Example

✅ Customer registered: Hariom (ID: 1)  
✅ Account created for Customer ID: 101 (Account ID: 1)  
💰 Deposited $1000.00 to Account ID: 11121
💸 Withdrew $500.00 from Account ID: 1  
📊 Current Balance: $500.00  

---

✨ Features

1. Banking Management System

   • User authentication (secure login)
   • Account creation, management (CRUD operations)
   • Transaction handling (deposit, withdrawal, transfer)
   • Transaction history tracking
   • Secure password storage

2. Batch Processing

   • Execute multiple SQL queries in a single batch
   • Error handling for batch operations
   • Transaction management (commit/rollback)

3. Hospital Management System

   • Patient registration and record management
   • Doctor scheduling and appointment booking
   • Prescription and billing system

4. Hotel Management System

   • Room booking and reservation management
   • Guest check-in/check-out workflows
   • Billing and invoice generation
   • Real-time room availability tracking

5. Image Handling in JDBC

   • Store images in databases as BLOBs
   • Retrieve and display images from the database
   • Optional image compression before storage

6. Prepared Statements

   • Secure SQL execution (prevents SQL injection)
   • Performance optimization for repeated queries
   • Dynamic parameter binding in queries

7. Transaction Handling in JDBC

   • Ensures ACID properties (Atomicity, Consistency, Isolation, Durability)
   • Commit and rollback operations for data integrity
   • Handles multi-step transactions (e.g., banking transfers)

---

🤝 Contributing

Contributions are welcome! To contribute:

---

📬 Contact

GitHub: HariomSinghalPuri

Email: [email protected]

---

⭐ If you like this project, give it a star!