Uses of Interface org.springframework.jdbc.core.namedparam.SqlParameterSource (Spring Framework API 2.0) - Spring Framework 2.0.5 API 文档英文版

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

The Spring Framework

PREV NEXT

FRAMES NO FRAMES

Uses of Interface
org.springframework.jdbc.core.namedparam.SqlParameterSource

Packages that use SqlParameterSource
org.springframework.jdbc.core.namedparam	JdbcTemplate variant with named parameter support.

Uses of SqlParameterSource in org.springframework.jdbc.core.namedparam

Classes in org.springframework.jdbc.core.namedparam that implement SqlParameterSource

class AbstractSqlParameterSource
          Abstract base class for SqlParameterSource implementations.

class BeanPropertySqlParameterSource
          SqlParameterSource implementation that obtains parameter values from bean properties of a given JavaBean object.

class MapSqlParameterSource
          SqlParameterSource implementation that holds a given Map of parameters.

Classes in org.springframework.jdbc.core.namedparam that implement SqlParameterSource
`class`	`AbstractSqlParameterSource` Abstract base class for SqlParameterSource implementations.
`class`	`BeanPropertySqlParameterSource` SqlParameterSource implementation that obtains parameter values from bean properties of a given JavaBean object.
`class`	`MapSqlParameterSource` `SqlParameterSource` implementation that holds a given Map of parameters.

Methods in org.springframework.jdbc.core.namedparam with parameters of type SqlParameterSource

static Object[] NamedParameterUtils.buildValueArray(ParsedSql parsedSql, SqlParameterSource paramSource, List declaredParams)
          Convert a Map of named parameter values to a corresponding array.

Object NamedParameterJdbcTemplate.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback action)


Object NamedParameterJdbcOperations.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback action)
          Execute a JDBC data access operation, implemented as callback action working on a JDBC PreparedStatement.

protected PreparedStatementCreator NamedParameterJdbcTemplate.getPreparedStatementCreator(String sql, SqlParameterSource paramSource)
          Build a PreparedStatementCreator based on the given SQL and named parameters.

Object NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, ResultSetExtractor rse)


Object NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, ResultSetExtractor rse)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, reading the ResultSet with a ResultSetExtractor.

void NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch)


void NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, reading the ResultSet on a per-row basis with a RowCallbackHandler.

List NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowMapper rowMapper)


List NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowMapper rowMapper)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping each row to a Java object via a RowMapper.

int NamedParameterJdbcTemplate.queryForInt(String sql, SqlParameterSource paramSource)


int NamedParameterJdbcOperations.queryForInt(String sql, SqlParameterSource paramSource)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in an int value.

List NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource)


List NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list.

List NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource, Class elementType)


List NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource, Class elementType)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list.

long NamedParameterJdbcTemplate.queryForLong(String sql, SqlParameterSource paramSource)


long NamedParameterJdbcOperations.queryForLong(String sql, SqlParameterSource paramSource)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in a long value.

Map NamedParameterJdbcTemplate.queryForMap(String sql, SqlParameterSource paramSource)


Map NamedParameterJdbcOperations.queryForMap(String sql, SqlParameterSource paramSource)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result Map.

Object NamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, Class requiredType)


Object NamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, Class requiredType)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result object.

Object NamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, RowMapper rowMapper)


Object NamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, RowMapper rowMapper)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping a single result row to a Java object via a RowMapper.

SqlRowSet NamedParameterJdbcTemplate.queryForRowSet(String sql, SqlParameterSource paramSource)


SqlRowSet NamedParameterJdbcOperations.queryForRowSet(String sql, SqlParameterSource paramSource)
          Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a SqlRowSet.

static String NamedParameterUtils.substituteNamedParameters(ParsedSql parsedSql, SqlParameterSource paramSource)
          Parse the SQL statement and locate any placeholders or named parameters.

static String NamedParameterUtils.substituteNamedParameters(String sql, SqlParameterSource paramSource)
          Parse the SQL statement and locate any placeholders or named parameters.

int NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource)


int NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource)
          Issue an update via a prepared statement, binding the given arguments.

int NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder)


int NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder)
          Issue an update via a prepared statement, binding the given arguments, returning generated keys.

int NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)


int NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)
          Issue an update via a prepared statement, binding the given arguments, returning generated keys.

Methods in org.springframework.jdbc.core.namedparam with parameters of type SqlParameterSource
`static Object[]`	`NamedParameterUtils.buildValueArray(ParsedSql parsedSql, SqlParameterSource paramSource, List declaredParams)` Convert a Map of named parameter values to a corresponding array.
`Object`	`NamedParameterJdbcTemplate.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback action)`
`Object`	`NamedParameterJdbcOperations.execute(String sql, SqlParameterSource paramSource, PreparedStatementCallback action)` Execute a JDBC data access operation, implemented as callback action working on a JDBC PreparedStatement.
`protected PreparedStatementCreator`	`NamedParameterJdbcTemplate.getPreparedStatementCreator(String sql, SqlParameterSource paramSource)` Build a PreparedStatementCreator based on the given SQL and named parameters.
`Object`	`NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, ResultSetExtractor rse)`
`Object`	`NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, ResultSetExtractor rse)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, reading the ResultSet with a ResultSetExtractor.
`void`	`NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch)`
`void`	`NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, reading the ResultSet on a per-row basis with a RowCallbackHandler.
`List`	`NamedParameterJdbcTemplate.query(String sql, SqlParameterSource paramSource, RowMapper rowMapper)`
`List`	`NamedParameterJdbcOperations.query(String sql, SqlParameterSource paramSource, RowMapper rowMapper)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping each row to a Java object via a RowMapper.
`int`	`NamedParameterJdbcTemplate.queryForInt(String sql, SqlParameterSource paramSource)`
`int`	`NamedParameterJdbcOperations.queryForInt(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in an int value.
`List`	`NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource)`
`List`	`NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list.
`List`	`NamedParameterJdbcTemplate.queryForList(String sql, SqlParameterSource paramSource, Class elementType)`
`List`	`NamedParameterJdbcOperations.queryForList(String sql, SqlParameterSource paramSource, Class elementType)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list.
`long`	`NamedParameterJdbcTemplate.queryForLong(String sql, SqlParameterSource paramSource)`
`long`	`NamedParameterJdbcOperations.queryForLong(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, resulting in a long value.
`Map`	`NamedParameterJdbcTemplate.queryForMap(String sql, SqlParameterSource paramSource)`
`Map`	`NamedParameterJdbcOperations.queryForMap(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result Map.
`Object`	`NamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, Class requiredType)`
`Object`	`NamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, Class requiredType)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result object.
`Object`	`NamedParameterJdbcTemplate.queryForObject(String sql, SqlParameterSource paramSource, RowMapper rowMapper)`
`Object`	`NamedParameterJdbcOperations.queryForObject(String sql, SqlParameterSource paramSource, RowMapper rowMapper)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping a single result row to a Java object via a RowMapper.
`SqlRowSet`	`NamedParameterJdbcTemplate.queryForRowSet(String sql, SqlParameterSource paramSource)`
`SqlRowSet`	`NamedParameterJdbcOperations.queryForRowSet(String sql, SqlParameterSource paramSource)` Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a SqlRowSet.
`static String`	`NamedParameterUtils.substituteNamedParameters(ParsedSql parsedSql, SqlParameterSource paramSource)` Parse the SQL statement and locate any placeholders or named parameters.
`static String`	`NamedParameterUtils.substituteNamedParameters(String sql, SqlParameterSource paramSource)` Parse the SQL statement and locate any placeholders or named parameters.
`int`	`NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource)`
`int`	`NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource)` Issue an update via a prepared statement, binding the given arguments.
`int`	`NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder)`
`int`	`NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder)` Issue an update via a prepared statement, binding the given arguments, returning generated keys.
`int`	`NamedParameterJdbcTemplate.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)`
`int`	`NamedParameterJdbcOperations.update(String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)` Issue an update via a prepared statement, binding the given arguments, returning generated keys.