Student Management System(Java)

This project is a console-based application written in Java that tracks student information. All information is stored in a H2 database. Through a menu-driven interface the user can view grades(freshmen, softmore, etc), add and remove students, update student information, and view reports for the entire school or individual grades.

Features

• Create and delete student data in the database(CRUD operations)
• Add, modify, and delete classes
• View grade-level data(freshmen, softmore, juniors, seniors) including GPA's, honors, and valedictorian status
• Update student information, including classes schedules, and class grades
• Generate reports showing the valedictorian, honors students, average grade or school GPA, and the number of students in each grade

Technologies Used

• Java
• SQL
• H2 Database
• GitHub/GIT
• NetBeans IDE

Project Goals

• Create a real world application
• Write SQL statements and queries
• Learn how a Java program interacts with a database
• Keep track of complex data

Future Improvements

• Add a simple GUI

Status

• Project is complete