I accidentally stumbled onto jOOQ a few days ago while doing a lot of research on Hibernate. Funny how things work, isn\u2019t it? For those of you that aren\u2019t familiar with it, jOOQ is a different approach to the over-ORMing of Java persistence. Rather than try to map database tables to Java classes and abstract away the SQL underneath, jOOQ assumes you\u00a0want<\/em>\u00a0low level control over the SQL queries you execute, and provides a mostly typesafe interface for executing queries. I don\u2019t have anything against simple ORMs, but it\u2019s good to have the right tool for the right job. From the\u00a0jOOQ homepage<\/a>:<\/p?<\/p>\n\n\n\n Instead of this SQL query:<\/p>\n\n\n\n You would execute this Java code:<\/p>\n\n\n\n Why a Java interface? Type safety, for one. Programmatically using jOOQ\u2019s DSL has some advantages over writing SQL queries by hand, such as IDE support and compile time checking of some<\/em> things.<\/p>\n\n\n\n The idea interested me and I dug in. Unfortunately, the jOOQ site\u2019s documentation, while fairly comprehensive, DO NOT PROVIDE AN END TO END \u201cGETTING STARTED\u201d PAGE!!! This means that if you want to learn jOOQ, you\u2019ll have to jump to the chapter about Meta model code generation, then jump to the DSL, then jump to jOOQ classes section. It\u2019s a bit of a mess for new users. Google search also didn\u2019t turn up many useful results, so I figured I\u2019d whip up a quick \u201cGetting started\u201d guide. We\u2019re going to go over the following steps:<\/p>\n\n\n\n Preparation: Download jOOQ and your SQL driver Ready? Let\u2019s get started.<\/p>\n","protected":false},"excerpt":{"rendered":" Introduction I accidentally stumbled onto jOOQ a few days ago while doing a lot of research on Hibernate. Funny how things work, isn\u2019t it? For … Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_generate-full-width-content":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/posts\/2274"}],"collection":[{"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/comments?post=2274"}],"version-history":[{"count":1,"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/posts\/2274\/revisions"}],"predecessor-version":[{"id":2275,"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/posts\/2274\/revisions\/2275"}],"wp:attachment":[{"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/media?parent=2274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/categories?post=2274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ikaisays.com\/wp-json\/wp\/v2\/tags?post=2274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}SELECT * FROM BOOK\n WHERE PUBLISHED_IN = 2011\nORDER BY TITLE<\/code><\/pre>\n\n\n\ncreate.selectFrom(BOOK)\n .where(PUBLISHED_IN.equal(2011))\n .orderBy(TITLE)<\/code><\/pre>\n\n\n\n
Step 1: Create a SQL database and a table
Step 2: Generate classes
Step 3. Write a main class and establish MySQL connection
Step 4: Write a query using jOOQ\u2019s DSL
Step 5: Iterate over results
Step 6: Profit!<\/p>\n\n\n\n