{"id":32309,"date":"2014-10-30T17:43:06","date_gmt":"2014-10-30T15:43:06","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/?p=32309"},"modified":"2019-12-09T21:33:32","modified_gmt":"2019-12-09T19:33:32","slug":"write-sql-in-java-with-jooq","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2014\/10\/write-sql-in-java-with-jooq.html","title":{"rendered":"Write SQL in Java with jOOQ"},"content":{"rendered":"

jOOQ<\/a> is a \u201cdatabase first\u201d, type safe SQL API that allows you to write SQL in Java intuitively as if the SQL language were supported natively by the Java compiler.<\/p>\n

All database schemas, tables, columns, procedures, and other objects are made available as Java objects that can be used directly in the jOOQ SQL API.<\/p>\n

Let’s see how it works…<\/p>\n

 
\n 
\n <\/p>\n

For instance, let’s assume your database consists of this table:<\/p>\n

CREATE TABLE CUSTOMER (\n    ID INT, \n    FIRST_NAME VARCHAR(50),\n    LAST_NAME VARCHAR(50),\n    AGE INT\n);\n<\/pre>\n
When you run jOOQ’s code generator against it, then you will be able to interact with your database as follows:
 
<\/div> <\/div><\/p>\n
dsl.select(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME)\n   .from(CUSTOMER)\n   .where(CUSTOMER.AGE.gt(20))\n   .and(CUSTOMER.LAST_NAME.like(\"S%\"))\n   .fetch();\n<\/pre>\n
jOOQ<\/a>\u2019s main features are:<\/p>\n