Planning, Specifying, and Shipping

Supporting documents

Diagrams

Modeled in Visio. Each one opens full size.

60 tasks 9 phases 37 on the critical path Sep 28, 2024 to Feb 21, 2025

The work breakdown structure I authored

A second Microsoft Project file, 48 tasks across 8 phases, Mar 2, 2025 to Apr 22, 2025. Drawn from the .mpp, same as above.

Supporting documents

Design and analysis

The appendices the requirements specification points at: system architecture in section 4.1, use case diagrams in 4.2, and the database schema in 4.3, plus the design document built on top of them.

Test planning and results

A written plan, then three reporting cycles: what failed, what was fixed, what signed off.

Inside the application

11,796 lines across 59 classes I wrote, in a layered structure.

Application screens

Fifteen windows, read from the NetBeans form definitions in the source. Control counts are what the interface actually contains.

Code

Parameterized statements and try-with-resources throughout the data layer.

// EquipmentDAO.java, from the DataAccess layer
public boolean createEquipment(Equipment equipment) {
    String sql = "INSERT INTO equipment (equipment_code, equipment_type, value, skill_id, " +
                "availability_id, status_id, employee_id, location_id) " +
                "VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

    try (Connection conn = DatabaseConnection.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {

        stmt.setInt(1, equipment.getEquipmentCode());
        stmt.setString(2, equipment.getEquipmentType());
        stmt.setBigDecimal(3, equipment.getValue());
        stmt.setInt(4, equipment.getSkill().getSkillId());

        if (equipment.getEmployee() != null) {
            stmt.setInt(7, equipment.getEmployee().getEmployeeId());
        } else {
            stmt.setNull(7, Types.INTEGER);
        }

        int affectedRows = stmt.executeUpdate();

The applications running

The screenshots that used to sit here now live in the technical gallery, sorted by class, alongside every other capture from the program.

Source