cool.lazy.cat.orm.core.jdbc.sql.condition

类 Condition

java.lang.Object

cool.lazy.cat.orm.core.jdbc.sql.condition.Condition

所有已实现的接口:

SqlCondition

public class Condition
extends Object
implements SqlCondition

方法概要

限定符和类型	方法和说明
Condition	and(SqlCondition condition)
static Condition	eq(String field, Object value) 属性相等条件 a = 'a'
static Condition	eq(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
String	field()
List<SqlCondition>	flatCondition()
List<SqlCondition>	getAnd()
List<SqlCondition>	getOr()
static Condition	gt(String field, Object value) 字段大于 a > 22
static Condition	gt(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	gte(String field, Object value) 字段大于等于 a >= 22
static Condition	gte(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	in(String field, Object value) 字段在列表 a in ('a', 'b')
static Condition	in(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	isNull(String field) 字段为空 a is null
static Condition	leLike(String field, Object value) 模糊匹配 通配符在左 a like '%a'
static Condition	leLike(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	like(String field, Object value) 模糊匹配 通配符两端开放 a like '%a%'
static Condition	like(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	lt(String field, Object value) 字段小于 a < 22
static Condition	lt(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	lte(String field, Object value) 字段小于等于 a <= 22
static Condition	lte(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	neq(String field, Object value) 属性不相等条件 a !
static Condition	neq(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	notIn(String field, Object value) 字段不在列表 a not in ('a', 'b')
static Condition	notIn(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	notLeLike(String field, Object value) 模糊匹配取反 通配符在左 a not like '%a'
static Condition	notLeLike(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	notLike(String field, Object value) 模糊匹配取反 通配符两端开放 a not like '%a%'
static Condition	notLike(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
static Condition	notNull(String field) 字段不为空 a is not null
static Condition	notRiLike(String field, Object value) 模糊匹配取反 通配符在右 a not like 'a%'
static Condition	notRiLike(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
Condition	or(SqlCondition condition)
static Condition	riLike(String field, Object value) 模糊匹配 通配符在右 a like 'a%'
static Condition	riLike(String field, SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)
ConditionType	type()
Object	value()

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

从接口继承的方法 cool.lazy.cat.orm.core.jdbc.sql.condition.SqlCondition

nested

方法详细资料

field

public String field()

指定者:

field 在接口中 SqlCondition

返回:

字段名

value

public Object value()

指定者:

value 在接口中 SqlCondition

返回:

值

type

public ConditionType type()

指定者:

type 在接口中 SqlCondition

返回:

条件类型

getAnd

public List<SqlCondition> getAnd()

指定者:

getAnd 在接口中 SqlCondition

返回:

条件连接的and条件

getOr

public List<SqlCondition> getOr()

指定者:

getOr 在接口中 SqlCondition

返回:

条件连接的or条件

and

public Condition and(SqlCondition condition)

指定者:

and 在接口中 SqlCondition

返回:

添加一个and关系的条件

or

public Condition or(SqlCondition condition)

指定者:

or 在接口中 SqlCondition

返回:

添加一个or关系的条件

flatCondition

public List<SqlCondition> flatCondition()

指定者:

flatCondition 在接口中 SqlCondition

返回:

转换所有嵌套的条件为一个平铺的集合

eq

public static Condition eq(String field,
                           Object value)

属性相等条件 a = 'a'

参数:

field - 字段名称

value - 值

返回:

sql条件

eq

public static Condition eq(String field,
                           SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

neq

public static Condition neq(String field,
                            Object value)

属性不相等条件 a != 'a'

参数:

field - 字段名称

value - 值

返回:

sql条件

neq

public static Condition neq(String field,
                            SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

like

public static Condition like(String field,
                             Object value)

模糊匹配 通配符两端开放 a like '%a%'

参数:

field - 字段名称

value - 值

返回:

sql条件

like

public static Condition like(String field,
                             SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

leLike

public static Condition leLike(String field,
                               Object value)

模糊匹配 通配符在左 a like '%a'

参数:

field - 字段名称

value - 值

返回:

sql条件

leLike

public static Condition leLike(String field,
                               SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

riLike

public static Condition riLike(String field,
                               Object value)

模糊匹配 通配符在右 a like 'a%'

参数:

field - 字段名称

value - 值

返回:

sql条件

riLike

public static Condition riLike(String field,
                               SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

notLike

public static Condition notLike(String field,
                                Object value)

模糊匹配取反 通配符两端开放 a not like '%a%'

参数:

field - 字段名称

value - 值

返回:

sql条件

notLike

public static Condition notLike(String field,
                                SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

notLeLike

public static Condition notLeLike(String field,
                                  Object value)

模糊匹配取反 通配符在左 a not like '%a'

参数:

field - 字段名称

value - 值

返回:

sql条件

notLeLike

public static Condition notLeLike(String field,
                                  SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

notRiLike

public static Condition notRiLike(String field,
                                  Object value)

模糊匹配取反 通配符在右 a not like 'a%'

参数:

field - 字段名称

value - 值

返回:

sql条件

notRiLike

public static Condition notRiLike(String field,
                                  SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

isNull

public static Condition isNull(String field)

字段为空 a is null

参数:

field - 字段名称

返回:

sql条件

notNull

public static Condition notNull(String field)

字段不为空 a is not null

参数:

field - 字段名称

返回:

sql条件

in

public static Condition in(String field,
                           Object value)

字段在列表 a in ('a', 'b')

参数:

field - 字段名称

value - 值

返回:

sql条件

in

public static Condition in(String field,
                           SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

notIn

public static Condition notIn(String field,
                              Object value)

字段不在列表 a not in ('a', 'b')

参数:

field - 字段名称

value - 值

返回:

sql条件

notIn

public static Condition notIn(String field,
                              SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

gt

public static Condition gt(String field,
                           Object value)

字段大于 a > 22

参数:

field - 字段名称

value - 值

返回:

sql条件

gt

public static Condition gt(String field,
                           SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

gte

public static Condition gte(String field,
                            Object value)

字段大于等于 a >= 22

参数:

field - 字段名称

value - 值

返回:

sql条件

gte

public static Condition gte(String field,
                            SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

lt

public static Condition lt(String field,
                           Object value)

字段小于 a < 22

参数:

field - 字段名称

value - 值

返回:

sql条件

lt

public static Condition lt(String field,
                           SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)

lte

public static Condition lte(String field,
                            Object value)

字段小于等于 a <= 22

参数:

field - 字段名称

value - 值

返回:

sql条件

lte

public static Condition lte(String field,
                            SqlConditionValuePlaceHolder sqlConditionValuePlaceHolder)