DEV Community

ts5432
ts5432

Posted on

Create field using JooqFields

#jooq #java #orm

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

Top comments (0)