Library Management System (Core Java + JDBC + MySQL)

A console-based project that helps manage books, users, and borrowing records efficiently.

Tech Stack

• Core Java (OOPs, Collections, Exception Handling)
• JDBC for database connectivity
• MySQL for data storage

Features

• Add, view, update, and delete books
• Manage users and borrowed records
• Uses PreparedStatements for secure SQL queries
• Clean modular code using OOP concepts

Learning Outcomes

• Understood how Java connects with databases via JDBC
• Learned CRUD operations and database normalization
• Improved debugging, problem-solving, and code organization skills

How to Run

1. Clone this repository
2. Configure MySQL database and update connection details in DBConnection.java
3. Compile and run Main.java in IntelliJ or any Java IDE