Full-stack systems
Dormitory Management System
A web application for university residence operations — room allocation without overbooking, transfers, and absence tracking with a full audit history.
- Period
- Dec 2024
- Stack
- Java 17
- Spring Boot
- Spring Security
- MySQL
- Flyway
- Docker
- Playwright




01 · Roles
Two workspaces, one set of rules.
Administrators manage buildings, rooms, students and staff accounts, and check students in, transfer them between rooms and check them out. Dormitory staff record and correct absences for the buildings assigned to them.
02 · Allocation
No overbooking, no deadlocks.
Check-ins, transfers and policy changes lock rows in one fixed order — student, rooms, then building — so two requests for the last bed cannot both succeed, and the paths cannot deadlock. Buildings can be mixed, female-only or male-only, and only rooms that fit the student are offered.
03 · History
Every change on the record.
A transfer closes one stay and opens the next in a single transaction, so a failed transfer leaves the original assignment untouched. Absence corrections and withdrawals keep who changed what and when, and calendar days follow the residence's time zone.
04 · Delivery
Verified at every level.
Integration tests run on H2 and, through Testcontainers, on MySQL 8.4, behind a coverage gate and an OpenAPI contract test. Playwright drives the packaged application, CI deploys the Docker Compose stack and smoke-tests it, and releases publish the image automatically. Session sign-in with CSRF protection, BCrypt and per-building scope checks guard the data.
Key result
90%
Line-coverage gate in CI (70% for branches), with integration tests on MySQL 8.4 through Testcontainers.