MyBatisPlus条件构造器常用方法

常用方法

eq 等于

eq(R column, Object val)
eq(boolean condition, R column, Object val)

ne 不等于

ne(R column, Object val)
ne(boolean condition, R column, Object val)

gt 大于

gt(R column, Object val)
gt(boolean condition, R column, Object val)

ge 大于等于

ge(R column, Object val)
ge(boolean condition, R column, Object val)

lt 小于

lt(R column, Object val)
lt(boolean condition, R column, Object val)

le 小于等于

le(R column, Object val)
le(boolean condition, R column, Object val)

between

between(R column, Object val1, Object val2)
between(boolean condition, R column, Object val1, Object val2)

notBetween

notBetween(R column, Object val1, Object val2)
notBetween(boolean condition, R column, Object val1, Object val2)

like

like(R column, Object val)
like(boolean condition, R column, Object val)

notLike

notLike(R column, Object val)
notLike(boolean condition, R column, Object val)

likeLeft： ‘%值’

likeLeft(R column, Object val)
likeLeft(boolean condition, R column, Object val)

likeRight ： ‘值%’

likeRight(R column, Object val)
likeRight(boolean condition, R column, Object val)

isNull

isNull(R column)
isNull(boolean condition, R column)

示例：

isNull("name")       // name is null

isNotNull

isNotNull(R column)
isNotNull(boolean condition, R column)

示例：

isNotNull("name")       //name is not null

in

in(R column, Collection value)
in(boolean condition, R column, Collection value)
in(R column, Object… values)
in(boolean condition, R column, Object… values)

示例：

 in("id",{1,2,3})            //id in (1,2,3)
 in("id", 1, 2, 3)           //id in (1,2,3)

notIn

notIn(R column, Collection value)
notIn(boolean condition, R column, Collection value)
notIn(R column, Object… values)
notIn(boolean condition, R column, Object… values)

示例：

notIn("id",{1,2,3})       // idnot in (1,2,3)
notIn("id", 1, 2, 3)      // idnot in (1,2,3)