Practical Assessment Task
Documentation
George Cox - Grade 12
2025
, PHASE 4
Technical and Testing Document
Regatta Results
Developed by George Cox
, Table Of Contents
1. Technical Documentation............................................................................5
1.1 External Libraries and Tools Used............................................................... 5
1.1.1 KGradientPanel Library.........................................................................5
1.1.2 LGoodDatePicker v11.2.1 (External .jar)............................................. 5
1.1.3 Password Hashing with SHA-256....................................................... 5
1.1.4 List Structures (List<String> and HashMap<K, V>)............................ 6
1.1.5 Filling jTables using DefaultTableModel............................................. 6
1.1.6 Regex for Race Time Validation.......................................................... 6
1.2 Critical Algorithms........................................................................................ 7
1.2.1 Results Filtering Algorithm.................................................................. 7
Purpose:.................................................................................................... 7
Why is it critical?....................................................................................... 7
Flow diagram of algorithm:......................................................................7
1.2.2 Points and Ranking Calculation Algorithm......................................... 7
Purpose:.................................................................................................... 7
Why is it critical?....................................................................................... 8
Flow diagram of algorithm:......................................................................8
1.3 Advanced Techniques.................................................................................. 8
1.3.1 Use of HashMap<String, Integer> to Accumulate Team Points........ 8
How it works in my program:................................................................... 9
Why it’s advanced:.................................................................................... 9
1.3.2 Complex SQL Queries with Multi-Table Joins Across 8 Tables.........9
How it works in my program:................................................................... 9
Why it’s advanced:.................................................................................. 10
1.3.3 Regular Expression (Regex) for Input Validation..............................10
How it works:.......................................................................................... 10
Why it’s advanced:.................................................................................. 10
1.3.4 Integration of .jar Libraries for Enhanced UI..................................... 10
LGoodDatePicker v11.2.1:......................................................................11
KGradientPanel:...................................................................................... 11
Why it’s advanced:.................................................................................. 11