University Management System

About the System

The University Management System is a Java application designed to manage student and faculty data, leave requests, exam results, and fees. It features a Swing-based GUI and MySQL database using JDBC Connector. APIs like JCalendar and RS2XML are used for date handling and data export, offering an efficient solution for university administration.

For more details and to view the source code, visit:
GitHub repository

Features

Login System: Secure login interface for users to access the system.
Main Dashboard: Central hub for navigating through different functionalities.
Student Management: Add new student information, view details, and update records.
Faculty Management: Add new faculty information, view details, and update records.
Leave Management: Apply for and view leave details for both students and faculty.
Examination Management: Enter marks and view examination results.
Fee Management: View fee structure, fill out fee forms, and display paid fees.
Extras: Access to calculator, notepad, and external links such as Instagram and GitHub.

Technologies Used

Java: Core programming language for application development.
Swing: GUI toolkit for building the user interface.
MySQL: Database for storing and managing data.
JCalendar: For handling date inputs in the application.
RS2XML: For exporting data to XML format.

APIs Used

Java MySQL Connector: Provides the JDBC API to connect Java applications to MySQL databases. It allows execution of SQL queries and updates through a standard JDBC interface.
MySQL Connector/J Documentation
JCalendar: Provides a graphical calendar component for handling date input in Java Swing applications. It allows users to select dates through a user-friendly interface.
JCalendar API
RS2XML: Allows exporting and importing data in XML format using Java. It integrates with the JDBC API to convert SQL result sets into XML.
RS2XML API

Setup and Installation

1. Clone the Repository

git clone https://github.com/Kvr-10/University-Management-System.git

2. Navigate to the Project Directory

University-Management-System/out/artifacts/UniversityMs_jar/UniversityMs.jar

3. Install Dependencies

Ensure you have Java Development Kit (JDK) installed.

Add the following libraries to your project's classpath:

MySQL Connector-java.jar Download MySQL Connector
JCalendar.jar Download JCalendar
RS2XML.jar Download RS2XML

4. Database Setup

CREATE DATABASE UniversityManagement;

5. Import the SQL File

Download the UniversityManagement.sql file from the repository and import it into your MySQL database.

You can use tools like MySQL Workbench, phpMyAdmin, or command-line tools to execute the SQL script.

mysql -u username -p UniversityManagement < path/to/UniversityManagement.sql

Note: Make sure to update the username and password in the DriverManager.getConnection method within your Connectionmysql class to match your MySQL database credentials.

6. Run the Application

Compile and run the Splash class to start the application.

Initial Username: kvr10 Password: admin

Alternative

Ensure that you have created the Database UniversityManagement, and imported the UniversityManagement.sql file from the repository into your MySQL database.

You can directly download the JAR file from the Releases page and run it:

Visit Releases Download UMS Application

Contributing

I welcome contributions to improve the application! Feel free to open issues and submit pull requests.

Know More About Me

Learn more about me and my projects by visiting my main website:

Visit My Website My Portfolio