Chapter 5: Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE

A common scenario for jOOQ beginners originates from having a plain valid SQL that should be expressed via the jOOQ DSL API. While the jOOQ DSL API is extremely intuitive and easy to learn, the lack of practice may still lead to scenarios where we simply cannot find or intuit the proper DSL methods that should be chained to express a certain SQL.

This chapter addresses this kind of issue via a comprehensive collection of popular queries, which gives you the chance to practice jOOQ DSL syntax based on the Java-based schema. More precisely, our aim is to express, in jOOQ DSL syntax, a carefully harvested list of SELECT, INSERT, UPDATE, DELETE, and MERGE statements ...

Get jOOQ Masterclass now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.