allEq 全部eq(或个别isNull)

allEq(Map<R, V> params)
allEq(Map<R, V> params, boolean null2IsNull)
allEq(boolean condition, Map<R, V> params, boolean null2IsNull)

• 例1: allEq({id:1,name:“老王”,age:null})—>id = 1 and name = ‘老王’ and age is null
• 例2: allEq({id:1,name:“老王”,age:null}, false)—>id = 1 and name = ‘老王’

eq 等于 =

• 例: eq(“name”, “老王”)—>name = ‘老王’

ne 不等于 <>

• 例: ne(“name”, “老王”)—>name <> ‘老王’

gt 大于 >

• 例: gt(“age”, 18)—>age > 18

ge 大于等于 >=

• 例: ge(“age”, 18)—>age >= 18

lt 小于 <

• 例: lt(“age”, 18)—>age < 18

le 小于等于 <=

• 例: le(“age”, 18)—>age <= 18

between BETWEEN 值1 AND 值2

• 例: between(“age”, 18, 30)—>age between 18 and 30

notBetween NOT BETWEEN 值1 AND 值2

• 例: notBetween(“age”, 18, 30)—>age not between 18 and 30