| 程序包 | 说明 |
|---|---|
| cool.lazy.cat.orm.core.base.service.impl | |
| cool.lazy.cat.orm.core.jdbc.sql.condition |
| 限定符和类型 | 方法和说明 |
|---|---|
protected Condition |
CommonServiceImpl.initCondition(Class<?> pojoType)
初始化默认查询条件
如果pojo存在逻辑删除字段,则添加逻辑删除字段控制
|
| 限定符和类型 | 方法和说明 |
|---|---|
Condition |
Condition.and(SqlCondition condition) |
static Condition |
Condition.eq(String field,
Object value)
属性相等条件 a = 'a'
|
static Condition |
Condition.eq(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.gt(String field,
Object value)
字段大于 a > 22
|
static Condition |
Condition.gt(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.gte(String field,
Object value)
字段大于等于 a >= 22
|
static Condition |
Condition.gte(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.in(String field,
Object value)
字段在列表 a in ('a', 'b')
|
static Condition |
Condition.in(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.isNull(String field)
字段为空 a is null
|
static Condition |
Condition.leLike(String field,
Object value)
模糊匹配 通配符在左 a like '%a'
|
static Condition |
Condition.leLike(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.like(String field,
Object value)
模糊匹配 通配符两端开放 a like '%a%'
|
static Condition |
Condition.like(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.lt(String field,
Object value)
字段小于 a < 22
|
static Condition |
Condition.lt(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.lte(String field,
Object value)
字段小于等于 a <= 22
|
static Condition |
Condition.lte(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.neq(String field,
Object value)
属性不相等条件 a !
|
static Condition |
Condition.neq(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.notIn(String field,
Object value)
字段不在列表 a not in ('a', 'b')
|
static Condition |
Condition.notIn(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.notLeLike(String field,
Object value)
模糊匹配取反 通配符在左 a not like '%a'
|
static Condition |
Condition.notLeLike(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.notLike(String field,
Object value)
模糊匹配取反 通配符两端开放 a not like '%a%'
|
static Condition |
Condition.notLike(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
static Condition |
Condition.notNull(String field)
字段不为空 a is not null
|
static Condition |
Condition.notRiLike(String field,
Object value)
模糊匹配取反 通配符在右 a not like 'a%'
|
static Condition |
Condition.notRiLike(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
Condition |
Condition.or(SqlCondition condition) |
static Condition |
Condition.riLike(String field,
Object value)
模糊匹配 通配符在右 a like 'a%'
|
static Condition |
Condition.riLike(String field,
SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder) |
Copyright © 2022. All rights reserved.