UMS-Java

A comprehensive Java-based software solution designed to streamline and automate various administrative tasks, academic processes, and student management within a university.

JAVA Project Note

1. Java project name is University Management System
2. All Java source files in package name = ’university.management.system’.
3. Start Page of the Application – main.java
4. All the Images are in Icons folder.
5. Import all Jar files in Libraries which is
   1. mysql-connector-java-8.0.28.jar – Official JDBC Driver for Mysql.
   2. jcalendar-tz-1.3.3-4.jar – Java Date chooser bean for graphically picking a date.
   3. rx2xml.jar - display the data in a table format.

MYSQL Note

If you are developing this same, then first create these all of the tables with the same table, column name which is visible in the below tables. Run all of the queries in Mysql workbench SQL Queries

1. use universitymanagementsystem;

2. show tables;

3. select * from collegefee;

4. select * from fee;

5. select * from login;

6. select * from marks;

7. select * from student;

8. select * from studentleave;

9. select * from subject;

10. select * from teacher;

11. select * from teacherleave;

NOTE (Database, Tables):

NOTE (Database): Firstly, I have created the database of name universitymanagementsystem

NOTE (All Table’s except login and fee): Here, in all of the table’s data is inserted by using the Application not by inserting the data directly into the database by using queries.

NOTE (login table): For the login table username and password, I have inserted the user data by running queries in the database because I have not created any separate page for User-login.

NOTE (fee table): For the fee table, I have inserted the fee Details in the respective course in database by running queries.

NOTE (JDBC Connection):

("jdbc:mysql://localhost:3306/universitymanagementsystem", "USERNAME","PASSWORD")

1. I have used MYSQL Workbench Application for the Database. In MYSQL Workbench, by default the port number is 3306, So I have used their port no. 3306 for JDBC Connection. And I have used LocalHost.
2. Database Username = ‘USERNAME’.
3. Database Password = ‘PASSWORD’.
4. If anything is different in your case, then you have to change all of different data’s in conn.java class respectively.

Recommendation:
1. Install MYSQL Workbench by using the MYSQL installer- Community, so that server will install and other important things.
MYSQL installer- Community download link - Click Here
2. Install Apache Netbeans for the application development.
Apache NetBeans download link - Click here

Project Images

This main page will only start for 5 sec. After 5 sec it will close and open login page.

Then entering the value of username and password, then clicking submit If matches then it will open Home Page of UMS, if not matches then it will return a popup of Username or password invalid.

In Home page

Menubars are there

All Menubars are


The EXIT button will will close the application