This is the code repository for jOOQ Masterclass , published by Packt.
A practical guide for Java developers to write SQL queries for complex database interactions
jOOQ Masterclass will help you write the coolest SQL statements without working with JDBC or handling ORM complexity and performance issues. This practical guide to jOOQ provides a hands-on approach with a complete and versatile set of solutions for implementing the persistence layer to serve the most stressful environments.
This book covers the following exciting features:
- Enable the jOOQ Code Generator in any combination of Java and Kotlin, Maven and Gradle
- Generate jOOQ artifacts directly from database schema, or without touching the real database
- Use jOOQ DSL to write and execute a wide range of queries for different databases
- Understand jOOQ type-safe queries, CRUD operations, converters, bindings, and mappers
- Implement advanced SQL concepts such as stored procedures, derived tables, CTEs, window functions, and database views
- Implement jOOQ multi-tenancy, tuning, jOOQ SPI, logging, and testing
If you feel this book is for you, get your copy today!
All of the code is organized into folders. For example, Chapter02.
The code will look like the following:
public List<Office> findOfficesInTerritory(
String territory) {
List<Office> result = ctx.selectFrom(table("office"))
.where(field("territory").eq(territory))
.fetchInto(Office.class);
return result;
}
Following is what you need for this book: This book is for Java developers who write applications that interact with databases via SQL. No prior experience with jOOQ is assumed.
With the following software and hardware list you can run all code files present in the book (Chapter 1-19).
Chapter | Software required | OS required |
---|---|---|
1 | MySql | Windows and Linux |
1 | Postgres | Windows and Linux |
1 | SQL Server | Windows and Linux |
1 | Oracle | Windows and Linux |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
Anghel Leonard is a chief technology strategist and independent consultant with 20+ years of experience in the Java ecosystem. In his daily work, he is focused on architecting and developing Java-distributed applications that empower robust architectures, clean code, and high performance. He is also passionate about coaching, mentoring, and technical leadership. He is the author of several books, videos, and dozens of articles related to Java technologies.
Data Stream Development with Apache Spark, Kafka, and Spring Boot [Video]