Chapter 4: Building a DAO Layer (Evolving the Generated DAO Layer)

At this point, we know how to enable the jOOQ Code Generator and how to express queries via the jOOQ DSL API, and we have a decent level of understanding of how jOOQ works. In other words, we know how to start and configure a Spring Boot application relying on jOOQ for the persistence layer implementation.

In this chapter, we tackle different approaches for organizing our queries in a Data Access Object (DAO) layer. Being a Spring Boot fan, you are most probably familiar with a DAO layer that is repository-centric, therefore, you'll see how jOOQ fits into this context. By the end of this chapter, you'll be familiar with the following:

• Hooking the DAO layer
• Shaping the DAO design pattern and using jOOQ
• Shaping the generic DAO design pattern and using jOOQ
• Extending the jOOQ built-in DAO

Let's get started!