org.dromara.hutool.db.sql

Class BoundSql

java.lang.Object

org.dromara.hutool.db.sql.BoundSql

Direct Known Subclasses:

NamedSql

public class BoundSql
extends Object

参数绑定的SQL封装，用于表示SQL语句模板（'?'表示参数占位符）和参数值的封装
SQL中的'?'占位符必须和params列表中的参数值一一对应

Author:

Looly

Constructor Summary

Constructors

Constructor and Description
BoundSql() 构造
BoundSql(String sql, List<Object> params) 构造

Method Summary

Modifier and Type	Method and Description
BoundSql	addParam(Object paramValue) 增加参数
Object[]	getParamArray() 获取参数列表，按照占位符顺序
List<Object>	getParams() 获取参数列表，按照占位符顺序
String	getSql() 获取SQL
BoundSql	setParams(List<Object> params) 设置参数列表
BoundSql	setSql(String sql) 设置SQL语句

Methods inherited from class java.lang.Object

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

Constructor Detail

BoundSql

public BoundSql()

构造

BoundSql

public BoundSql(String sql,
                List<Object> params)

构造

Parameters:

sql - SQL语句，参数占位符使用'?'表示

params - 参数列表，每个参数对应一个'?'

Method Detail

getSql

public String getSql()

获取SQL

Returns:

SQL

setSql

public BoundSql setSql(String sql)

设置SQL语句

Parameters:

sql - SQL语句

Returns:

this

getParams

public List<Object> getParams()

获取参数列表，按照占位符顺序

Returns:

参数列表

getParamArray

public Object[] getParamArray()

获取参数列表，按照占位符顺序

Returns:

参数数组

setParams

public BoundSql setParams(List<Object> params)

设置参数列表

Parameters:

params - 参数列表

Returns:

this

addParam

public BoundSql addParam(Object paramValue)

增加参数

Parameters:

paramValue - 参数值

Returns:

this