常用:
eq
eq(R column, Object val)
eq(boolean condition, R column, Object val)
等于 =
例: eq(“name”, “老王”)—>name = ‘老王’
ne
ne(R column, Object val)
ne(boolean condition, R column, Object val)
不等于 <>
例: ne(“name”, “老王”)—>name <> ‘老王’
orderByDesc
orderByDesc(R... columns)
orderByDesc(boolean condition, R... columns)
排序:ORDER BY 字段, … DESC
例: orderByDesc(“id”, “name”)—>order by id DESC,name DESC
in
in(R column, Collection<?> value)
in(boolean condition, R column, Collection<?> value)
字段 IN (value.get(0), value.get(1), …)
例: in(“age”,{1,2,3})—>age in (1,2,3)