cn.hutool.db.sql

Class ConditionBuilder

java.lang.Object

cn.hutool.db.sql.ConditionBuilder

All Implemented Interfaces:

Builder<String>, Serializable

public class ConditionBuilder
extends Object
implements Builder<String>

多条件构建封装
可以将多个条件构建为SQL语句的一部分，并将参数值转换为占位符，并提取对应位置的参数值。
例如：name = ? AND type IN (?, ?) AND other LIKE ?

Since:

5.4.3

Author:

looly

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
ConditionBuilder(Condition... conditions) 构造

Method Summary

Modifier and Type	Method and Description
String	build() 构建组合条件 例如：name = ? AND type IN (?, ?) AND other LIKE ?
String	build(List<Object> paramValues) 构建组合条件 例如：name = ? AND type IN (?, ?) AND other LIKE ?
List<Object>	getParamValues() 返回构建后的参数列表 此方法调用前必须调用build()
static ConditionBuilder	of(Condition... conditions) 创建构建器
String	toString() 构建组合条件 例如：name = ? AND type IN (?, ?) AND other LIKE ?

Methods inherited from class java.lang.Object

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

Constructor Detail

ConditionBuilder

public ConditionBuilder(Condition... conditions)

构造

Parameters:

conditions - 条件列表

Method Detail

of

public static ConditionBuilder of(Condition... conditions)

创建构建器

Parameters:

conditions - 条件列表

Returns:

ConditionBuilder

getParamValues

public List<Object> getParamValues()

返回构建后的参数列表
此方法调用前必须调用build()

Returns:

参数列表

build

public String build()

构建组合条件
例如：name = ? AND type IN (?, ?) AND other LIKE ?

Specified by:

build in interface Builder<String>

Returns:

构建后的SQL语句条件部分

build

public String build(List<Object> paramValues)

构建组合条件
例如：name = ? AND type IN (?, ?) AND other LIKE ?

Parameters:

paramValues - 用于写出参数的List,构建时会将参数写入此List

Returns:

构建后的SQL语句条件部分

toString

public String toString()

构建组合条件
例如：name = ? AND type IN (?, ?) AND other LIKE ?

Overrides:

toString in class Object

Returns:

构建后的SQL语句条件部分