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. Student Result Management System
The following things are required in the system for the proper functioning of the software.
JAVA
JDK 17
MySQL 8
IndexDriver File
Data Flow Diagram
Software Requirement Specifications
MySQL JDBC Driver
To properly run the software perform the following steps: User Manual
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
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