cn.hutool.db.sql

Class NamedSql

java.lang.Object

cn.hutool.db.sql.NamedSql

public class NamedSql
extends Object

使用命名占位符的SQL，例如：select * from table where field1=:name1
支持的占位符格式为：

 1、:name
 2、@name
 3、?name
 

Since:

4.0.10

Author:

looly

Constructor Summary

Constructors

Constructor and Description
NamedSql(String namedSql, Map<String,Object> paramMap) 构造

Method Summary

Modifier and Type	Method and Description
List<Object>	getParamList() 获取参数列表，按照占位符顺序
Object[]	getParams() 获取参数列表，按照占位符顺序
String	getSql() 获取SQL

Methods inherited from class java.lang.Object

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

Constructor Detail

NamedSql

public NamedSql(String namedSql,
                Map<String,Object> paramMap)

构造

Parameters:

namedSql - 命名占位符的SQL

paramMap - 名和参数的对应Map

Method Detail

getSql

public String getSql()

获取SQL

Returns:

SQL

getParams

public Object[] getParams()

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

Returns:

参数数组

getParamList

public List<Object> getParamList()

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

Returns:

参数列表