ConditionFactory (abacus-util 1.21.8 API)

java.lang.Object
- com.landawn.abacus.condition.ConditionFactory

Direct Known Subclasses:

ConditionFactory.CF
```
public class ConditionFactory
extends Object
```
A factory for creating Condition objects.

Since:

0.8

Author:

Haiyang Li

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class ConditionFactory.CB

static class ConditionFactory.CF
The Class CF.

Nested Classes
Modifier and Type	Class and Description
`static class`	`ConditionFactory.CB`
`static class`	`ConditionFactory.CF` The Class CF.

Field Summary

Fields
Modifier and Type Field and Description

static SortDirection ASC

static SortDirection DESC

static Expression QME
Expression with question mark literal: "?".

Fields
Modifier and Type	Field and Description
`static SortDirection`	`ASC`
`static SortDirection`	`DESC`
`static Expression`	`QME` Expression with question mark literal: "?".

Method Summary

All Methods Static Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`static All`	`all(SubQuery condition)`
`static Expression`	`alwaysFalse()` Deprecated.
`static Expression`	`alwaysTrue()`
`static And`	`and(Collection<? extends Condition> conditions)`
`static And`	`and(Condition... conditions)`
`static Any`	`any(SubQuery condition)`
`static Between`	`between(String propName)`
`static Between`	`between(String propName, Object minValue, Object maxValue)`
`static Binary`	`binary(String propName, Operator operator, Object propValue)`
`static Between`	`bt(String propName)`
`static Between`	`bt(String propName, Object minValue, Object maxValue)`
`static Cell`	`cell(Operator operator, Condition condition)`
`static Like`	`contains(String propName, Object propValue)`
`static Criteria`	`criteria()`
`static CrossJoin`	`crossJoin(Collection<String> joinEntities, Condition condition)`
`static CrossJoin`	`crossJoin(String joinEntity)`
`static CrossJoin`	`crossJoin(String joinEntity, Condition condition)`
`static Like`	`endsWith(String propName, Object propValue)`
`static Equal`	`eq(String propName)` It's for parameterized SQL with question mark or named parameters.
`static Equal`	`eq(String propName, Object propValue)`
`static And`	`eqAnd(Map<String,?> props)`
`static And`	`eqAnd(Object entity)`
`static And`	`eqAnd(Object entity, Collection<String> selectPropNames)`
`static And`	`eqAnd(String propName1, Object propValue1, String propName2, Object propValue2)`
`static And`	`eqAnd(String propName1, Object propValue1, String propName2, Object propValue2, String propName3, Object propValue3)`
`static Or`	`eqAndOr(Collection<?> entities)` Eq and or.
`static Or`	`eqAndOr(Collection<?> entities, Collection<String> selectPropNames)` Eq and or.
`static Or`	`eqAndOr(List<? extends Map<String,?>> propsList)` Eq and or.
`static Or`	`eqOr(Map<String,?> props)`
`static Or`	`eqOr(Object entity)`
`static Or`	`eqOr(Object entity, Collection<String> selectPropNames)`
`static Or`	`eqOr(String propName, Collection<?> propValues)`
`static Or`	`eqOr(String propName, Object... propValues)`
`static Or`	`eqOr(String propName1, Object propValue1, String propName2, Object propValue2)`
`static Or`	`eqOr(String propName1, Object propValue1, String propName2, Object propValue2, String propName3, Object propValue3)`
`static Equal`	`equal(String propName)` It's for parameterized SQL with question mark or named parameters.
`static Equal`	`equal(String propName, Object propValue)`
`static Except`	`except(SubQuery condition)`
`static Exists`	`exists(SubQuery condition)`
`static Expression`	`expr(String literal)`
`static FullJoin`	`fullJoin(Collection<String> joinEntities, Condition condition)`
`static FullJoin`	`fullJoin(String joinEntity)`
`static FullJoin`	`fullJoin(String joinEntity, Condition condition)`
`static GreaterEqual`	`ge(String propName)` It's for parameterized SQL with question mark or named parameters.
`static GreaterEqual`	`ge(String propName, Object propValue)`
`static And`	`geAndLt(String propName, Object minValue, Object maxValue)`
`static GreaterEqual`	`greaterEqual(String propName)` It's for parameterized SQL with question mark or named parameters.
`static GreaterEqual`	`greaterEqual(String propName, Object propValue)`
`static GreaterThan`	`greaterThan(String propName)` It's for parameterized SQL with question mark or named parameters.
`static GreaterThan`	`greaterThan(String propName, Object propValue)`
`static GroupBy`	`groupBy(Collection<String> propNames)`
`static GroupBy`	`groupBy(Collection<String> propNames, SortDirection direction)`
`static GroupBy`	`groupBy(Condition condition)`
`static GroupBy`	`groupBy(LinkedHashMap<String,SortDirection> orders)`
`static GroupBy`	`groupBy(Map<String,SortDirection> orders)`
`static GroupBy`	`groupBy(String... propNames)`
`static GroupBy`	`groupBy(String propName, SortDirection direction)`
`static GroupBy`	`groupBy(String propNameA, SortDirection directionA, String propNameB, SortDirection directionB)`
`static GroupBy`	`groupBy(String propNameA, SortDirection directionA, String propNameB, SortDirection directionB, String propNameC, SortDirection directionC)`
`static GreaterThan`	`gt(String propName)` It's for parameterized SQL with question mark or named parameters.
`static GreaterThan`	`gt(String propName, Object propValue)`
`static And`	`gtAndLt(String propName, Object minValue, Object maxValue)`
`static Having`	`having(Condition condition)`
`static Having`	`having(String condition)`
`static Or`	`id2Cond(Collection<? extends EntityId> entityIds)`
`static And`	`id2Cond(EntityId entityId)`
`static In`	`in(String propName, Collection<?> values)`
`static In`	`in(String propName, double[] values)`
`static In`	`in(String propName, int[] values)`
`static In`	`in(String propName, long[] values)`
`static In`	`in(String propName, Object[] values)`
`static InSubQuery`	`in(String propName, SubQuery subQuery)`
`static InnerJoin`	`innerJoin(Collection<String> joinEntities, Condition condition)`
`static InnerJoin`	`innerJoin(String joinEntity)`
`static InnerJoin`	`innerJoin(String joinEntity, Condition condition)`
`static Intersect`	`intersect(SubQuery condition)`
`static Is`	`is(String propName, Object propValue)` Checks if is.
`static IsInfinite`	`isInfinite(String propName)` Checks if is infinite.
`static IsNaN`	`isNaN(String propName)` Checks if is na N.
`static IsNot`	`isNot(String propName, Object propValue)` Checks if is not.
`static IsNotInfinite`	`isNotInfinite(String propName)` Checks if is not infinite.
`static IsNotNaN`	`isNotNaN(String propName)` Checks if is not na N.
`static IsNotNull`	`isNotNull(String propName)` Checks if is not null.
`static IsNull`	`isNull(String propName)` Checks if is null.
`static Join`	`join(Collection<String> joinEntities, Condition condition)`
`static Join`	`join(String joinEntity)`
`static Join`	`join(String joinEntity, Condition condition)`
`static Junction`	`junction(Operator operator, Collection<? extends Condition> conditions)`
`static Junction`	`junction(Operator operator, Condition... conditions)`
`static LessEqual`	`le(String propName)` It's for parameterized SQL with question mark or named parameters.
`static LessEqual`	`le(String propName, Object propValue)`
`static LeftJoin`	`leftJoin(Collection<String> joinEntities, Condition condition)`
`static LeftJoin`	`leftJoin(String joinEntity)`
`static LeftJoin`	`leftJoin(String joinEntity, Condition condition)`
`static LessEqual`	`lessEqual(String propName)` It's for parameterized SQL with question mark or named parameters.
`static LessEqual`	`lessEqual(String propName, Object propValue)`
`static LessThan`	`lessThan(String propName)` It's for parameterized SQL with question mark or named parameters.
`static LessThan`	`lessThan(String propName, Object propValue)`
`static Like`	`like(String propName)`
`static Like`	`like(String propName, Object propValue)`
`static Limit`	`limit(int count)`
`static Limit`	`limit(int offset, int count)`
`static Limit`	`limit(String expr)`
`static LessThan`	`lt(String propName)` It's for parameterized SQL with question mark or named parameters.
`static LessThan`	`lt(String propName, Object propValue)`
`static Minus`	`minus(SubQuery condition)`
`static NamedProperty`	`namedProperty(String propName)`
`static NaturalJoin`	`naturalJoin(Collection<String> joinEntities, Condition condition)`
`static NaturalJoin`	`naturalJoin(String joinEntity)`
`static NaturalJoin`	`naturalJoin(String joinEntity, Condition condition)`
`static NotEqual`	`ne(String propName)` It's for parameterized SQL with question mark or named parameters.
`static NotEqual`	`ne(String propName, Object propValue)`
`static NotEqual`	`notEqual(String propName)` It's for parameterized SQL with question mark or named parameters.
`static NotEqual`	`notEqual(String propName, Object propValue)`
`static Not`	`notExists(SubQuery condition)`
`static Not`	`notLike(String propName)`
`static Not`	`notLike(String propName, Object propValue)`
`static On`	`on(Condition condition)`
`static On`	`on(Map<String,String> propNamePair)`
`static On`	`on(String condition)`
`static On`	`on(String propName, String anoPropName)`
`static Or`	`or(Collection<? extends Condition> conditions)`
`static Or`	`or(Condition... conditions)`
`static OrderBy`	`orderBy(Collection<String> propNames)`
`static OrderBy`	`orderBy(Collection<String> propNames, SortDirection direction)`
`static OrderBy`	`orderBy(Condition condition)`
`static OrderBy`	`orderBy(LinkedHashMap<String,SortDirection> orders)`
`static OrderBy`	`orderBy(Map<String,SortDirection> orders)`
`static OrderBy`	`orderBy(String... propNames)`
`static OrderBy`	`orderBy(String propName, SortDirection direction)`
`static OrderBy`	`orderBy(String propNameA, SortDirection directionA, String propNameB, SortDirection directionB)`
`static OrderBy`	`orderBy(String propNameA, SortDirection directionA, String propNameB, SortDirection directionB, String propNameC, SortDirection directionC)`
`static OrderBy`	`orderByAsc(String... propNames)`
`static OrderBy`	`orderByDesc(String... propNames)`
`static RightJoin`	`rightJoin(Collection<String> joinEntities, Condition condition)`
`static RightJoin`	`rightJoin(String joinEntity)`
`static RightJoin`	`rightJoin(String joinEntity, Condition condition)`
`static Some`	`some(SubQuery condition)`
`static Like`	`startsWith(String propName, Object propValue)`
`static SubQuery`	`subQuery(Class<?> entityClass, Collection<String> propNames, Condition condition)`
`static SubQuery`	`subQuery(String entityName, Collection<String> propNames, Condition condition)`
`static SubQuery`	`subQuery(String entityName, Collection<String> propNames, String condition)`
`static SubQuery`	`subQuery(String entityName, String sql)`
`static Union`	`union(SubQuery condition)`
`static UnionAll`	`unionAll(SubQuery condition)`
`static Using`	`using(Collection<String> columnNames)` Deprecated.
`static Using`	`using(String... columnNames)` Deprecated.
`static Where`	`where(Condition condition)`
`static Where`	`where(String condition)`
`static XOR`	`xor(String propName, Object propValue)`

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

Field Detail

QME
```
public static final Expression QME
```
Expression with question mark literal: "?".

ASC
```
public static final SortDirection ASC
```

DESC
```
public static final SortDirection DESC
```

Method Detail

alwaysTrue
```
public static Expression alwaysTrue()
```

alwaysFalse

@Deprecated
public static Expression alwaysFalse()

Deprecated.

namedProperty

public static NamedProperty namedProperty(String propName)

Parameters:: propName -
Returns:

expr

public static Expression expr(String literal)

Parameters:: literal -
Returns:

binary

public static Binary binary(String propName,
                            Operator operator,
                            Object propValue)

Parameters:: propName -; operator -; propValue -
Returns:

equal

public static Equal equal(String propName,
                          Object propValue)

Parameters:: propName -; propValue -
Returns:

equal
```
public static Equal equal(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

eq

public static Equal eq(String propName,
                       Object propValue)

Parameters:: propName -; propValue -
Returns:

eq
```
public static Equal eq(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

eqOr

@SafeVarargs
public static Or eqOr(String propName,
                                    Object... propValues)

Parameters:: propName -; propValues -
Returns:

eqOr

public static Or eqOr(String propName,
                      Collection<?> propValues)

Parameters:: propName -; propValues -
Returns:

eqOr

public static Or eqOr(Map<String,?> props)

Parameters:: props -
Returns:

eqOr
```
public static Or eqOr(Object entity)
```
Parameters:

entity -

Returns:

eqOr

public static Or eqOr(Object entity,
                      Collection<String> selectPropNames)

Parameters:: entity -; selectPropNames -
Returns:

eqOr

public static Or eqOr(String propName1,
                      Object propValue1,
                      String propName2,
                      Object propValue2)

eqOr

public static Or eqOr(String propName1,
                      Object propValue1,
                      String propName2,
                      Object propValue2,
                      String propName3,
                      Object propValue3)

eqAnd

public static And eqAnd(Map<String,?> props)

Parameters:: props -
Returns:

eqAnd

public static And eqAnd(Object entity)

Parameters:: entity -
Returns:

eqAnd

public static And eqAnd(Object entity,
                        Collection<String> selectPropNames)

Parameters:: entity -; selectPropNames -
Returns:

eqAndOr

public static Or eqAndOr(List<? extends Map<String,?>> propsList)

Eq and or.

Parameters:: propsList -
Returns:

eqAndOr

public static Or eqAndOr(Collection<?> entities)

Eq and or.

Parameters:: entities -
Returns:

eqAndOr

public static Or eqAndOr(Collection<?> entities,
                         Collection<String> selectPropNames)

Eq and or.

Parameters:: entities -; selectPropNames -
Returns:

eqAnd

public static And eqAnd(String propName1,
                        Object propValue1,
                        String propName2,
                        Object propValue2)

eqAnd

public static And eqAnd(String propName1,
                        Object propValue1,
                        String propName2,
                        Object propValue2,
                        String propName3,
                        Object propValue3)

gtAndLt

public static And gtAndLt(String propName,
                          Object minValue,
                          Object maxValue)

geAndLt

public static And geAndLt(String propName,
                          Object minValue,
                          Object maxValue)

id2Cond

public static And id2Cond(EntityId entityId)

Parameters:: entity -
Returns:

id2Cond

public static Or id2Cond(Collection<? extends EntityId> entityIds)

notEqual

public static NotEqual notEqual(String propName,
                                Object propValue)

Parameters:: propName -; propValue -
Returns:

notEqual
```
public static NotEqual notEqual(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

ne

public static NotEqual ne(String propName,
                          Object propValue)

Parameters:: propName -; propValue -
Returns:

ne
```
public static NotEqual ne(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

greaterThan

public static GreaterThan greaterThan(String propName,
                                      Object propValue)

Parameters:: propName -; propValue -
Returns:

greaterThan
```
public static GreaterThan greaterThan(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

gt

public static GreaterThan gt(String propName,
                             Object propValue)

Parameters:: propName -; propValue -
Returns:

gt
```
public static GreaterThan gt(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

greaterEqual

public static GreaterEqual greaterEqual(String propName,
                                        Object propValue)

Parameters:: propName -; propValue -
Returns:

greaterEqual
```
public static GreaterEqual greaterEqual(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

ge

public static GreaterEqual ge(String propName,
                              Object propValue)

Parameters:: propName -; propValue -
Returns:

ge
```
public static GreaterEqual ge(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

lessThan

public static LessThan lessThan(String propName,
                                Object propValue)

Parameters:: propName -; propValue -
Returns:

lessThan
```
public static LessThan lessThan(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

lt

public static LessThan lt(String propName,
                          Object propValue)

Parameters:: propName -; propValue -
Returns:

lt
```
public static LessThan lt(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

lessEqual

public static LessEqual lessEqual(String propName,
                                  Object propValue)

Parameters:: propName -; propValue -
Returns:

lessEqual
```
public static LessEqual lessEqual(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

le

public static LessEqual le(String propName,
                           Object propValue)

Parameters:: propName -; propValue -
Returns:

le
```
public static LessEqual le(String propName)
```
It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

between

public static Between between(String propName,
                              Object minValue,
                              Object maxValue)

Parameters:: propName -; minValue -; maxValue -
Returns:

between

public static Between between(String propName)

Parameters:: propName -
Returns:

bt

public static Between bt(String propName,
                         Object minValue,
                         Object maxValue)

Parameters:: propName -; minValue -; maxValue -
Returns:

bt

public static Between bt(String propName)

Parameters:: propName -
Returns:

like

public static Like like(String propName,
                        Object propValue)

Parameters:: propName -; propValue -
Returns:

like

public static Like like(String propName)

Parameters:: propName -
Returns:

notLike

public static Not notLike(String propName,
                          Object propValue)

Parameters:: propName -; propValue -
Returns:

notLike

public static Not notLike(String propName)

Parameters:: propName -
Returns:

contains

public static Like contains(String propName,
                            Object propValue)

Parameters:: propName -; propValue -
Returns:

startsWith

public static Like startsWith(String propName,
                              Object propValue)

Parameters:: propName -; propValue -
Returns:

endsWith

public static Like endsWith(String propName,
                            Object propValue)

Parameters:: propName -; propValue -
Returns:

isNull

public static IsNull isNull(String propName)

Checks if is null.

Parameters:: propName -
Returns:

isNotNull

public static IsNotNull isNotNull(String propName)

Checks if is not null.

Parameters:: propName -
Returns:

isNaN

public static IsNaN isNaN(String propName)

Checks if is na N.

Parameters:: propName -
Returns:

isNotNaN
```
public static IsNotNaN isNotNaN(String propName)
```
Checks if is not na N.

Parameters:

propName -

Returns:

isInfinite

public static IsInfinite isInfinite(String propName)

Checks if is infinite.

Parameters:: propName -
Returns:

isNotInfinite

public static IsNotInfinite isNotInfinite(String propName)

Checks if is not infinite.

Parameters:: propName -
Returns:

is

public static Is is(String propName,
                    Object propValue)

Checks if is.

Parameters:: propName -; propValue -
Returns:

isNot

public static IsNot isNot(String propName,
                          Object propValue)

Checks if is not.

Parameters:: propName -; propValue -
Returns:

xor

public static XOR xor(String propName,
                      Object propValue)

Parameters:: propName -; propValue -
Returns:

or

@SafeVarargs
public static Or or(Condition... conditions)

Parameters:: conditions -
Returns:

or

public static Or or(Collection<? extends Condition> conditions)

Parameters:: conditions -
Returns:

and

@SafeVarargs
public static And and(Condition... conditions)

Parameters:: conditions -
Returns:

and

public static And and(Collection<? extends Condition> conditions)

Parameters:: conditions -
Returns:

junction

@SafeVarargs
public static Junction junction(Operator operator,
                                              Condition... conditions)

Parameters:: operator -; conditions -
Returns:

junction

public static Junction junction(Operator operator,
                                Collection<? extends Condition> conditions)

Parameters:: operator -; conditions -
Returns:

where

public static Where where(Condition condition)

Parameters:: condition -
Returns:

where

public static Where where(String condition)

Parameters:: condition -
Returns:

groupBy

@SafeVarargs
public static GroupBy groupBy(String... propNames)

Parameters:: propNames -
Returns:

groupBy

public static GroupBy groupBy(Collection<String> propNames)

Parameters:: propNames -
Returns:

groupBy

public static GroupBy groupBy(Collection<String> propNames,
                              SortDirection direction)

Parameters:: propNames -; direction -
Returns:

groupBy

public static GroupBy groupBy(String propName,
                              SortDirection direction)

Parameters:: propName -; direction -
Returns:

groupBy

public static GroupBy groupBy(String propNameA,
                              SortDirection directionA,
                              String propNameB,
                              SortDirection directionB)

Parameters:: propNameA -; directionA -; propNameB -; directionB -
Returns:

groupBy

public static GroupBy groupBy(String propNameA,
                              SortDirection directionA,
                              String propNameB,
                              SortDirection directionB,
                              String propNameC,
                              SortDirection directionC)

Parameters:: propNameA -; directionA -; propNameB -; directionB -; propNameC -; directionC -
Returns:

groupBy

public static GroupBy groupBy(Map<String,SortDirection> orders)

Parameters:: orders - should be a LinkedHashMap
Returns:

groupBy

public static GroupBy groupBy(LinkedHashMap<String,SortDirection> orders)

Parameters:: orders -
Returns:

groupBy

public static GroupBy groupBy(Condition condition)

Parameters:: condition -
Returns:

having

public static Having having(Condition condition)

Parameters:: condition -
Returns:

having

public static Having having(String condition)

Parameters:: condition -
Returns:

orderBy

@SafeVarargs
public static OrderBy orderBy(String... propNames)

Parameters:: propNames -
Returns:

orderByAsc

@SafeVarargs
public static OrderBy orderByAsc(String... propNames)

Parameters:: propNames -
Returns:

orderByDesc

@SafeVarargs
public static OrderBy orderByDesc(String... propNames)

Parameters:: propNames -
Returns:

orderBy

public static OrderBy orderBy(Collection<String> propNames)

Parameters:: propNames -
Returns:

orderBy

public static OrderBy orderBy(Collection<String> propNames,
                              SortDirection direction)

Parameters:: propNames -; direction -
Returns:

orderBy

public static OrderBy orderBy(String propName,
                              SortDirection direction)

Parameters:: propName -; direction -
Returns:

orderBy

public static OrderBy orderBy(String propNameA,
                              SortDirection directionA,
                              String propNameB,
                              SortDirection directionB)

Parameters:: propNameA -; directionA -; propNameB -; directionB -
Returns:

orderBy

public static OrderBy orderBy(String propNameA,
                              SortDirection directionA,
                              String propNameB,
                              SortDirection directionB,
                              String propNameC,
                              SortDirection directionC)

Parameters:: propNameA -; directionA -; propNameB -; directionB -; propNameC -; directionC -
Returns:

orderBy

public static OrderBy orderBy(Map<String,SortDirection> orders)

Parameters:: orders - should be a LinkedHashMap
Returns:

orderBy

public static OrderBy orderBy(LinkedHashMap<String,SortDirection> orders)

Parameters:: orders -
Returns:

orderBy

public static OrderBy orderBy(Condition condition)

Parameters:: condition -
Returns:

on

public static On on(Condition condition)

Parameters:: condition -
Returns:

on

public static On on(String condition)

Parameters:: condition -
Returns:

on

public static On on(String propName,
                    String anoPropName)

Parameters:: propName -; anoPropName -
Returns:

on

public static On on(Map<String,String> propNamePair)

Parameters:: propNamePair -
Returns:

using
```
@Deprecated
 @SafeVarargs
public static Using using(String... columnNames)
```
Deprecated.

It's recommended to use On, instead of Using.

Parameters:

columnNames -

Returns:

using
```
@Deprecated
public static Using using(Collection<String> columnNames)
```
Deprecated.

It's recommended to use On, instead of Using.

Parameters:

columnNames -

Returns:

join

public static Join join(String joinEntity)

Parameters:: joinEntity -
Returns:

join

public static Join join(String joinEntity,
                        Condition condition)

Parameters:: joinEntity -; condition -
Returns:

join

public static Join join(Collection<String> joinEntities,
                        Condition condition)

Parameters:: joinEntities -; condition -
Returns:

leftJoin

public static LeftJoin leftJoin(String joinEntity)

Parameters:: joinEntity -
Returns:

leftJoin

public static LeftJoin leftJoin(String joinEntity,
                                Condition condition)

Parameters:: joinEntity -; condition -
Returns:

leftJoin

public static LeftJoin leftJoin(Collection<String> joinEntities,
                                Condition condition)

Parameters:: joinEntities -; condition -
Returns:

rightJoin

public static RightJoin rightJoin(String joinEntity)

Parameters:: joinEntity -
Returns:

rightJoin

public static RightJoin rightJoin(String joinEntity,
                                  Condition condition)

Parameters:: joinEntity -; condition -
Returns:

rightJoin

public static RightJoin rightJoin(Collection<String> joinEntities,
                                  Condition condition)

Parameters:: joinEntities -; condition -
Returns:

crossJoin

public static CrossJoin crossJoin(String joinEntity)

Parameters:: joinEntity -
Returns:

crossJoin

public static CrossJoin crossJoin(String joinEntity,
                                  Condition condition)

Parameters:: joinEntity -; condition -
Returns:

crossJoin

public static CrossJoin crossJoin(Collection<String> joinEntities,
                                  Condition condition)

Parameters:: joinEntities -; condition -
Returns:

fullJoin

public static FullJoin fullJoin(String joinEntity)

Parameters:: joinEntity -
Returns:

fullJoin

public static FullJoin fullJoin(String joinEntity,
                                Condition condition)

Parameters:: joinEntity -; condition -
Returns:

fullJoin

public static FullJoin fullJoin(Collection<String> joinEntities,
                                Condition condition)

Parameters:: joinEntities -; condition -
Returns:

innerJoin

public static InnerJoin innerJoin(String joinEntity)

Parameters:: joinEntity -
Returns:

innerJoin

public static InnerJoin innerJoin(String joinEntity,
                                  Condition condition)

Parameters:: joinEntity -; condition -
Returns:

innerJoin

public static InnerJoin innerJoin(Collection<String> joinEntities,
                                  Condition condition)

Parameters:: joinEntities -; condition -
Returns:

naturalJoin

public static NaturalJoin naturalJoin(String joinEntity)

Parameters:: joinEntity -
Returns:

naturalJoin

public static NaturalJoin naturalJoin(String joinEntity,
                                      Condition condition)

Parameters:: joinEntity -; condition -
Returns:

naturalJoin

public static NaturalJoin naturalJoin(Collection<String> joinEntities,
                                      Condition condition)

Parameters:: joinEntities -; condition -
Returns:

in

public static In in(String propName,
                    int[] values)

Parameters:: propName -; values -
Returns:

in

public static In in(String propName,
                    long[] values)

Parameters:: propName -; values -
Returns:

in

public static In in(String propName,
                    double[] values)

Parameters:: propName -; values -
Returns:

in

public static In in(String propName,
                    Object[] values)

Parameters:: propName -; values -
Returns:

in

public static In in(String propName,
                    Collection<?> values)

Parameters:: propName -; values -
Returns:

in

public static InSubQuery in(String propName,
                            SubQuery subQuery)

Parameters:: propName -; subQuery -
Returns:

all

public static All all(SubQuery condition)

Parameters:: condition -
Returns:

any

public static Any any(SubQuery condition)

Parameters:: condition -
Returns:

some

public static Some some(SubQuery condition)

Parameters:: condition -
Returns:

exists

public static Exists exists(SubQuery condition)

Parameters:: condition -
Returns:

notExists

public static Not notExists(SubQuery condition)

Parameters:: condition -
Returns:

union

public static Union union(SubQuery condition)

Parameters:: condition -
Returns:

unionAll

public static UnionAll unionAll(SubQuery condition)

Parameters:: condition -
Returns:

except

public static Except except(SubQuery condition)

Parameters:: condition -
Returns:

intersect

public static Intersect intersect(SubQuery condition)

Parameters:: condition -
Returns:

minus

public static Minus minus(SubQuery condition)

Parameters:: condition -
Returns:

cell

public static Cell cell(Operator operator,
                        Condition condition)

Parameters:: operator -; condition -
Returns:

subQuery

public static SubQuery subQuery(Class<?> entityClass,
                                Collection<String> propNames,
                                Condition condition)

Parameters:: entityClass -; propNames -; condition -
Returns:

subQuery

public static SubQuery subQuery(String entityName,
                                Collection<String> propNames,
                                Condition condition)

Parameters:: entityName -; propNames -; condition -
Returns:

subQuery

public static SubQuery subQuery(String entityName,
                                Collection<String> propNames,
                                String condition)

Parameters:: entityName -; propNames -; condition -
Returns:

subQuery

public static SubQuery subQuery(String entityName,
                                String sql)

Parameters:: entityName -; sql -
Returns:

limit
```
public static Limit limit(int count)
```
Parameters:

count -

Returns:

limit

public static Limit limit(int offset,
                          int count)

Parameters:: offset -; count -
Returns:

limit

public static Limit limit(String expr)

Parameters:: expr -
Returns:

criteria
```
public static Criteria criteria()
```

Class ConditionFactory

Nested Class Summary

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

QME

ASC

DESC

Method Detail

alwaysTrue

alwaysFalse

namedProperty

expr

binary

equal

equal

eq

eq

eqOr

eqOr

eqOr

eqOr

eqOr

eqOr

eqOr

eqAnd

eqAnd

eqAnd

eqAndOr

eqAndOr

eqAndOr

eqAnd

eqAnd

gtAndLt

geAndLt

id2Cond

id2Cond

notEqual

notEqual

ne

ne

greaterThan

greaterThan

gt

gt

greaterEqual

greaterEqual

ge

ge

lessThan

lessThan

lt

lt

lessEqual

lessEqual

le

le

between

between

bt

bt

like

like

notLike

notLike

contains

startsWith

endsWith

isNull

isNotNull

isNaN

isNotNaN

isInfinite

isNotInfinite

is

isNot

xor

or

or