jOOQ

https://www.jooq.org/doc/latest/manual/

Admin

jOOQ is a Java library that provides a SQL query builder DSL for building type-safe SQL queries and...

Tokens:688

Snippets:13

Trust Score:10

Update:7 months ago

Show doc for...

Tokens:

Raw

### Standard code block examples

Source: https://www.jooq.org/doc/latest/manual/getting-started/the-manual

Basic examples of how different languages are represented in the documentation, including SQL, Java, XML, and configuration properties.

```sql
SELECT 1 FROM DUAL
```

```java
for (int i = 0; i < 10; i++);
```

```xml
<hello what="world"></hello>
```

```properties
org.jooq.property=value
```

--------------------------------

### Query execution patterns

Source: https://www.jooq.org/doc/latest/manual/getting-started/the-manual

Illustrates the difference between immediate SQL execution and the requirement to call fetch() or execute() in the jOOQ API.

```sql
SELECT 1 FROM DUAL;
UPDATE t SET v = 1;
```

```java
create.selectOne().fetch();
create.update(T).set(T.V, 1).execute();
```

--------------------------------

### SQL to jOOQ DSL comparison

Source: https://www.jooq.org/doc/latest/manual/getting-started/the-manual

Demonstrates the side-by-side comparison pattern used in the manual to show the relationship between native SQL and the corresponding jOOQ DSL query.

```sql
SELECT 1 FROM DUAL
```

```java
create.selectOne().fetch()
```

--------------------------------

### Common jOOQ documentation assumptions

Source: https://www.jooq.org/doc/latest/manual/getting-started/the-manual

Defines the standard assumptions made in code snippets, such as static imports from org.jooq.impl.DSL and the use of 'create' as an instance of DSLContext.

Tokens:

Raw