Create condition using JooqTemplate

1. condition

Create a Condition from a Field, an operator, and a value.

public Condition condition(Name fieldName, String operator, Object[] values)

2. conditions

Parse varargs into List. Arguments are grouped in pairs (fieldName, value). An operator suffix can be appended to the field name.

public List<Condition> conditions(Object... condtionKvs)

example:

// Basic usage: pairs of (fieldName, value)
List<Condition> conds = jt.conditions(
    "name", "John",                 // name = 'John'
    "birthday≥", beginDate        // birthday ≥ '2020-01-01'
);

// Mixing Condition objects
List<Condition> conds = jt.conditions(
    "name", name,
    F("create_time").isNotNull(),  // passing a Condition directly
    "birthday:desc"               // OrderBy: birthday DESC (ignored for conditions)
);

// Using conditions with query
List<User> list = jt.query("user_table", User.class,
    jt.conditions("name%", name, "birthday>=", beginDate));

Operator	Meaning	Example
(none) or ==	Equal (eq / isNull)	"name", value → name = ?
%	Contains (LIKE)	"name%", "Jo" → name LIKE '%Jo%'
%L	Starts with	"name%L", "Jo" → name LIKE 'Jo%'
%R	Ends with	"name%R", "hn" → name LIKE '%hn'
>	Greater than	"birthday>", date → birthday > ?
>=	Greater than or equal	"birthday>=", date → birthday >= ?
<	Less than	"age<", 18 → age < ?
<=	Less than or equal	"age<=", 18 → age <= ?
<>	Not equal	"name<>", "admin" → name <> ?
in	IN query	"id", list (Collection/array value) → id IN (?,?,?)
notin	NOT IN query	"id:notin", list → id NOT IN (?,?,?)
isnull	IS NULL (unary, no value argument)	"name:isnull" → name IS NULL
isnotnull	IS NOT NULL (unary, no value argument)	"name:isnotnull" → name IS NOT NULL

3. Order By

In varargs, can append sort operators to field names to specify ordering. can also pass OrderField objects directly.
example:

// Mix ordering in varargs
List<User> list = jt.queryv("user_table", User.class,
    "birthday:desc",            // ORDER BY birthday DESC
    F("name").asc().nullsLast()  // ORDER BY name ASC NULLS LAST
);

// Pass order list to query()
List<User> list = jt.query("user_table", User.class, conditions,
    Arrays.asList(F("birthday").desc(), F("name").asc()));

Sort Operator	Meaning
fieldName:asc	ASC
fieldName:desc	DESC
fieldName:ascnf	ASC NULLS FIRST
fieldName:ascnl	ASC NULLS LAST
fieldName:descnf	DESC NULLS FIRST
fieldName:descnl	DESC NULLS LAST