Student grouping and record lookup.
Student grouping and record lookup.
A Java/JDBC academic management exercise that retrieves students and grades from PostgreSQL and determines grade averages or outstanding examinations.
*File metrics count tracked files after excluding common generated build folders. The project status is an editable draft classification.
Capabilities evidenced by project documentation and source structure; some behaviours require platform configuration.
Student grouping and record lookup.
Grade-average computation and failed-grade handling.
Java data access through PostgreSQL/JDBC.
Technical architecture drawn from the repository and supplied documentation.
The project uses Java, PostgreSQL, JDBC as its documented technical foundation.
The source tree and supplied README describe the primary modules; individual files and runtime behaviour may vary by platform.
The repository documents a Java application with PostgreSQL/JDBC and grade records grouped by student and class.
A grade below 5 marks the student as having a failed subject in the documented workflow; otherwise the average is displayed.
JDBC supports database access for group listings and individual records. SQL connection details should remain configuration, not credentials embedded in a public portfolio.
Documentation: GitHub repository / project specification. The content describes documented behaviour or plans; deployment readiness is not inferred.
Student group lookup and academic status
List<Student> studenti = StudentDAO.getStudentiByGrupa(grupaNume);
if (studenti.isEmpty()) {
System.out.println("Grupa nu exista sau nu are studenti.");
} else {
for (Student student : studenti) {
if (student.areRestanta()) {
System.out.println(student.getNume() + " - RESTANTA");
} else {
System.out.println(student.getNume() + " - Media: "
+ String.format("%.2f", student.getMedia()));
}
}
}
Prepared statements supply group names as parameters when loading student averages.
try (Connection conn = DatabaseConnection.getConnection();
PreparedStatement stmt = conn.prepareStatement(query)) {
stmt.setString(1, grupaNume);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
int studentId = rs.getInt("id");
double media = rs.getDouble("media");
}
}
Screenshots from supplied documentation and repository media. Missing visuals remain placeholders rather than invented screens.
To fill this space, add an approved screenshot with the exact filename shown below. The site currently displays a neutral placeholder.
assets/img/projects/school-management/screenshot-01.webp
Technology overview: Java, PostgreSQL, JDBC. The list reflects documented tools, dependencies and proposed components; for planned projects it does not prove implementation.
File types identified: 4 .java
Explore the public repository, source code and project documentation on GitHub.