Mybatis-plus sql语句 LT、LE、EQ、NE、GE、GT
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:nu
·
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
更多推荐
已为社区贡献3条内容
所有评论(0)