How wanchanch/excuse works
This is a Java/JSP school excuse-management web application. Students and teachers register or log in, then submit, view, search, and update excuse requests; teachers and administrators can review requests, while administrators also manage user records. Servlets handle role-aware requests, DAOs perform JDBC operations, and model classes carry user and excuse data. The excerpts show several controller-to-DAO calls and database connection setup; other servlet and JSP relationships are based only on the source index and tree, so uncertain links are omitted or dashed.
Main entry points: ExcuseDao.java Excuse DAO · LoginServlet.java Role login · UserDao.java User DAO · ListExcuse.java Student excuse list
Components 24
Access and profiles
- Role login
src/com/controller/LoginServlet.java - Registration
src/com/controller/RegisterServlet.java - Personal profile
src/com/controller/PersonalServlet.java - Profile view
web/PersonalStudent.jsp
Excuse workflow
- Submit excuse
src/com/controller/InsertServlet.java - Student excuse list
src/com/controller/ListExcuse.java - Teacher excuse list
src/com/controller/TeacherListServlet.java - Admin excuse list
src/com/controller/AdminListServlet.java - Excuse search
src/com/controller/SelectExcuseByCondition.java - Update excuse
src/com/controller/ModifyServlet.java - Review decision
src/com/controller/CheckServlet.java - Excuse pages
web
User administration
- User administration
src/com/controller - User search
src/com/controller/SelectStudentByCondition.java - User pages
web
Data access
- Excuse DAO
src/com/dao/ExcuseDao.java - User DAO
src/com/dao/UserDao.java - Excuse model
src/com/model/Excuse.java - User model
src/com/model/User.java - JDBC connection
src/com/utils/Utils.java
Other components
- Student
- Teacher
- Administrator
- MySQL database
Connections 41
- Student → Role login: signs in
src/com/controller/LoginServlet.java - Teacher → Role login: signs in
src/com/controller/LoginServlet.java - Administrator → Role login: signs in
src/com/controller/LoginServlet.java - Student → Registration: registers
- Teacher → Registration: registers
- Role login → User DAO: checks credentials
src/com/controller/LoginServlet.java - Role login → Student excuse list: forwards
src/com/controller/LoginServlet.java - Role login → Teacher excuse list: forwards
- Role login → Admin excuse list: forwards
- Registration → User DAO: creates account
src/com/controller/RegisterServlet.java - Registration → Role login: forwards
src/com/controller/RegisterServlet.java - Student → Submit excuse: submits request
- Submit excuse → Excuse DAO: inserts request
src/com/controller/InsertServlet.java - Student excuse list → Excuse DAO: loads requests
src/com/controller/ListExcuse.java - Student excuse list → Excuse pages: forwards
src/com/controller/ListExcuse.java - Teacher excuse list → Excuse DAO: loads requests
src/com/controller/TeacherListServlet.java - Admin excuse list → Excuse DAO: loads requests
src/com/controller/AdminListServlet.java - Excuse search → Excuse DAO: searches requests
src/com/controller/SelectExcuseByCondition.java - Excuse search → Student excuse list: forwards
src/com/controller/SelectExcuseByCondition.java - Excuse search → Teacher excuse list: forwards
src/com/controller/SelectExcuseByCondition.java - Excuse search → Admin excuse list: forwards
src/com/controller/SelectExcuseByCondition.java - Student → Update excuse: edits request
- Update excuse → Excuse DAO: updates request
src/com/controller/ModifyServlet.java - Update excuse → Student excuse list: forwards
src/com/controller/ModifyServlet.java - Teacher → Review decision: reviews request
- Review decision → Excuse DAO: sets decision
src/com/controller/CheckServlet.java - Administrator → User administration: manages users
- User administration → User DAO: manages accounts
src/com/controller/LoginServlet.java - User search → User DAO: searches users
src/com/controller/SelectStudentByCondition.java - User search → User pages: forwards
- Student → Personal profile: opens profile
- Teacher → Personal profile: opens profile
- Personal profile → User DAO: loads profile
src/com/controller/PersonalServlet.java - Personal profile → Profile view: forwards
src/com/controller/PersonalServlet.java - Excuse DAO → Excuse model: maps records
src/com/dao/ExcuseDao.java - User DAO → User model: maps records
src/com/dao/UserDao.java - Excuse DAO → JDBC connection: opens connection
src/com/dao/ExcuseDao.java - User DAO → JDBC connection: opens connection
src/com/dao/UserDao.java - JDBC connection → MySQL database: connects
src/com/utils/Utils.java - Excuse DAO → MySQL database: queries and writes
- User DAO → MySQL database: queries and writes