Skip to content

This application is developed using java with maven help with clean ui/ux with backed implementation.

License

Notifications You must be signed in to change notification settings

Royal-Code-Master/College-Management-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 

Repository files navigation

College-Management-System

This application is developed using java with maven help with clean ui/ux with backed implementation.

features:

1.Admin and Student Access.

2.Preventing the direct Access of Web Pages.

3.Session Management.

4.Uploading Students Results.

5.Searching the Student Result using Roll number.

6.Delete and Update Student

Author

Royal-Code-Master

SQL Tables

  1. Database name Student

  2. admins table

  3. student table

  4. results table

  5. . messages table

Admins Table

CREATE TABLE admins ( id INT NOT NULL AUTO_INCREMENT, fullname VARCHAR(30) NOT NULL, email VARCHAR(30) NOT NULL, passwords VARCHAR(30) NOT NULL, PRIMARY KEY (id) );

student table

CREATE TABLE student ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, roll INT NOT NULL UNIQUE, fullname VARCHAR(30) NOT NULL, branch VARCHAR(15) NOT NULL, email VARCHAR(30) );

results table

CREATE TABLE results ( roll INT NOT NULL, subject1 INT NOT NULL, subject2 INT NOT NULL, subject3 INT NOT NULL, total INT NOT NULL, status VARCHAR(10) NOT NULL, PRIMARY KEY (roll) );

ALTER TABLE results ADD CONSTRAINT fk_results_student FOREIGN KEY (roll) REFERENCES student(roll) ON DELETE CASCADE;

messages table

CREATE TABLE messages ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, user_email VARCHAR(30) NOT NULL, user_phone VARCHAR(12) NOT NULL, user_msg TEXT NOT NULL );

Clone Project using Git CLI

gh repo clone Royal-Code-Master/College-Management-System

Results of Project

I want to show the project results using images.

This is Home Page

Screenshot 2023-09-08 110613

Admin Pages

Screenshot (84)

Screenshot (85)

Screenshot (86)

Screenshot (87)

Screenshot (88)

Screenshot (89)

Screenshot (92)

Student Pages

Screenshot (90)

Screenshot (91)

Results Page

Screenshot (93)

messages page.

Screenshot 2023-09-04 102831

Screenshot (94)

About

This application is developed using java with maven help with clean ui/ux with backed implementation.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published