🧠 Smart Student & Staff Management System

A desktop-based management system designed to simplify academic administration for students and staff. With a clean user interface and efficient database integration, it ensures seamless record management and accessibility.

---

🌟 Core Features

🔸 CRUD Operations 📊 – Add, Update, Delete & View records effortlessly
🔸 Seamless Database Integration ⚡ – Real-time data handling with MySQL

---

🛠 Tech Stack

🔹 Java – Core backend logic
🔹 Eclipse WindowBuilder – UI design with a drag-and-drop approach
🔹 JDBC – Smooth database connectivity
🔹 MySQL – Secure and scalable data management

---

🚀 Getting Started

✅ Prerequisites

• Java JDK 8 or higher
• MySQL Server installed and running
• Eclipse IDE (with WindowBuilder plugin)

🧩 Installation Steps

1. Clone the Repository

   git clone https://github.com/ArjunPatil15/Smart-Student-Staff-Management-System-.git

2. Open the Project in Eclipse

   • Use Eclipse IDE with WindowBuilder plugin enabled.
   • Import as a Java Project.

3. Configure MySQL Database

   • Import the provided .sql file (located in the Database folder of the repository) into your MySQL server.
   • Update your database connection details (username, password, database name, and URL) within the Java source code. This configuration is typically found in a dedicated database utility class or within the main application setup.

4. Build and Run

   • Ensure all project dependencies (like the MySQL Connector/J JAR file) are included in your project's build path. These are usually located in the lib folder.
   • Run the main application class, which typically contains the entry point for the login screen.
   • Test the login functionality with different user roles (student and staff) and verify the CRUD operations for both student and staff records.

---

📁 Project Structure

Smart-Student-Staff-Management-System/
├── src/
│   ├── student/         # Classes related to student functionalities
│   ├── staff/           # Classes related to staff functionalities
│   ├── admin/           # (Optional) Classes for administrative tasks
│   └── db/              # Classes for database interaction
├── lib/
│   └── mysql-connector-java-x.x.x.jar  # MySQL JDBC driver
└── Database/
    └── smart_mgmt.sql                  # SQL file to create the database schema

---

📄 License

This project is licensed under the MIT License – see the LICENSE file for details.
Feel free to use and modify this project according to the terms of the license.

---

🤝 Contributing

Contributions are welcome! If you'd like to contribute to this project, please follow these steps:

1. Fork the repository
2. Create a new branch for your feature or bug fix
3. Make your changes and commit them
4. Push your changes to your fork
5. Submit a pull request

Please ensure your code adheres to the project's coding standards and includes appropriate tests.

---

🙏 Acknowledgements

• This project utilizes the MySQL Connector/JDBC for database connectivity.
• The user interface was designed using Eclipse WindowBuilder.

Project Design