How rahulv17/student_course_registeration_system works
This is a console-based JDBC student-course registration system. A console user chooses an operation in RegistrationApp, which delegates business operations to RegistrationService; the service routes them to student, course, or enrollment DAOs, which issue SQL through a HikariCP connection pool to MySQL. The DAOs cover registration, batch inserts, transactional enrollment, queries and updates/deletes; enrollment queries include a stored procedure and a joined report. The graph follows shown calls and README-documented capabilities; unsampled database setup details are not inferred.
Main entry points: RegistrationApp.java Registration menu · StudentDBConnection.java Hikari connection pool · RegistrationService.java Registration logic · StudentDAO.java Student operations
Components 12
Console interface
- Registration menu
src/main/java/student_course/RegistrationApp.java
Registration service
- Registration logic
src/main/java/student_course/service/RegistrationService.java - Student model
src/main/java/student_course/model/Student.java - Course model
src/main/java/student_course/model/Course.java
Data access
- Student operations
src/main/java/student_course/dao/StudentDAO.java - Course operations
src/main/java/student_course/dao/CourseDAO.java - Enrollment operations
src/main/java/student_course/dao/EnrollmentDAO.java
Persistence
- Hikari connection pool
src/main/java/student_course/util/StudentDBConnection.java - Database properties
src/main/resources/db.properties - MySQL database
- Student courses procedure
src/main/resources/student_setup.sql
Other components
- Console user
Connections 18
- Console user → Registration menu: chooses operation
README.md - Registration menu → Registration logic: dispatches requests
src/main/java/student_course/RegistrationApp.java - Registration logic → Student operations: calls student operations
src/main/java/student_course/service/RegistrationService.java - Registration logic → Course operations: calls course operations
src/main/java/student_course/service/RegistrationService.java - Registration logic → Enrollment operations: calls enrollment operations
src/main/java/student_course/service/RegistrationService.java - Registration menu → Student model: creates student data
src/main/java/student_course/RegistrationApp.java - Registration menu → Course model: creates course data
src/main/java/student_course/RegistrationApp.java - Student operations → Student model: maps records
src/main/java/student_course/dao/StudentDAO.java - Course operations → Course model: maps records
src/main/java/student_course/dao/CourseDAO.java - Student operations → Hikari connection pool: gets connections
src/main/java/student_course/dao/StudentDAO.java - Course operations → Hikari connection pool: gets connections
src/main/java/student_course/dao/CourseDAO.java - Enrollment operations → Hikari connection pool: gets connections
src/main/java/student_course/dao/EnrollmentDAO.java - Hikari connection pool → Database properties: loads settings
src/main/java/student_course/util/StudentDBConnection.java - Student operations → MySQL database: queries and writes
src/main/java/student_course/dao/StudentDAO.java - Course operations → MySQL database: queries and writes
src/main/java/student_course/dao/CourseDAO.java - Enrollment operations → MySQL database: enrolls and reports
src/main/java/student_course/dao/EnrollmentDAO.java - Enrollment operations → Student courses procedure: calls procedure
src/main/java/student_course/dao/EnrollmentDAO.java - Registration menu → Hikari connection pool: closes pool
src/main/java/student_course/RegistrationApp.java