Criteria (abacus-util 1.21.8 API)

java.lang.Object
- com.landawn.abacus.condition.AbstractCondition
- - com.landawn.abacus.condition.Criteria

All Implemented Interfaces:

Condition, Serializable, Cloneable
```
public class Criteria
extends AbstractCondition
```
At present, Supports Where, OrderBy, GroupBy, Having, Join, Limit, ForUpdate, Union, UnionAll, Intersect, Except clause. Each clause is independent. A clause should not be included in another clause. If there more than one clause, they should be composed in one Criteria condition.

Since:

0.8

Author:

Haiyang Li

See Also:

Serialized Form

Constructor Summary

Constructors
Constructor and Description

Criteria()

Constructors
Constructor and Description
`Criteria()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`clear()` Clear.
`void`	`clearParameters()` Clear parameters.
`<T extends Condition> T`	`copy()`
`Criteria`	`distinct(boolean distinct)`
`boolean`	`equals(Object obj)`
`Criteria`	`except(SubQuery subQuery)`
`List<Condition>`	`get(Operator operator)`
`List<Cell>`	`getAggregation()` Gets the aggregation.
`List<Condition>`	`getConditions()` Gets the conditions.
`Cell`	`getGroupBy()` Gets the group by.
`Cell`	`getHaving()` Gets the having.
`List<Join>`	`getJoins()` Gets the joins.
`Limit`	`getLimit()` Gets the limit.
`Cell`	`getOrderBy()` Gets the order by.
`List<Object>`	`getParameters()` Gets the parameters.
`Cell`	`getWhere()` Gets the where.
`Criteria`	`groupBy(Collection<String> propNames)`
`Criteria`	`groupBy(Collection<String> propNames, SortDirection direction)`
`Criteria`	`groupBy(Condition condition)`
`Criteria`	`groupBy(Map<String,SortDirection> orders)`
`Criteria`	`groupBy(String... propNames)`
`Criteria`	`groupBy(String propName, SortDirection direction)`
`int`	`hashCode()`
`Criteria`	`having(Condition condition)`
`Criteria`	`having(String condition)`
`Criteria`	`intersect(SubQuery subQuery)`
`boolean`	`isDistinct()` Checks if is distinct.
`Criteria`	`join(Collection<Join> joins)`
`Criteria`	`join(Collection<String> joinEntities, Condition condition)`
`Criteria`	`join(Join... joins)`
`Criteria`	`join(String joinEntity)`
`Criteria`	`join(String joinEntity, Condition condition)`
`Criteria`	`limit(int count)`
`Criteria`	`limit(int offset, int count)`
`Criteria`	`limit(Limit condition)`
`Criteria`	`limit(String expr)`
`Criteria`	`minus(SubQuery subQuery)`
`Criteria`	`orderBy(Collection<String> propNames)`
`Criteria`	`orderBy(Collection<String> propNames, SortDirection direction)`
`Criteria`	`orderBy(Condition condition)`
`Criteria`	`orderBy(Map<String,SortDirection> orders)`
`Criteria`	`orderBy(String... propNames)`
`Criteria`	`orderBy(String propName, SortDirection direction)`
`String`	`toString(NamingPolicy namingPolicy)`
`Criteria`	`union(SubQuery subQuery)`
`Criteria`	`unionAll(SubQuery subQuery)`
`Criteria`	`where(Condition condition)`
`Criteria`	`where(String condition)`

Methods inherited from class com.landawn.abacus.condition.AbstractCondition
and, getOperator, not, or, toString

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

Constructor Detail
- Criteria
```
public Criteria()
```

Method Detail

isDistinct
```
public boolean isDistinct()
```
Checks if is distinct.

Returns:

true, if is distinct

getJoins
```
public List<Join> getJoins()
```
Gets the joins.

Returns:

getWhere
```
public Cell getWhere()
```
Gets the where.

Returns:

getGroupBy
```
public Cell getGroupBy()
```
Gets the group by.

Returns:

getHaving
```
public Cell getHaving()
```
Gets the having.

Returns:

getAggregation
```
public List<Cell> getAggregation()
```
Gets the aggregation.

Returns:

getOrderBy
```
public Cell getOrderBy()
```
Gets the order by.

Returns:

getLimit
```
public Limit getLimit()
```
Gets the limit.

Returns:

getConditions

public List<Condition> getConditions()

Gets the conditions.

Returns:

get

public List<Condition> get(Operator operator)

Parameters:: operator -
Returns:

clear
```
public void clear()
```
Clear.

getParameters
```
public List<Object> getParameters()
```
Gets the parameters.

Returns:

clearParameters
```
public void clearParameters()
```
Clear parameters.

distinct

public Criteria distinct(boolean distinct)

Parameters:: distinct -
Returns:

join

@SafeVarargs
public final Criteria join(Join... joins)

Parameters:: joins -
Returns:

join

public Criteria join(Collection<Join> joins)

Parameters:: joins -
Returns:

join

public Criteria join(String joinEntity)

Parameters:: joinEntity -
Returns:

join

public Criteria join(String joinEntity,
                     Condition condition)

Parameters:: joinEntity -; condition -
Returns:

join

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

Parameters:: joinEntities -; condition -
Returns:

where

public Criteria where(Condition condition)

Parameters:: condition -
Returns:

where

public Criteria where(String condition)

Parameters:: condition -
Returns:

groupBy

public Criteria groupBy(Condition condition)

Parameters:: condition -
Returns:

groupBy

@SafeVarargs
public final Criteria groupBy(String... propNames)

Parameters:: propNames -
Returns:

groupBy

public Criteria groupBy(String propName,
                        SortDirection direction)

Parameters:: propName -; direction -
Returns:

groupBy

public Criteria groupBy(Collection<String> propNames)

Parameters:: propNames -
Returns:

groupBy

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

Parameters:: propNames -; direction -
Returns:

groupBy

public Criteria groupBy(Map<String,SortDirection> orders)

Parameters:: orders -
Returns:

having

public Criteria having(Condition condition)

Parameters:: condition -
Returns:

having

public Criteria having(String condition)

Parameters:: condition -
Returns:

orderBy

public Criteria orderBy(Condition condition)

Parameters:: condition -
Returns:

orderBy

@SafeVarargs
public final Criteria orderBy(String... propNames)

Parameters:: propNames -
Returns:

orderBy

public Criteria orderBy(String propName,
                        SortDirection direction)

Parameters:: propName -; direction -
Returns:

orderBy

public Criteria orderBy(Collection<String> propNames)

Parameters:: propNames -
Returns:

orderBy

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

Parameters:: propNames -; direction -
Returns:

orderBy

public Criteria orderBy(Map<String,SortDirection> orders)

Parameters:: orders -
Returns:

limit

public Criteria limit(Limit condition)

Parameters:: condition -
Returns:

limit
```
public Criteria limit(int count)
```
Parameters:

count -

Returns:

limit

public Criteria limit(int offset,
                      int count)

Parameters:: offset -; count -
Returns:

limit
```
public Criteria limit(String expr)
```

union

public Criteria union(SubQuery subQuery)

Parameters:: subQuery -
Returns:

unionAll

public Criteria unionAll(SubQuery subQuery)

Parameters:: subQuery -
Returns:

intersect

public Criteria intersect(SubQuery subQuery)

Parameters:: subQuery -
Returns:

except

public Criteria except(SubQuery subQuery)

Parameters:: subQuery -
Returns:

minus

public Criteria minus(SubQuery subQuery)

Parameters:: subQuery -
Returns:

copy
```
public <T extends Condition> T copy()
```
Specified by:

copy in interface Condition

Overrides:

copy in class AbstractCondition

Type Parameters:

T -

Returns:

toString

public String toString(NamingPolicy namingPolicy)

Parameters:: namingPolicy -
Returns:

hashCode
```
public int hashCode()
```
Overrides:

hashCode in class Object

equals
```
public boolean equals(Object obj)
```
Overrides:

equals in class Object

Parameters:

obj -

Returns:

true, if successful

Class Criteria

Constructor Summary

Method Summary

Methods inherited from class com.landawn.abacus.condition.AbstractCondition

Methods inherited from class java.lang.Object

Constructor Detail

Criteria

Method Detail

isDistinct

getJoins

getWhere

getGroupBy

getHaving

getAggregation

getOrderBy

getLimit

getConditions

get

clear

getParameters

clearParameters

distinct

join

join

join

join

join

where

where

groupBy

groupBy

groupBy

groupBy

groupBy

groupBy

having

having

orderBy

orderBy

orderBy

orderBy

orderBy

orderBy

limit

limit

limit

limit

union

unionAll

intersect

except

minus

copy

toString

hashCode

equals