Student Result Management System

This is a CLI based software where the Software is capable of maintaining and generating Student's Result at the end of a semester after the teacher's have provided the respective marks.
The following things are required in the system for the proper functioning of the software.

JAVA
JDK 17
MySQL 8

Index

Driver File
Data Flow Diagram
Software Requirement Specifications
MySQL JDBC Driver

User Manual

To properly run the software perform the following steps:
Step 1: Create a New MySQL connection and name it student_result_management_system. If the server is not in the local host or your username is not root or password is not admin, change the following things on line numbers 11, 35, 66, 102, 128:

• Change 127.0.0.1:3306 to your server ip:your server port
• Replace root with your username
• Replace admin with your password

Step 2: Write the following three Querries and execute them one by one in your querry editor.

CREATE SCHEMA `student_result_management_system` ;

CREATE TABLE `student_result_management_system`.`student_db` (
  `student_name` VARCHAR(100) NULL,
  `student_roll` INT NOT NULL,
  `student_contact` VARCHAR(10) NULL,
  `student_subject1` INT NULL,
  `student_subject2` INT NULL,
  PRIMARY KEY (`student_roll`));

CREATE TABLE `student_result_management_system`.`user_db` (
  `user_role` VARCHAR(1),
  `user_name` VARCHAR(45),
  `user_password` VARCHAR(45)
);

Step 3: Download the MySQL JAVA Connector if you don't have it and put it in Java\jre1.8.0_201\lib\ext folder in your system.
Step 4: Clone this Repository using the following link

https://github.com/abirbhattacharya82/Student_Result_Management_System.git

Step 5: Open the Command Prompt for Windows Machines and Terminal for Linux Machines and use the following two commands and you are good to go

javac Main.java
java Main