Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
RecordHandler
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
In a more functional operating mode, you might want to write callbacks that receive records from your select statement results in order to do some processing. This is a common data access pattern in Spring's JdbcTemplate, and it is also available in jOOQ. With jOOQ, you can implement your own org.jooq.RecordHandler classes and plug them into jOOQ's org.jooq.ResultQuery:
// Write callbacks to receive records from select statements
create.selectFrom(BOOK)
.orderBy(BOOK.ID)
.fetch()
.into(new RecordHandler<BookRecord>() {
@Override
public void next(BookRecord book) {
Util.doThingsWithBook(book);
}
});
// Or more concisely
create.selectFrom(BOOK)
.orderBy(BOOK.ID)
.fetchInto(new RecordHandler<BookRecord>() {...});
// Or even more concisely with Java 8's lambda expressions:
create.selectFrom(BOOK)
.orderBy(BOOK.ID)
.fetchInto(book -> { Util.doThingsWithBook(book); }; );
See also the manual's section about the RecordMapper, which provides similar features
Feedback
Do you have any feedback about this page? We'd love to hear it!