jOOQ record mappers
Sometimes, we need a custom mapping that cannot be achieved via the fetchInto()
method, the fetchMap()
method, the fetchGroups()
method, or the Records
utility. A simple approach relies on Iterable.forEach(Consumer)
, as shown in the following mapping:
ctx.select(EMPLOYEE.FIRST_NAME, EMPLOYEE.LAST_NAME, EMPLOYEE.EMAIL) .from(EMPLOYEE) .forEach((Record3<String, String, String> record) -> { System.out.println("\n\nTo: " + record.getValue(EMPLOYEE.EMAIL)); System.out.println("From: " + "hrdepartment@classicmodelcars.com"); System.out.println("Body: \n Dear, " + record...