Library Management System

A comprehensive desktop application designed to streamline the management of library resources. Built with Java Swing and MySQL, this system handles book inventory, student records, and the entire circulation process (issuing and returning books) with an intuitive graphical user interface.

🚀 Features

• Admin Dashboard: Centralized control panel for quick navigation.
• Secure Login: Authentication system for administrators.
• Book Management:
  • Add Books: Register new books with details (ID, Category, Name, Author, Copies).
  • Stock Tracking: View real-time availability of books.
• Student Management:
  • Registration: Add new students to the system.
  • Records: View student details, contact info, and borrowing history.
• Circulation System:
  • Issue Book: Assign books to students with automatic date tracking.
  • Return Book: Process returns and automatically update inventory counts.
  • Smart Validation: Prevents issuing out-of-stock books or incorrect returns.

🛠️ Technology Stack

• Language: Java (JDK 24)
• GUI Framework: Java Swing
• Database: MySQL 8.0
• IDE: NetBeans (Recommended)

⚙️ Setup & Installation

1. Database Configuration

1. Ensure MySQL Server is installed and running.
2. Create a database named library2.
3. Import the schema file located at databaseOfLibrary/library2.sql.

   mysql -u root -p library2 < databaseOfLibrary/library2.sql

4. Update the database credentials in src/db.properties if your configuration differs:

   db.url=jdbc:mysql://localhost:3306/library2
   db.user=root
   db.password=YOUR_PASSWORD

2. Dependencies

Ensure the following JAR files (included in the lib/ folder) are in your classpath:

• mysql-connector-j-9.4.0.jar (MySQL Driver)
• jcalendar-1.4.jar (Date Chooser)
• RojeruSan.parte1.jar (UI Components)
• RSCalendar.jar

3. Running the Applicaton

Using NetBeans (Recommended):

1. Open the project in NetBeans.
2. Right-click the project name > Properties > Libraries to verify the JAR paths are correct.
3. Right-click > Clean and Build.
4. Run the project. The entry point is Loading1.java.

Using Command Line:

# Compile
javac -cp "lib/*;src" -d build/classes src/*.java

# Run
java -cp "lib/*;build/classes" Loading1

📂 Project Structure

• src/: Contains all Java source code and Swing forms.
• lib/: Contains external JAR libraries required for the project.
• databaseOfLibrary/: Contains the library2.sql database dump file.
• icon/ & image/: Resources for UI assets.

👤 Author

Ram Baranwal