Beginning jOOQ: Learn to Write Efficient and Effective Java-Based SQL Database Operations

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

T. KoleosoBeginning jOOQhttps://doi.org/10.1007/978-1-4842-7431-6_2

2. Getting Started with jOOQ

Tayo Koleoso¹  

(1)

Silver Spring, MD, USA

 

Let’s take this thing for spin! But first, you should get to know these classes and interfaces; they’re at the heart of 75% of what you’ll be doing in jOOQ:

1. 1.

   org.jooq.impl.DSL

   This is the sturdy, wise grandparent of most of jOOQ’s functionality. With this class, you can

   • Manipulate parts of a strongly typed SQL query in a typesafe manner.

   • Access database functions (concat, coalesce, etc.) as if they were java methods.

   • Specify database dialects. This is for when you need to perform operations that are unique to your datastore ...