Cond (ymate-platform-v2-码云(gitee.com))

java.lang.Object
- net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter<T>
- - net.ymate.platform.persistence.jdbc.query.Query<Cond>
  - - net.ymate.platform.persistence.jdbc.query.Cond

```
public final class Cond
extends Query<Cond>
```
条件对象

Author:

刘镇 (suninformation@163.com) on 15/5/9 下午8:12

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class Cond.LogicalOpt
逻辑运算符枚举

static class Cond.OPT
条件操作符枚举
- Nested classes/interfaces inherited from class net.ymate.platform.persistence.jdbc.query.Query
  Query.Executor<T>

Nested Classes
Modifier and Type	Class and Description
`static class`	`Cond.LogicalOpt` 逻辑运算符枚举
`static class`	`Cond.OPT` 条件操作符枚举

Field Summary
- Fields inherited from class net.ymate.platform.persistence.jdbc.query.Query
  LINE_END_FLAG

Constructor Summary

Constructors
Constructor and Description

Cond(IDatabase owner, String dataSourceName)

Constructors
Constructor and Description
`Cond(IDatabase owner, String dataSourceName)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`Cond`	`and()`
`Cond`	`and(Cond cond)`
`Cond`	`and(FieldCondition cond)`
`Cond`	`andIfNeed()`
`Cond`	`andIfNeed(Cond cond)`
`Cond`	`andIfNeed(FieldCondition cond)`
`Cond`	`between(IFunction func, Object valueOne, Object valueTwo)`
`Cond`	`between(String field, Object valueOne, Object valueTwo)`
`Cond`	`between(String prefix, String field, Object valueOne, Object valueTwo)`
`Cond`	`betweenWrap(String field, Object valueOne, Object valueTwo)`
`Cond`	`betweenWrap(String prefix, String field, Object valueOne, Object valueTwo)`
`Cond`	`bracket(Cond cond)`
`Cond`	`bracket(FieldCondition cond)`
`Cond`	`bracketBegin()`
`Cond`	`bracketEnd()`
`Cond`	`brackets()`
`String`	`build()`
`Where`	`buildWhere()` 通过当前条件对象创建Where对象实例
`Cond`	`cond(Cond.LogicalOpt opt, Object... condArr)`
`Cond`	`cond(Cond cond)`
`Cond`	`cond(FieldCondition cond)`
`Cond`	`cond(IFunction func)`
`Cond`	`cond(String cond)`
`static Cond`	`create()`
`static Cond`	`create(IDatabase owner)`
`static Cond`	`create(IDatabase owner, String dataSourceName)`
`static Cond`	`create(Query<?> query)`
`Cond`	`eq(IFunction func)`
`Cond`	`eq(IFunction funcOne, IFunction funcTwo)`
`Cond`	`eq(String field)`
`Cond`	`eq(String prefix, String field)`
`Cond`	`eqField(String fieldOne, String fieldTwo)`
`Cond`	`eqFieldWrap(String fieldOne, String fieldTwo)`
`Cond`	`eqOne()`
`Cond`	`eqWrap(String field)`
`Cond`	`eqWrap(String prefix, String field)`
`Cond`	`exists(Select subSql)`
`Cond`	`exists(SQL subSql)`
`Cond`	`expr(boolean expression, IConditionAppender appender)`
`Cond`	`expr(boolean expression, IConditionBuilder builder)`
`Cond`	`expr(boolean expression, String cond)`
`Cond`	`exprNotEmpty(Object target, IConditionAppender appender)`
`Cond`	`exprNotEmpty(Object target, IConditionBuilder builder)`
`Cond`	`gt(IFunction func)`
`Cond`	`gt(IFunction funcOne, IFunction funcTwo)`
`Cond`	`gt(String field)`
`Cond`	`gt(String prefix, String field)`
`Cond`	`gtEq(IFunction func)`
`Cond`	`gtEq(IFunction funcOne, IFunction funcTwo)`
`Cond`	`gtEq(String field)`
`Cond`	`gtEq(String prefix, String field)`
`Cond`	`gtEqField(String fieldOne, String fieldTwo)`
`Cond`	`gtEqFieldWrap(String fieldOne, String fieldTwo)`
`Cond`	`gtEqWrap(String field)`
`Cond`	`gtEqWrap(String prefix, String field)`
`Cond`	`gtField(String fieldOne, String fieldTwo)`
`Cond`	`gtFieldWrap(String fieldOne, String fieldTwo)`
`Cond`	`gtWrap(String field)`
`Cond`	`gtWrap(String prefix, String field)`
`Cond`	`in(String field, Params params)`
`Cond`	`in(String field, Select subSql)`
`Cond`	`in(String field, SQL subSql)`
`Cond`	`in(String prefix, String field, Params params)`
`Cond`	`in(String prefix, String field, Select subSql)`
`Cond`	`in(String prefix, String field, SQL subSql)`
`Cond`	`inWrap(String field, Params params)`
`Cond`	`inWrap(String field, Select subSql)`
`Cond`	`inWrap(String field, SQL subSql)`
`Cond`	`inWrap(String prefix, String field, Params params)`
`Cond`	`inWrap(String prefix, String field, Select subSql)`
`Cond`	`inWrap(String prefix, String field, SQL subSql)`
`boolean`	`isEmpty()`
`Cond`	`isNotNull(IFunction func)`
`Cond`	`isNotNull(String field)`
`Cond`	`isNotNull(String prefix, String field)`
`Cond`	`isNotNullWrap(String field)`
`Cond`	`isNotNullWrap(String prefix, String field)`
`Cond`	`isNull(IFunction func)`
`Cond`	`isNull(String field)`
`Cond`	`isNull(String prefix, String field)`
`Cond`	`isNullWrap(String field)`
`Cond`	`isNullWrap(String prefix, String field)`
`Cond`	`like(IFunction func)`
`Cond`	`like(String field)`
`Cond`	`like(String prefix, String field)`
`Cond`	`likeWrap(String field)`
`Cond`	`likeWrap(String prefix, String field)`
`Cond`	`lt(IFunction func)`
`Cond`	`lt(IFunction funcOne, IFunction funcTwo)`
`Cond`	`lt(String field)`
`Cond`	`lt(String prefix, String field)`
`Cond`	`ltEq(IFunction func)`
`Cond`	`ltEq(IFunction funcOne, IFunction funcTwo)`
`Cond`	`ltEq(String field)`
`Cond`	`ltEq(String prefix, String field)`
`Cond`	`ltEqField(String fieldOne, String fieldTwo)`
`Cond`	`ltEqFieldWrap(String fieldOne, String fieldTwo)`
`Cond`	`ltEqWrap(String field)`
`Cond`	`ltEqWrap(String prefix, String field)`
`Cond`	`ltField(String fieldOne, String fieldTwo)`
`Cond`	`ltFieldWrap(String fieldOne, String fieldTwo)`
`Cond`	`ltWrap(String field)`
`Cond`	`ltWrap(String prefix, String field)`
`Cond`	`not()`
`Cond`	`not(Cond cond)`
`Cond`	`not(FieldCondition cond)`
`Cond`	`notEq(IFunction func)`
`Cond`	`notEq(IFunction funcOne, IFunction funcTwo)`
`Cond`	`notEq(String field)`
`Cond`	`notEq(String prefix, String field)`
`Cond`	`notEqField(String fieldOne, String fieldTwo)`
`Cond`	`notEqFieldWrap(String fieldOne, String fieldTwo)`
`Cond`	`notEqWrap(String field)`
`Cond`	`notEqWrap(String prefix, String field)`
`Cond`	`notIfNeed()`
`Cond`	`notIfNeed(Cond cond)`
`Cond`	`notIfNeed(FieldCondition cond)`
`Cond`	`opt(Cond.LogicalOpt opt)`
`Cond`	`opt(IFunction func, Cond.OPT opt)`
`Cond`	`opt(IFunction funcOne, Cond.OPT opt, IFunction funcTwo)`
`Cond`	`opt(String field, Cond.OPT opt)`
`Cond`	`opt(String fieldOne, Cond.OPT opt, String fieldTwo)`
`Cond`	`optIfNeed(Cond.LogicalOpt opt)`
`Cond`	`optWrap(String field, Cond.OPT opt)`
`Cond`	`optWrap(String fieldOne, Cond.OPT opt, String fieldTwo)`
`Cond`	`or()`
`Cond`	`or(Cond cond)`
`Cond`	`or(FieldCondition cond)`
`Cond`	`orIfNeed()`
`Cond`	`orIfNeed(Cond cond)`
`Cond`	`orIfNeed(FieldCondition cond)`
`Cond`	`param(Object param)`
`Cond`	`param(Params params)`
`Params`	`params()`
`Cond`	`range(IFunction func, Object valueOne, Object valueTwo, Cond.LogicalOpt opt)`
`Cond`	`range(String field, Object valueOne, Object valueTwo, Cond.LogicalOpt opt)`
`Cond`	`range(String prefix, String field, Object valueOne, Object valueTwo, Cond.LogicalOpt opt)`
`Cond`	`rangeWrap(String field, Object valueOne, Object valueTwo, Cond.LogicalOpt opt)`
`Cond`	`rangeWrap(String prefix, String field, Object valueOne, Object valueTwo, Cond.LogicalOpt opt)`
`String`	`toString()`

Methods inherited from class net.ymate.platform.persistence.jdbc.query.Query
build, build, buildSafeTableName, buildSafeTableName, checkFieldExcluded, dataSourceName, dataSourceName, defaultTablePrefix, dialect, dialect, owner, shardingable, shardingable, shardingRule, shardingRule, wrapIdentifierField, wrapIdentifierField, wrapIdentifierField, wrapIdentifierFields

Methods inherited from class net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter
getExpressionStr, queryHandler, queryHandler

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

Cond

public Cond(IDatabase owner,
            String dataSourceName)

Method Detail

create
```
public static Cond create()
```

create

public static Cond create(IDatabase owner)

create

public static Cond create(IDatabase owner,
                          String dataSourceName)

create

public static Cond create(Query<?> query)

params
```
public Params params()
```

param
```
public Cond param(Object param)
```

param
```
public Cond param(Params params)
```

cond
```
public Cond cond(String cond)
```

cond
```
public Cond cond(IFunction func)
```

cond
```
public Cond cond(Cond cond)
```

cond

public Cond cond(FieldCondition cond)

cond

public Cond cond(Cond.LogicalOpt opt,
                 Object... condArr)

opt

public Cond opt(String fieldOne,
                Cond.OPT opt,
                String fieldTwo)

optWrap

public Cond optWrap(String fieldOne,
                    Cond.OPT opt,
                    String fieldTwo)

opt

public Cond opt(String field,
                Cond.OPT opt)

optWrap

public Cond optWrap(String field,
                    Cond.OPT opt)

opt

public Cond opt(IFunction funcOne,
                Cond.OPT opt,
                IFunction funcTwo)

opt

public Cond opt(IFunction func,
                Cond.OPT opt)

opt
```
public Cond opt(Cond.LogicalOpt opt)
```

optIfNeed

public Cond optIfNeed(Cond.LogicalOpt opt)

eqOne
```
public Cond eqOne()
```
Returns:

用于生成Where条件辅助表达式1=1

eqField

public Cond eqField(String fieldOne,
                    String fieldTwo)

eqFieldWrap

public Cond eqFieldWrap(String fieldOne,
                        String fieldTwo)

eq

public Cond eq(String prefix,
               String field)

eq
```
public Cond eq(String field)
```

eqWrap

public Cond eqWrap(String prefix,
                   String field)

eqWrap
```
public Cond eqWrap(String field)
```

eq

public Cond eq(IFunction funcOne,
               IFunction funcTwo)

eq
```
public Cond eq(IFunction func)
```

notEqField

public Cond notEqField(String fieldOne,
                       String fieldTwo)

notEqFieldWrap

public Cond notEqFieldWrap(String fieldOne,
                           String fieldTwo)

notEq

public Cond notEq(String prefix,
                  String field)

notEq
```
public Cond notEq(String field)
```

notEqWrap

public Cond notEqWrap(String prefix,
                      String field)

notEqWrap
```
public Cond notEqWrap(String field)
```

notEq

public Cond notEq(IFunction funcOne,
                  IFunction funcTwo)

notEq
```
public Cond notEq(IFunction func)
```

gtEqField

public Cond gtEqField(String fieldOne,
                      String fieldTwo)

gtEqFieldWrap

public Cond gtEqFieldWrap(String fieldOne,
                          String fieldTwo)

gtEq
```
public Cond gtEq(String field)
```

gtEq

public Cond gtEq(String prefix,
                 String field)

gtEqWrap
```
public Cond gtEqWrap(String field)
```

gtEqWrap

public Cond gtEqWrap(String prefix,
                     String field)

gtEq

public Cond gtEq(IFunction funcOne,
                 IFunction funcTwo)

gtEq
```
public Cond gtEq(IFunction func)
```

gtField

public Cond gtField(String fieldOne,
                    String fieldTwo)

gtFieldWrap

public Cond gtFieldWrap(String fieldOne,
                        String fieldTwo)

gt
```
public Cond gt(String field)
```

gt

public Cond gt(String prefix,
               String field)

gtWrap
```
public Cond gtWrap(String field)
```

gtWrap

public Cond gtWrap(String prefix,
                   String field)

gt

public Cond gt(IFunction funcOne,
               IFunction funcTwo)

gt
```
public Cond gt(IFunction func)
```

ltEqField

public Cond ltEqField(String fieldOne,
                      String fieldTwo)

ltEqFieldWrap

public Cond ltEqFieldWrap(String fieldOne,
                          String fieldTwo)

ltEq
```
public Cond ltEq(String field)
```

ltEq

public Cond ltEq(String prefix,
                 String field)

ltEqWrap
```
public Cond ltEqWrap(String field)
```

ltEqWrap

public Cond ltEqWrap(String prefix,
                     String field)

ltEq

public Cond ltEq(IFunction funcOne,
                 IFunction funcTwo)

ltEq
```
public Cond ltEq(IFunction func)
```

ltField

public Cond ltField(String fieldOne,
                    String fieldTwo)

ltFieldWrap

public Cond ltFieldWrap(String fieldOne,
                        String fieldTwo)

lt
```
public Cond lt(String field)
```

lt

public Cond lt(String prefix,
               String field)

ltWrap
```
public Cond ltWrap(String field)
```

ltWrap

public Cond ltWrap(String prefix,
                   String field)

lt

public Cond lt(IFunction funcOne,
               IFunction funcTwo)

lt
```
public Cond lt(IFunction func)
```

like
```
public Cond like(String field)
```

like

public Cond like(String prefix,
                 String field)

likeWrap
```
public Cond likeWrap(String field)
```

likeWrap

public Cond likeWrap(String prefix,
                     String field)

like
```
public Cond like(IFunction func)
```

between

public Cond between(String field,
                    Object valueOne,
                    Object valueTwo)

between

public Cond between(String prefix,
                    String field,
                    Object valueOne,
                    Object valueTwo)

betweenWrap

public Cond betweenWrap(String field,
                        Object valueOne,
                        Object valueTwo)

betweenWrap

public Cond betweenWrap(String prefix,
                        String field,
                        Object valueOne,
                        Object valueTwo)

between

public Cond between(IFunction func,
                    Object valueOne,
                    Object valueTwo)

range

public Cond range(String field,
                  Object valueOne,
                  Object valueTwo,
                  Cond.LogicalOpt opt)

range

public Cond range(String prefix,
                  String field,
                  Object valueOne,
                  Object valueTwo,
                  Cond.LogicalOpt opt)

rangeWrap

public Cond rangeWrap(String field,
                      Object valueOne,
                      Object valueTwo,
                      Cond.LogicalOpt opt)

rangeWrap

public Cond rangeWrap(String prefix,
                      String field,
                      Object valueOne,
                      Object valueTwo,
                      Cond.LogicalOpt opt)

range

public Cond range(IFunction func,
                  Object valueOne,
                  Object valueTwo,
                  Cond.LogicalOpt opt)

isNull

public Cond isNull(String prefix,
                   String field)

isNull
```
public Cond isNull(String field)
```

isNullWrap

public Cond isNullWrap(String prefix,
                       String field)

isNullWrap
```
public Cond isNullWrap(String field)
```

isNull
```
public Cond isNull(IFunction func)
```

isNotNull

public Cond isNotNull(String prefix,
                      String field)

isNotNull
```
public Cond isNotNull(String field)
```

isNotNullWrap

public Cond isNotNullWrap(String prefix,
                          String field)

isNotNullWrap

public Cond isNotNullWrap(String field)

isNotNull

public Cond isNotNull(IFunction func)

and
```
public Cond and()
```

and
```
public Cond and(Cond cond)
```

and
```
public Cond and(FieldCondition cond)
```

andIfNeed
```
public Cond andIfNeed()
```

andIfNeed
```
public Cond andIfNeed(Cond cond)
```

andIfNeed

public Cond andIfNeed(FieldCondition cond)

or
```
public Cond or()
```

or
```
public Cond or(Cond cond)
```

or
```
public Cond or(FieldCondition cond)
```

orIfNeed
```
public Cond orIfNeed()
```

orIfNeed
```
public Cond orIfNeed(Cond cond)
```

orIfNeed

public Cond orIfNeed(FieldCondition cond)

not
```
public Cond not()
```

not
```
public Cond not(Cond cond)
```

not
```
public Cond not(FieldCondition cond)
```

notIfNeed
```
public Cond notIfNeed()
```

notIfNeed
```
public Cond notIfNeed(Cond cond)
```

notIfNeed

public Cond notIfNeed(FieldCondition cond)

bracketBegin
```
public Cond bracketBegin()
```

bracketEnd
```
public Cond bracketEnd()
```

bracket
```
public Cond bracket(Cond cond)
```

bracket

public Cond bracket(FieldCondition cond)

brackets
```
public Cond brackets()
```

exists
```
public Cond exists(SQL subSql)
```

exists
```
public Cond exists(Select subSql)
```

in

public Cond in(String prefix,
               String field,
               SQL subSql)

in

public Cond in(String field,
               SQL subSql)

inWrap

public Cond inWrap(String prefix,
                   String field,
                   SQL subSql)

inWrap

public Cond inWrap(String field,
                   SQL subSql)

in

public Cond in(String prefix,
               String field,
               Select subSql)

in

public Cond in(String field,
               Select subSql)

inWrap

public Cond inWrap(String prefix,
                   String field,
                   Select subSql)

inWrap

public Cond inWrap(String field,
                   Select subSql)

in

public Cond in(String prefix,
               String field,
               Params params)

in

public Cond in(String field,
               Params params)

inWrap

public Cond inWrap(String prefix,
                   String field,
                   Params params)

inWrap

public Cond inWrap(String field,
                   Params params)

expr
```
public Cond expr(boolean expression,
                 IConditionBuilder builder)
```
Parameters:

expression - 逻辑表达式

builder - 条件构建器

Returns:

根据逻辑表达式运算结果决定是否采纳cond条件

expr
```
public Cond expr(boolean expression,
                 IConditionAppender appender)
```
Parameters:

expression - 逻辑表达式

appender - 条件追加器

Returns:

根据逻辑表达式运算结果决定是否采纳cond条件

expr

public Cond expr(boolean expression,
                 String cond)

exprNotEmpty

public Cond exprNotEmpty(Object target,
                         IConditionBuilder builder)

Parameters:: target - 目标对象; builder - 条件构建器
Returns:: 当目标对象非空则采纳cond条件

exprNotEmpty

public Cond exprNotEmpty(Object target,
                         IConditionAppender appender)

Parameters:: target - 目标对象; appender - 条件追加器
Returns:: 当目标对象非空则采纳cond条件

isEmpty
```
public boolean isEmpty()
```

buildWhere
```
public Where buildWhere()
```
通过当前条件对象创建Where对象实例

Returns:

返回Where对象实例

Since:

2.1.0

build
```
public String build()
```

toString
```
public String toString()
```
Overrides:

toString in class Object

Class Cond

Nested Class Summary

Nested classes/interfaces inherited from class net.ymate.platform.persistence.jdbc.query.Query

Field Summary

Fields inherited from class net.ymate.platform.persistence.jdbc.query.Query

Constructor Summary

Method Summary

Methods inherited from class net.ymate.platform.persistence.jdbc.query.Query

Methods inherited from class net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter

Methods inherited from class java.lang.Object

Constructor Detail

Cond

Method Detail

create

create

create

create

params

param

param

cond

cond

cond

cond

cond

opt

optWrap

opt

optWrap

opt

opt

opt

optIfNeed

eqOne

eqField

eqFieldWrap

eq

eq

eqWrap

eqWrap

eq

eq

notEqField

notEqFieldWrap

notEq

notEq

notEqWrap

notEqWrap

notEq

notEq

gtEqField

gtEqFieldWrap

gtEq

gtEq

gtEqWrap

gtEqWrap

gtEq

gtEq

gtField

gtFieldWrap

gt

gt

gtWrap

gtWrap

gt

gt

ltEqField

ltEqFieldWrap

ltEq

ltEq

ltEqWrap

ltEqWrap

ltEq

ltEq

ltField

ltFieldWrap

lt

lt

ltWrap

ltWrap