Smart Hostel Management System

A console-based Java application for managing hostel operations using Java, JDBC, and MySQL.

Features

• Admin Login
• Student Management (Add, View, Search, Update, Delete)
• Room Management (Add, View, Allocate, Vacate, Update, Delete)
• Complaint Management (Register, View, Search, Update Status, Delete)
• Dashboard Statistics
• Input Validation
• MySQL Database Integration

Technologies Used

• Java
• JDBC
• MySQL
• VS Code
• Git
• GitHub

Project Structure

• src/
• lib/
• database.sql

How to Run

1. Import the project.
2. Add mysql-connector-j-8.0.33.jar to the classpath.
3. Create the smart_hostel_db database using database.sql.
4. Compile the project.
5. Run Main.java.

Sample Login

Username: admin Password: admin123

Future Improvements

• GUI using JavaFX
• Role-based authentication
• Fee Management
• Attendance Management
• Email Notifications