java.lang.Object
- org.springframework.jdbc.core.namedparam.AbstractSqlParameterSource
- - org.springframework.jdbc.core.namedparam.MapSqlParameterSource

All Implemented Interfaces:
SqlParameterSource
```
public class MapSqlParameterSource
extends AbstractSqlParameterSource
```
SqlParameterSource implementation that holds a given Map of parameters.
This class is intended for passing in a simple Map of parameter values to the methods of the NamedParameterJdbcTemplate class.
The addValue methods on this class will make adding several values easier. The methods return a reference to the MapSqlParameterSource itself, so you can chain several method calls together within a single statement.
Since:
2.0
Author:
Thomas Risberg, Juergen Hoeller
See Also:
addValue(String, Object), addValue(String, Object, int), AbstractSqlParameterSource.registerSqlType(java.lang.String, int), NamedParameterJdbcTemplate

Field Summary
- Fields inherited from interface org.springframework.jdbc.core.namedparam.SqlParameterSource
  TYPE_UNKNOWN

Constructor Summary

Constructors
Constructor	Description
`MapSqlParameterSource()`	Create an empty MapSqlParameterSource, with values to be added via `addValue`.
`MapSqlParameterSource(String paramName, Object value)`	Create a new MapSqlParameterSource, with one value comprised of the supplied arguments.
`MapSqlParameterSource(Map<String,?> values)`	Create a new MapSqlParameterSource based on a Map.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`MapSqlParameterSource`	`addValue(String paramName, Object value)`	Add a parameter to this parameter source.
`MapSqlParameterSource`	`addValue(String paramName, Object value, int sqlType)`	Add a parameter to this parameter source.
`MapSqlParameterSource`	`addValue(String paramName, Object value, int sqlType, String typeName)`	Add a parameter to this parameter source.
`MapSqlParameterSource`	`addValues(Map<String,?> values)`	Add a Map of parameters to this parameter source.
`String[]`	`getParameterNames()`	Enumerate all available parameter names if possible.
`Object`	`getValue(String paramName)`	Return the parameter value for the requested named parameter.
`Map<String,Object>`	`getValues()`	Expose the current parameter values as read-only Map.
`boolean`	`hasValue(String paramName)`	Determine whether there is a value for the specified named parameter.

Methods inherited from class org.springframework.jdbc.core.namedparam.AbstractSqlParameterSource
getSqlType, getTypeName, registerSqlType, registerTypeName, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - MapSqlParameterSource
```
public MapSqlParameterSource()
```
    Create an empty MapSqlParameterSource, with values to be added via addValue.
    See Also:
    addValue(String, Object)
  - MapSqlParameterSource
```
public MapSqlParameterSource(String paramName,
                             @Nullable
                             Object value)
```
    Create a new MapSqlParameterSource, with one value comprised of the supplied arguments.
    Parameters:
    paramName - the name of the parameter
    value - the value of the parameter
    See Also:
    addValue(String, Object)
  - MapSqlParameterSource
```
public MapSqlParameterSource(@Nullable
                             Map<String,?> values)
```
    Create a new MapSqlParameterSource based on a Map.
    Parameters:
    values - a Map holding existing parameter values (can be null)
- Method Detail
  - addValue
```
public MapSqlParameterSource addValue(String paramName,
                                      @Nullable
                                      Object value)
```
    Add a parameter to this parameter source.
    Parameters:
    paramName - the name of the parameter
    value - the value of the parameter
    Returns:
    a reference to this parameter source, so it's possible to chain several calls together
  - addValue
```
public MapSqlParameterSource addValue(String paramName,
                                      @Nullable
                                      Object value,
                                      int sqlType)
```
    Add a parameter to this parameter source.
    Parameters:
    paramName - the name of the parameter
    value - the value of the parameter
    sqlType - the SQL type of the parameter
    Returns:
    a reference to this parameter source, so it's possible to chain several calls together
  - addValue
```
public MapSqlParameterSource addValue(String paramName,
                                      @Nullable
                                      Object value,
                                      int sqlType,
                                      String typeName)
```
    Add a parameter to this parameter source.
    Parameters:
    paramName - the name of the parameter
    value - the value of the parameter
    sqlType - the SQL type of the parameter
    typeName - the type name of the parameter
    Returns:
    a reference to this parameter source, so it's possible to chain several calls together
  - addValues
```
public MapSqlParameterSource addValues(@Nullable
                                       Map<String,?> values)
```
    Add a Map of parameters to this parameter source.
    Parameters:
    values - a Map holding existing parameter values (can be null)
    Returns:
    a reference to this parameter source, so it's possible to chain several calls together
  - getValues
```
public Map<String,Object> getValues()
```
    Expose the current parameter values as read-only Map.
  - hasValue
```
public boolean hasValue(String paramName)
```
    Description copied from interface: SqlParameterSource
    Determine whether there is a value for the specified named parameter.
    Parameters:
    paramName - the name of the parameter
    Returns:
    whether there is a value defined
  - getValue
```
@Nullable
public Object getValue(String paramName)
```
    Description copied from interface: SqlParameterSource
    Return the parameter value for the requested named parameter.
    Parameters:
    paramName - the name of the parameter
    Returns:
    the value of the specified parameter
  - getParameterNames
```
@NonNull
public String[] getParameterNames()
```
    Description copied from interface: SqlParameterSource
    Enumerate all available parameter names if possible.
    This is an optional operation, primarily for use with SimpleJdbcInsert and SimpleJdbcCall.
    Returns:
    the array of parameter names, or null if not determinable
    See Also:
    SqlParameterSourceUtils.extractCaseInsensitiveParameterNames(org.springframework.jdbc.core.namedparam.SqlParameterSource)

Class MapSqlParameterSource

Field Summary

Fields inherited from interface org.springframework.jdbc.core.namedparam.SqlParameterSource

Constructor Summary

Method Summary

Methods inherited from class org.springframework.jdbc.core.namedparam.AbstractSqlParameterSource

Methods inherited from class java.lang.Object

Constructor Detail

MapSqlParameterSource

MapSqlParameterSource

MapSqlParameterSource

Method Detail

addValue

addValue

addValue

addValues

getValues

hasValue

getValue

getParameterNames