How parthkprogrammer/dbms-mini_project works
This is a JavaFX student-management desktop app for role-aware login and managing courses, enrollments, student records, and grades. The main user flow is through the dashboard: users sign in or register, then use role-sensitive views to browse courses and grades; staff can assign grades. Controllers delegate business work to services and, in some dashboard operations, directly to DAO implementations. Services and DAOs handle persistence through JDBC to MySQL. The README documents the broader MVC/DAO intent; some dashboard and UI wiring is only partially excerpted, so uncertain links are omitted.
Main entry points: impl JDBC DAO Implementations · AuthService.java Authentication · DashboardController.java Dashboard Controller · Main.java JavaFX Launcher
Components 18
Desktop UI
- JavaFX Launcher
src/main/java/com/sms/Main.java - Login View
src/main/resources/fxml/Login.fxml - Signup View
src/main/resources/fxml/Signup.fxml - Dashboard View
src/main/resources/fxml/Dashboard.fxml - Login Controller
src/main/java/com/sms/controller/LoginController.java - Signup Controller
src/main/java/com/sms/controller/SignupController.java - Dashboard Controller
src/main/java/com/sms/controller/DashboardController.java
Application Services
- Authentication
src/main/java/com/sms/service/AuthService.java - Course & Enrollment
src/main/java/com/sms/service/CourseService.java - Grade Management
src/main/java/com/sms/service/GradeService.java - Student Management
src/main/java/com/sms/service/StudentService.java - Password Utilities
src/main/java/com/sms/util/PasswordUtil.java
Data Access
- DAO Contracts
src/main/java/com/sms/dao - JDBC DAO Implementations
src/main/java/com/sms/dao/impl - JDBC Connection
src/main/java/com/sms/util/DBConnection.java
Domain Data
- Domain Models
src/main/java/com/sms/model
Other components
- User
- MySQL Database
Connections 19
- User → JavaFX Launcher: opens app
README.md - JavaFX Launcher → Login View: loads
src/main/java/com/sms/Main.java - Login Controller → JavaFX Launcher: switches view
src/main/java/com/sms/controller/LoginController.java - Signup Controller → JavaFX Launcher: switches view
src/main/java/com/sms/controller/SignupController.java - Login Controller → Authentication: authenticates
src/main/java/com/sms/controller/LoginController.java - Signup Controller → Authentication: registers
src/main/java/com/sms/controller/SignupController.java - Authentication → JDBC DAO Implementations: persists users
src/main/java/com/sms/service/AuthService.java - Authentication → Password Utilities: hashes passwords
src/main/java/com/sms/service/AuthService.java - Dashboard Controller → Course & Enrollment: requests courses
src/main/java/com/sms/controller/DashboardController.java - Dashboard Controller → Grade Management: assigns grades
src/main/java/com/sms/controller/DashboardController.java - Dashboard Controller → JDBC DAO Implementations: queries records
src/main/java/com/sms/controller/DashboardController.java - Course & Enrollment → JDBC DAO Implementations: reads and writes
src/main/java/com/sms/service/CourseService.java - Grade Management → JDBC DAO Implementations: manages grades
src/main/java/com/sms/service/GradeService.java - Student Management → JDBC DAO Implementations: manages students
src/main/java/com/sms/service/StudentService.java - JDBC DAO Implementations → DAO Contracts: implements
src/main/java/com/sms/dao/impl/CourseDAOImpl.java - JDBC DAO Implementations → JDBC Connection: opens connections
src/main/java/com/sms/dao/impl/CourseDAOImpl.java - JDBC Connection → MySQL Database: connects via JDBC
src/main/java/com/sms/util/DBConnection.java - Dashboard Controller → Domain Models: displays records
src/main/java/com/sms/controller/DashboardController.java - Authentication → Domain Models: uses roles and users
src/main/java/com/sms/service/AuthService.java