Condition (hutool 5.8.41 API)

java.lang.Object
- cn.hutool.core.clone.CloneSupport<Condition>
- - cn.hutool.db.sql.Condition

All Implemented Interfaces:

Cloneable

Direct Known Subclasses:

ConditionGroup
```
public class Condition
extends CloneSupport<Condition>
```
条件对象

Author:

Looly

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class Condition.LikeType
SQL中 LIKE 语句查询方式

Nested Classes
Modifier and Type	Class and Description
`static class`	`Condition.LikeType` SQL中 LIKE 语句查询方式

Constructor Summary

Constructors
Constructor and Description
`Condition()` 构造
`Condition(boolean isPlaceHolder)` 构造
`Condition(String field, Object value)` 构造，使用等于表达式（运算符是=）
`Condition(String field, Object leftValue, Object rightValue)` 构造BETWEEN leftValue and rightValue条件
`Condition(String field, String value, Condition.LikeType likeType)` 构造LIKE value条件，支持： `Condition.LikeType.StartWith`：LIKE value% `Condition.LikeType.EndWith`：LIKE %value `Condition.LikeType.Contains`：LIKE %value%
`Condition(String field, String operator, Object value)` 构造

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`Condition`	`checkValueNull()` 检查值是否为null，如果为null转换为 "IS NULL"或"IS NOT NULL"形式
`String`	`getField()`
`LogicalOperator`	`getLinkOperator()` 获取与前一个Condition连接的逻辑运算符，可以是and或or
`String`	`getOperator()` 获得运算符大于号，小于号，等于号等
`Object`	`getSecondValue()` 获得between 类型中第二个值
`Object`	`getValue()` 获得值
`boolean`	`isOperatorBetween()` 是否 between x and y 类型
`boolean`	`isOperatorIn()` 是否IN条件
`boolean`	`isOperatorIs()` 是否IS条件
`boolean`	`isOperatorIsNot()` 是否 IS NOT条件
`boolean`	`isOperatorLike()` 是否LIKE条件
`boolean`	`isPlaceHolder()` 是否使用条件占位符
`static Condition`	`parse(String field, Object expression)` 解析为Condition
`void`	`setField(String field)` 设置字段名
`void`	`setLinkOperator(LogicalOperator linkOperator)` 设置与前一个Condition连接的逻辑运算符，可以是and或or
`void`	`setOperator(String operator)` 设置运算符大于号，小于号，等于号等
`void`	`setPlaceHolder(boolean isPlaceHolder)` 设置是否使用条件占位符
`void`	`setSecondValue(Object secondValue)` 设置between 类型中第二个值
`void`	`setValue(Object value)` 设置值，不解析表达式
`void`	`setValue(Object value, boolean isParse)` 设置值
`String`	`toString()`
`String`	`toString(List<Object> paramValues)` 转换为条件字符串，并回填占位符对应的参数值

Methods inherited from class cn.hutool.core.clone.CloneSupport
clone

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

- Constructor Detail
  - Condition
```
public Condition()
```
    构造
  - Condition
```
public Condition(boolean isPlaceHolder)
```
    构造
    
    Parameters:
    
    isPlaceHolder - 是否使用条件值占位符
  - Condition
```
public Condition(String field,
                 Object value)
```
    构造，使用等于表达式（运算符是=）
    
    Parameters:
    
    field - 字段
    
    value - 值
  - Condition
```
public Condition(String field,
                 String operator,
                 Object value)
```
    构造
    
    Parameters:
    
    field - 字段
    
    operator - 运算符（大于号，小于号，等于号 like 等）
    
    value - 值
  - Condition
```
public Condition(String field,
                 String value,
                 Condition.LikeType likeType)
```
    构造LIKE value条件，支持：
    - Condition.LikeType.StartWith：LIKE value%
    - Condition.LikeType.EndWith：LIKE %value
    - Condition.LikeType.Contains：LIKE %value%
    Parameters:
    
    field - 字段
    
    value - 值
    
    likeType - Condition.LikeType
  - Condition
```
public Condition(String field,
                 Object leftValue,
                 Object rightValue)
```
    构造BETWEEN leftValue and rightValue条件
    
    Parameters:
    
    field - 字段
    
    leftValue - 左值
    
    rightValue - 右值
    
    Since:
    
    5.8.41
- Method Detail
  - parse
```
public static Condition parse(String field,
                              Object expression)
```
    解析为Condition
    
    Parameters:
    
    field - 字段名
    
    expression - 表达式或普通值
    
    Returns:
    
    Condition
  - getField
```
public String getField()
```
    Returns:
    
    字段
  - setField
```
public void setField(String field)
```
    设置字段名
    
    Parameters:
    
    field - 字段名
  - getOperator
```
public String getOperator()
```
    获得运算符
    大于号，小于号，等于号等
    
    Returns:
    
    运算符
  - setOperator
```
public void setOperator(String operator)
```
    设置运算符
    大于号，小于号，等于号等
    
    Parameters:
    
    operator - 运算符
  - getValue
```
public Object getValue()
```
    获得值
    
    Returns:
    
    值
  - setValue
```
public void setValue(Object value)
```
    设置值，不解析表达式
    
    Parameters:
    
    value - 值
  - setValue
```
public void setValue(Object value,
                     boolean isParse)
```
    设置值
    
    Parameters:
    
    value - 值
    
    isParse - 是否解析值表达式
  - isPlaceHolder
```
public boolean isPlaceHolder()
```
    是否使用条件占位符
    
    Returns:
    
    是否使用条件占位符
  - setPlaceHolder
```
public void setPlaceHolder(boolean isPlaceHolder)
```
    设置是否使用条件占位符
    
    Parameters:
    
    isPlaceHolder - 是否使用条件占位符
  - isOperatorBetween
```
public boolean isOperatorBetween()
```
    是否 between x and y 类型
    
    Returns:
    
    是否 between x and y 类型
    
    Since:
    
    4.0.1
  - isOperatorIn
```
public boolean isOperatorIn()
```
    是否IN条件
    
    Returns:
    
    是否IN条件
    
    Since:
    
    4.0.1
  - isOperatorIs
```
public boolean isOperatorIs()
```
    是否IS条件
    
    Returns:
    
    是否IS条件
    
    Since:
    
    4.0.1
  - isOperatorIsNot
```
public boolean isOperatorIsNot()
```
    是否 IS NOT条件
    
    Returns:
    
    是否IS NOT条件
    
    Since:
    
    5.8.0
  - isOperatorLike
```
public boolean isOperatorLike()
```
    是否LIKE条件
    
    Returns:
    
    是否LIKE条件
    
    Since:
    
    5.7.14
  - checkValueNull
```
public Condition checkValueNull()
```
    检查值是否为null，如果为null转换为 "IS NULL"或"IS NOT NULL"形式
    
    Returns:
    
    this
  - getSecondValue
```
public Object getSecondValue()
```
    获得between 类型中第二个值
    
    Returns:
    
    值
  - setSecondValue
```
public void setSecondValue(Object secondValue)
```
    设置between 类型中第二个值
    
    Parameters:
    
    secondValue - 第二个值
  - getLinkOperator
```
public LogicalOperator getLinkOperator()
```
    获取与前一个Condition连接的逻辑运算符，可以是and或or
    
    Returns:
    
    与前一个Condition连接的逻辑运算符，可以是and或or
    
    Since:
    
    5.4.3
  - setLinkOperator
```
public void setLinkOperator(LogicalOperator linkOperator)
```
    设置与前一个Condition连接的逻辑运算符，可以是and或or
    
    Parameters:
    
    linkOperator - 与前一个Condition连接的逻辑运算符，可以是and或or
    
    Since:
    
    5.4.3
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class Object
  - toString
```
public String toString(List<Object> paramValues)
```
    转换为条件字符串，并回填占位符对应的参数值
    
    Parameters:
    
    paramValues - 参数列表，用于回填占位符对应参数值
    
    Returns:
    
    条件字符串

Class Condition

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class cn.hutool.core.clone.CloneSupport

Methods inherited from class java.lang.Object

Constructor Detail

Condition

Condition

Condition

Condition

Condition

Condition

Method Detail

parse

getField

setField

getOperator

setOperator

getValue

setValue

setValue

isPlaceHolder

setPlaceHolder

isOperatorBetween

isOperatorIn

isOperatorIs

isOperatorIsNot

isOperatorLike

checkValueNull

getSecondValue

setSecondValue

getLinkOperator

setLinkOperator

toString

toString