public abstract class NamedParameterUtils extends Object
Constructor and Description |
---|
NamedParameterUtils() |
Modifier and Type | Method and Description |
---|---|
static List<SqlParameter> |
buildSqlParameterList(ParsedSql parsedSql,
SqlParameterSource paramSource)
Convert parameter declarations from an SqlParameterSource to a corresponding List of SqlParameters.
|
static int[] |
buildSqlTypeArray(ParsedSql parsedSql,
SqlParameterSource paramSource)
Convert parameter types from an SqlParameterSource into a corresponding int array.
|
static Object[] |
buildValueArray(ParsedSql parsedSql,
SqlParameterSource paramSource,
List<SqlParameter> declaredParams)
Convert a Map of named parameter values to a corresponding array.
|
static Object[] |
buildValueArray(String sql,
Map<String,?> paramMap)
Convert a Map of named parameter values to a corresponding array.
|
static ParsedSql |
parseSqlStatement(String sql)
Parse the SQL statement and locate any placeholders or named parameters.
|
static String |
parseSqlStatementIntoString(String sql)
Parse the SQL statement and locate any placeholders or named parameters.
|
static String |
substituteNamedParameters(ParsedSql parsedSql,
SqlParameterSource paramSource)
Parse the SQL statement and locate any placeholders or named parameters.
|
static String |
substituteNamedParameters(String sql,
SqlParameterSource paramSource)
Parse the SQL statement and locate any placeholders or named parameters.
|
public static ParsedSql parseSqlStatement(String sql)
sql
- the SQL statementpublic static String substituteNamedParameters(ParsedSql parsedSql, SqlParameterSource paramSource)
The parameter values passed in are used to determine the number of placeholder to be used for a select list. Select lists should be limited to 100 or fewer elements. A larger number of elements is not guaramteed to be supported by the database and is strictly vendor-dependent.
parsedSql
- the parsed represenation of the SQL statementparamSource
- the source for named parametersparseSqlStatement(java.lang.String)
public static Object[] buildValueArray(ParsedSql parsedSql, SqlParameterSource paramSource, List<SqlParameter> declaredParams)
parsedSql
- the parsed SQL statementparamSource
- the source for named parametersdeclaredParams
- the List of declared SqlParameter objects
(may be null
). If specified, the parameter metadata will
be built into the value array in the form of SqlParameterValue objects.public static int[] buildSqlTypeArray(ParsedSql parsedSql, SqlParameterSource paramSource)
parsedSql
- the parsed SQL statementparamSource
- the source for named parameterspublic static List<SqlParameter> buildSqlParameterList(ParsedSql parsedSql, SqlParameterSource paramSource)
parsedSql
- the parsed SQL statementparamSource
- the source for named parameterspublic static String parseSqlStatementIntoString(String sql)
This is a shortcut version of
parseSqlStatement(String)
in combination with
substituteNamedParameters(ParsedSql, SqlParameterSource)
.
sql
- the SQL statementpublic static String substituteNamedParameters(String sql, SqlParameterSource paramSource)
This is a shortcut version of
substituteNamedParameters(ParsedSql, SqlParameterSource)
.
sql
- the SQL statementparamSource
- the source for named parameterspublic static Object[] buildValueArray(String sql, Map<String,?> paramMap)
This is a shortcut version of
buildValueArray(ParsedSql, SqlParameterSource, java.util.List)
.
sql
- the SQL statementparamMap
- the Map of parameters