‹ All projects

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 / 04Roles
Administrator overview with available beds, occupancy by building and recent absencesRooms table showing each room's allocation by building policyStaff absence log with a corrected record and a withdrawn recordStudent table with housing status and filters
  1. 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.

  2. 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.

  3. 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.

  4. 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.