Coder Social home page Coder Social logo

tridiprong / studentreportingsystem Goto Github PK

View Code? Open in Web Editor NEW
1.0 1.0 0.0 139 KB

In this application, we can add student ,there marks,semester & See multiple reports of students. Average Percentage of whole class in recent semester Average marks of Students in a subject Top 2 Consistent Students across all semesters (Maximum average marks)

Java 100.00%
hibernate java mysql spring-boot swagger-ui springdata-jpa

studentreportingsystem's Introduction

Student Reporting Application

In this application, we can add student ,there marks,semester & See multiple reports of students.

  • Average Percentage of whole class in recent semester
  • Average marks of Students in a subject
  • Top 2 Consistent Students across all semesters (Maximum average marks)

ER Diagram

SwaggerUI

Functionalities

  • Add Student
  • Add subject and number to student
  • Get Average Percentage of whole class in recent semester
  • Get Average marks of Students in a subject
  • Get top 2 Consistent Students across all semesters (Maximum average marks)

Backend Work

  • Proper Exception Handling, and Input Validation
  • Data Stored in the database(mySQL)

Installation and Run

  • Before running the API server, we should update the database config inside the application.properties file.
  • Update the port number, username and password as per your local database config.
server.port=8901
spring.datasource.url=jdbc:mysql://localhost:3306/salesken
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=Tridip123@
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.mvc.pathmatch.matching-strategy = ANT_PATH_MATCHER

Tech Stacks

  • Java Core
  • Spring Data JPA
  • Spring Boot
  • Hibernate
  • MySQL

Backend

Student Controller

POST : /addStudent

{
    "studentId": 1,
      "name": "Tridip Rong",
      "fatherName": "Tapas Rong",
      "email": "[email protected]",
      "mobileNumber": "8999712977",
      "gender": "MALE"
      "Subject":[]
    
}

PUT : /addSubjectToStudent/{studentId}

{
    "subjectId" : 2,
    "studentId": 1,
     "Semester":FIRST,
     "Subject":"Maths",
     "Marks":75
    
}

Get :/getAverageOfRecentSemester

89.33

Get : /averageMarksOfStudents

{
  "Name": "Tridip Rong"
  "English" : 71,
  "Math" : 55,
  "Science" : 88
}

Get : //top2ConsistentStudents

{
  "Tridip" : 72,
  "Rong" : 65
}

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.