Gr 12 – UCanAccess

For your PAT, if you decide to code your SQL database in Ms Access you will need the library UCanAccess. This is an open-source, Java JDBC driver that allows developers to read from and write to Microsoft Access databases.   If you are manually managing your...

Gr 12 – Threads in Java

Understanding multithreading is difficult if you have never seen Java code with multiple threads. Threads have to be coded by the developer and is not taught at high school level. These two programs also use inheritance. Using Gogga is a useful way to demonstrate...

Gr 12 – Trace tables

Debugging pseudocode by stepping through it with a trace table  Here are three pseudocode trace table exercises with their solutions. NOTES: You must have a column in the solution for the line number. The loops must be clearly visible ie the lines numbers get repeated...

Gr 12 – Search Array

In SQL there is an IN statement that looks for a value within a given list. Example. SELECT town FROM tblTowns WHERE town IN (‘Johannesburg’, ‘Pretoria’, ‘Cape Town’); How does one code the same thing in Java when using a regular...

Gr11 12 – Data Validation

Data Validation Overview. V1 Validation first, followed by verification. Validation – does the data match the template? Example: The date template could be “yyyy-MM-dd” Verification – the data does match the template but is it valid? Example: “2026-14-13” matches the...