Git Product home page Git Product logo

college-management-system's Introduction

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)

college-management-system's People

Contributors

royal-code-master avatar

Stargazers

 avatar  avatar  avatar  avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.