org.dromara.hutool.db.sql

Class StatementBuilder

java.lang.Object

org.dromara.hutool.db.sql.StatementBuilder

All Implemented Interfaces:

Serializable, Builder<StatementWrapper>

public class StatementBuilder
extends Object
implements Builder<StatementWrapper>

PreparedStatement构建器，构建结果为StatementWrapper

Since:

6.0.0

Author:

looly

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
StatementBuilder()

Method Summary

Modifier and Type	Method and Description
StatementWrapper	build() 构建StatementWrapper
StatementWrapper	buildForBatch() 创建批量操作的StatementWrapper
CallableStatement	buildForCall() 创建存储过程或函数调用的StatementWrapper
static StatementBuilder	of() 创建构建器
StatementBuilder	setConnection(Connection connection) 设置连接
StatementBuilder	setParamList(List<Object> params) 设置SQL的"?"
StatementBuilder	setParams(Object... params) 设置SQL的"?"
StatementBuilder	setReturnGeneratedKey(boolean returnGeneratedKey) 设置是否返回主键
StatementBuilder	setSql(String sql) 设置执行的SQL语句
StatementBuilder	setSqlFilter(SqlFilter sqlFilter) 设置SQL日志

Methods inherited from class java.lang.Object

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

Constructor Detail

StatementBuilder

public StatementBuilder()

Method Detail

of

public static StatementBuilder of()

创建构建器

Returns:

StatementBuilder

setSqlFilter

public StatementBuilder setSqlFilter(SqlFilter sqlFilter)

设置SQL日志

Parameters:

sqlFilter - SqlFilter

Returns:

this

setConnection

public StatementBuilder setConnection(Connection connection)

设置连接

Parameters:

connection - Connection

Returns:

this

setSql

public StatementBuilder setSql(String sql)

设置执行的SQL语句

Parameters:

sql - SQL语句

Returns:

this

setParams

public StatementBuilder setParams(Object... params)

设置SQL的"?"对应的参数

Parameters:

params - 参数数组

Returns:

this

setParamList

public StatementBuilder setParamList(List<Object> params)

设置SQL的"?"对应的参数

Parameters:

params - 参数列表

Returns:

this

setReturnGeneratedKey

public StatementBuilder setReturnGeneratedKey(boolean returnGeneratedKey)

设置是否返回主键

Parameters:

returnGeneratedKey - 是否返回主键

Returns:

this

build

public StatementWrapper build()

构建StatementWrapper

Specified by:

build in interface Builder<StatementWrapper>

Returns:

StatementWrapper，null表示不执行

buildForBatch

public StatementWrapper buildForBatch()
                               throws DbException

创建批量操作的StatementWrapper

Returns:

StatementWrapper，null表示不执行

Throws:

DbException - SQL异常

buildForCall

public CallableStatement buildForCall()

创建存储过程或函数调用的StatementWrapper

Returns:

StatementWrapper，null表示不执行

Since:

6.0.0