org.tinygroup.tinysqldsl.util

Class NamedParameterUtils

java.lang.Object

org.tinygroup.tinysqldsl.util.NamedParameterUtils

public abstract class NamedParameterUtils
extends Object

Helper methods for named parameter parsing. Only intended for internal use within Spring's JDBC framework.

Since:

2.0

Author:

Thomas Risberg, Juergen Hoeller

Constructor Summary

Constructors

Constructor and Description
NamedParameterUtils()

Method Summary

Modifier and Type	Method and Description
static ParsedSql	parseSqlStatement(String sql) Parse the SQL statement and locate any placeholders or named parameters.
static String	substituteNamedParameters(ParsedSql parsedSql, Map<String,Object> paramSource) Parse the SQL statement and locate any placeholders or named parameters.
static String	substituteNamedParameters(String sql, Map<String,Object> paramSource) Parse the SQL statement and locate any placeholders or named parameters.

Methods inherited from class java.lang.Object

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

Constructor Detail

NamedParameterUtils

public NamedParameterUtils()

Method Detail

parseSqlStatement

public static ParsedSql parseSqlStatement(String sql)

Parse the SQL statement and locate any placeholders or named parameters. Named parameters are substituted for a JDBC placeholder.

Parameters:

sql - the SQL statement

Returns:

the parsed statement, represented as ParsedSql instance

substituteNamedParameters

public static String substituteNamedParameters(String sql,
                                               Map<String,Object> paramSource)

Parse the SQL statement and locate any placeholders or named parameters. Named parameters are substituted for a JDBC placeholder and any select list is expanded to the required number of placeholders.

This is a shortcut version of #substituteNamedParameters(ParsedSql, SqlParameterSource).

Parameters:

sql - the SQL statement

paramSource - the source for named parameters

Returns:

the SQL statement with substituted parameters

substituteNamedParameters

public static String substituteNamedParameters(ParsedSql parsedSql,
                                               Map<String,Object> paramSource)

Parse the SQL statement and locate any placeholders or named parameters. Named parameters are substituted for a JDBC placeholder and any select list is expanded to the required number of placeholders. Select lists may contain an array of objects and in that case the placeholders will be grouped and enclosed with parantheses. This allows for the use of "expression lists" in the SQL statement like:
select id, name, state from table where (name, age) in (('John', 35), ('Ann', 50))

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.

Parameters:

parsedSql - the parsed represenation of the SQL statement

paramSource - the source for named parameters

Returns:

the SQL statement with substituted parameters

See Also:

parseSqlStatement(java.lang.String)