Create field using JooqFields

Static methods for quickly creating JOOQ Table and Field objects, plus Map-to-Field conversion utilities.

1. T() — Create Table

public static Table<Record> T(String... qualifiedName)

Enter fullscreen mode Exit fullscreen mode

example:

T("user_table") or T("schema", "user_table")

Enter fullscreen mode Exit fullscreen mode

2. F() — Create Field

public static Field<Object> F(String... qualifiedName)
public static <T> Field<T> F(Class<T> type, String... qualifiedName)

Enter fullscreen mode Exit fullscreen mode

example:

jooq.selectFrom(T("user_table")).where(F("id").eq(1)).fetch();

Enter fullscreen mode Exit fullscreen mode

3. Typed Field Methods

Method Return Type Description SF(String…) Field String field NF(String…) Field Numeric field IF(String…) Field Integer field LF(String…) Field Long field BDF(String…) Field BigDecimal field BIF(String…) Field BigInteger field DF(String…) Field java.sql.Date field TF(String…) Field java.sql.Time field TSF(String…) Field java.sql.Timestamp field LDF(String…) Field LocalDate field LDTF(String…) Field LocalDateTime field ZDTF(String…) Field ZonedDateTime field ODTF(String…) Field OffsetDateTime field LTF(String…) Field LocalTime field

4. Special Fields

public static Field NLF()             // null literal
public static Field NLF(String name)  // null AS name
public static NullOrDefault ND(Object value)
public static NullOrDefault ND(Object value, Object defaultValue)

Enter fullscreen mode Exit fullscreen mode

5. Map & Field Conversion

public static Map<Field,Object> CFM(Map map)    // Create Field Map
public static List<Field>       CFL(List fields)  // Create Field List
public static List<Field>       CGL(List fields)  // Create Group List

Enter fullscreen mode Exit fullscreen mode