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.

Overview

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
You might also like...

requery - modern SQL based query & persistence for Java / Kotlin / Android

requery - modern SQL based query & persistence for Java / Kotlin / Android

A light but powerful object mapping and SQL generator for Java/Kotlin/Android with RxJava and Java 8 support. Easily map to or create databases, perfo

Jan 5, 2023

A tool based on mysql-connector to simplify the use of databases, tables & columns

A tool based on mysql-connector to simplify the use of databases, tables & columns

Description A tool based on mysql-connector to simplify the use of databases, tables & columns. This tool automatically creates the databases & tables

Nov 17, 2022

The Chronix Server implementation that is based on Apache Solr.

Chronix Server The Chronix Server is an implementation of the Chronix API that stores time series in Apache Solr. Chronix uses several techniques to o

Jul 3, 2022

Time Series Metrics Engine based on Cassandra

Hawkular Metrics, a storage engine for metric data About Hawkular Metrics is the metric data storage engine part of Hawkular community. It relies on A

Dec 9, 2022

Apache Ant is a Java-based build tool.

Apache Ant What is it? ----------- Ant is a Java based build tool. In theory it is kind of like "make" without makes wrinkles and with

Dec 22, 2022

Get rid of the boilerplate code in properties based configuration.

OWNER OWNER, an API to ease Java property files usage. INTRODUCTION The goal of OWNER API is to minimize the code required to handle application confi

Dec 31, 2022

MapDB provides concurrent Maps, Sets and Queues backed by disk storage or off-heap-memory. It is a fast and easy to use embedded Java database engine.

MapDB: database engine MapDB combines embedded database engine and Java collections. It is free under Apache 2 license. MapDB is flexible and can be u

Dec 30, 2022
Owner
Abir Bhattacharya
Cerca Trova
Abir Bhattacharya
sql2o is a small library, which makes it easy to convert the result of your sql-statements into objects. No resultset hacking required. Kind of like an orm, but without the sql-generation capabilities. Supports named parameters.

sql2o Sql2o is a small java library, with the purpose of making database interaction easy. When fetching data from the database, the ResultSet will au

Lars Aaberg 1.1k Dec 28, 2022
DbLoadgen: A Scalable Solution for Generating Transactional Load Against a Database

DbLoadgen: A Scalable Solution for Generating Transactional Load Against a Database DbLoadgen is scalable solution for generating transactional loads

Qlik Partner Engineering 4 Feb 23, 2022
IoTDB (Internet of Things Database) is a data management system for time series data

English | 中文 IoTDB Overview IoTDB (Internet of Things Database) is a data management system for time series data, which can provide users specific ser

The Apache Software Foundation 3k Jan 1, 2023
A simple Database management system

总览 在开始 simpledb 旅途之前, 我们先从整体上来看看 SimpleDb 是一个 DBMS 数据库管理系统, 包含存储, 算子, 优化, 事务, 索引 等, 全方位介绍了如何从0实现一个 DBMS, 可以说, 这门课是学习 TIDB 等其他分布式数据库的前提.

null 66 Dec 28, 2022
A Java library designed to make making decisions based on the current operating system easier.

Java OS Independence ...or JOSI for short, is a simple and lightweight Java library designed to make making decisions based on the current operating s

null 38 Dec 30, 2022
The Prometheus monitoring system and time series database.

Prometheus Visit prometheus.io for the full documentation, examples and guides. Prometheus, a Cloud Native Computing Foundation project, is a systems

Prometheus 46.3k Jan 10, 2023
A Gradle plugin that improves the experience when developing Android apps, especially system tools, that use hidden APIs.

HiddenApiRefinePlugin A Gradle plugin that improves the experience when developing Android apps, especially system tools, that use hidden APIs. Backgr

Rikka apps 125 Jan 5, 2023
Online Quiz system - JDBC, JSP

Online-Quiz-System-in-Java Online Quiz system - JDBC, JSP Java Project based on JDBC, JSP, Java Servlet and Server Deployment Project Aim Develop web

Muhammad Asad 6 Oct 14, 2022