Package com.randomnoun.common.spring

Class JdbcTemplateWithArguments

java.lang.Object

org.springframework.jdbc.support.JdbcAccessor

org.springframework.jdbc.core.JdbcTemplate

com.randomnoun.common.spring.JdbcTemplateWithArguments

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean, org.springframework.jdbc.core.JdbcOperations

public class JdbcTemplateWithArguments
extends org.springframework.jdbc.core.JdbcTemplate

A JdbcTemplate that can take SqlWithArguments objects as parameters.

This provides a bit of syntactic sugar so that you can write

jt.update(sqlWithArgs);

instead of

jt.update(sqlWithArgs.getSql(), sqlWithArgs.getArgs(), sqlWithArgs.getArgTypes());

All JdbcTemplate methods that take String sql, Object[] args, int[] argTypes parameters have an additional SqlWithArguments equivalent.

This class will also recognise SelectFromResultSetExtractors and SelectFromRowMappers and will add the appropriate SELECTs and FROMs to the SQL before it is executed.

Author:

knoxg

Field Summary

Fields inherited from class org.springframework.jdbc.support.JdbcAccessor

logger

Constructor Summary

Constructors

Constructor	Description
JdbcTemplateWithArguments(org.springframework.jdbc.core.JdbcTemplate jt)

Method Summary

Modifier and Type	Method	Description
void	afterPropertiesSet()
int[]	batchUpdate(String... sql)
<T> int[][]	batchUpdate(String sql, Collection<T> batchArgs, int batchSize, org.springframework.jdbc.core.ParameterizedPreparedStatementSetter<T> pss)
int[]	batchUpdate(String sql, List<Object[]> batchArgs)
int[]	batchUpdate(String sql, List<Object[]> batchArgs, int[] argTypes)
int[]	batchUpdate(String sql, org.springframework.jdbc.core.BatchPreparedStatementSetter pss)
Map<String,Object>	call(org.springframework.jdbc.core.CallableStatementCreator csc, List<org.springframework.jdbc.core.SqlParameter> declaredParameters)
boolean	equals(Object obj)
void	execute(String sql)
<T> T	execute(String callString, org.springframework.jdbc.core.CallableStatementCallback<T> action)
<T> T	execute(String sql, org.springframework.jdbc.core.PreparedStatementCallback<T> action)
<T> T	execute(org.springframework.jdbc.core.CallableStatementCreator csc, org.springframework.jdbc.core.CallableStatementCallback<T> action)
<T> T	execute(org.springframework.jdbc.core.ConnectionCallback<T> action)
<T> T	execute(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.core.PreparedStatementCallback<T> action)
<T> T	execute(org.springframework.jdbc.core.StatementCallback<T> action)
DataSource	getDataSource()
org.springframework.jdbc.support.SQLExceptionTranslator	getExceptionTranslator()
int	getFetchSize()
int	getMaxRows()
int	getQueryTimeout()
int	hashCode()
boolean	isIgnoreWarnings()
boolean	isLazyInit()
boolean	isResultsMapCaseInsensitive()
boolean	isSkipResultsProcessing()
boolean	isSkipUndeclaredResults()
<T> T	query(SqlWithArguments sqlWithArgs, org.springframework.jdbc.core.ResultSetExtractor<T> rse)	Calls JdbcTemplate.query(String, Object[], ResultSetExtractor)
void	query(SqlWithArguments sqlWithArgs, org.springframework.jdbc.core.RowCallbackHandler rch)	Calls JdbcTemplate.query(String, Object[], int[], RowCallbackHandler)
<T> List<T>	query(SqlWithArguments sqlWithArgs, org.springframework.jdbc.core.RowMapper<T> rowMapper)	Calls JdbcTemplate.query(String, Object[], RowMapper)
<T> T	query(String sql, Object[] args, int[] argTypes, org.springframework.jdbc.core.ResultSetExtractor<T> rse)
void	query(String sql, Object[] args, int[] argTypes, org.springframework.jdbc.core.RowCallbackHandler rch)
<T> List<T>	query(String sql, Object[] args, int[] argTypes, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> T	query(String sql, Object[] args, org.springframework.jdbc.core.ResultSetExtractor<T> rse)
void	query(String sql, Object[] args, org.springframework.jdbc.core.RowCallbackHandler rch)
<T> List<T>	query(String sql, Object[] args, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> T	query(String sql, org.springframework.jdbc.core.PreparedStatementSetter pss, org.springframework.jdbc.core.ResultSetExtractor<T> rse)
void	query(String sql, org.springframework.jdbc.core.PreparedStatementSetter pss, org.springframework.jdbc.core.RowCallbackHandler rch)
<T> List<T>	query(String sql, org.springframework.jdbc.core.PreparedStatementSetter pss, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> T	query(String sql, org.springframework.jdbc.core.ResultSetExtractor<T> rse)
<T> T	query(String sql, org.springframework.jdbc.core.ResultSetExtractor<T> rse, Object... args)
void	query(String sql, org.springframework.jdbc.core.RowCallbackHandler rch)
void	query(String sql, org.springframework.jdbc.core.RowCallbackHandler rch, Object... args)
<T> List<T>	query(String sql, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> List<T>	query(String sql, org.springframework.jdbc.core.RowMapper<T> rowMapper, Object... args)
<T> T	query(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.core.PreparedStatementSetter pss, org.springframework.jdbc.core.ResultSetExtractor<T> rse)
<T> T	query(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.core.ResultSetExtractor<T> rse)
void	query(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.core.RowCallbackHandler rch)
<T> List<T>	query(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.core.RowMapper<T> rowMapper)
List<Map<String,Object>>	queryForList(SqlWithArguments sqlWithArgs)	Calls JdbcTemplate.queryForList(String, Object[], int[])
<T> List<T>	queryForList(SqlWithArguments sqlWithArgs, Class<T> elementType)	Calls JdbcTemplate.queryForList(String, Object[], int[], Class)
List<Map<String,Object>>	queryForList(String sql)
<T> List<T>	queryForList(String sql, Class<T> elementType)
<T> List<T>	queryForList(String sql, Class<T> elementType, Object... args)
List<Map<String,Object>>	queryForList(String sql, Object... args)
List<Map<String,Object>>	queryForList(String sql, Object[] args, int[] argTypes)
<T> List<T>	queryForList(String sql, Object[] args, int[] argTypes, Class<T> elementType)
<T> List<T>	queryForList(String sql, Object[] args, Class<T> elementType)
Map<String,Object>	queryForMap(SqlWithArguments sqlWithArgs)	Calls JdbcTemplate.queryForMap(String, Object[], int[])
Map<String,Object>	queryForMap(String sql)
Map<String,Object>	queryForMap(String sql, Object... args)
Map<String,Object>	queryForMap(String sql, Object[] args, int[] argTypes)
<T> T	queryForObject(SqlWithArguments sqlWithArgs, Class<T> requiredType)	Calls JdbcTemplate.queryForObject(String, Object[], int[], Class)
<T> T	queryForObject(String sql, Class<T> requiredType)
<T> T	queryForObject(String sql, Class<T> requiredType, Object... args)
<T> T	queryForObject(String sql, Object[] args, int[] argTypes, Class<T> requiredType)
<T> T	queryForObject(String sql, Object[] args, int[] argTypes, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> T	queryForObject(String sql, Object[] args, Class<T> requiredType)
<T> T	queryForObject(String sql, Object[] args, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> T	queryForObject(String sql, org.springframework.jdbc.core.RowMapper<T> rowMapper)
<T> T	queryForObject(String sql, org.springframework.jdbc.core.RowMapper<T> rowMapper, Object... args)
org.springframework.jdbc.support.rowset.SqlRowSet	queryForRowSet(SqlWithArguments sqlWithArgs)	Calls JdbcTemplate.queryForRowSet(String, Object[], int[])
org.springframework.jdbc.support.rowset.SqlRowSet	queryForRowSet(String sql)
org.springframework.jdbc.support.rowset.SqlRowSet	queryForRowSet(String sql, Object... args)
org.springframework.jdbc.support.rowset.SqlRowSet	queryForRowSet(String sql, Object[] args, int[] argTypes)
void	setDatabaseProductName(String dbName)
void	setDataSource(DataSource dataSource)
void	setExceptionTranslator(org.springframework.jdbc.support.SQLExceptionTranslator exceptionTranslator)
void	setFetchSize(int fetchSize)
void	setIgnoreWarnings(boolean ignoreWarnings)
void	setLazyInit(boolean lazyInit)
void	setMaxRows(int maxRows)
void	setQueryTimeout(int queryTimeout)
void	setResultsMapCaseInsensitive(boolean resultsMapCaseInsensitive)
void	setSkipResultsProcessing(boolean skipResultsProcessing)
void	setSkipUndeclaredResults(boolean skipUndeclaredResults)
String	toString()
int	update(SqlWithArguments sqlWithArgs)	Calls JdbcTemplate.update(String, Object[], int[])
int	update(String sql)
int	update(String sql, Object... args)
int	update(String sql, Object[] args, int[] argTypes)
int	update(String sql, org.springframework.jdbc.core.PreparedStatementSetter pss)
int	update(org.springframework.jdbc.core.PreparedStatementCreator psc)
int	update(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.support.KeyHolder generatedKeyHolder)

Methods inherited from class org.springframework.jdbc.core.JdbcTemplate

applyStatementSettings, batchUpdate, createConnectionProxy, createResultsMap, extractOutputParameters, extractReturnedResults, getColumnMapRowMapper, getSingleColumnRowMapper, handleWarnings, handleWarnings, handleWarnings, newArgPreparedStatementSetter, newArgTypePreparedStatementSetter, processResultSet, queryForStream, queryForStream, queryForStream, queryForStream, queryForStream, translateException, update

Methods inherited from class org.springframework.jdbc.support.JdbcAccessor

obtainDataSource

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Details

JdbcTemplateWithArguments

public JdbcTemplateWithArguments(org.springframework.jdbc.core.JdbcTemplate jt)

Method Details

setDataSource

public void setDataSource(DataSource dataSource)

Overrides:

setDataSource in class org.springframework.jdbc.support.JdbcAccessor

hashCode

public int hashCode()

Overrides:

hashCode in class Object

getDataSource

public DataSource getDataSource()

Overrides:

getDataSource in class org.springframework.jdbc.support.JdbcAccessor

setDatabaseProductName

public void setDatabaseProductName(String dbName)

Overrides:

setDatabaseProductName in class org.springframework.jdbc.support.JdbcAccessor

setExceptionTranslator

public void setExceptionTranslator(org.springframework.jdbc.support.SQLExceptionTranslator exceptionTranslator)

Overrides:

setExceptionTranslator in class org.springframework.jdbc.support.JdbcAccessor

getExceptionTranslator

public org.springframework.jdbc.support.SQLExceptionTranslator getExceptionTranslator()

Overrides:

getExceptionTranslator in class org.springframework.jdbc.support.JdbcAccessor

equals

public boolean equals(Object obj)

Overrides:

equals in class Object

setLazyInit

public void setLazyInit(boolean lazyInit)

Overrides:

setLazyInit in class org.springframework.jdbc.support.JdbcAccessor

isLazyInit

public boolean isLazyInit()

Overrides:

isLazyInit in class org.springframework.jdbc.support.JdbcAccessor

afterPropertiesSet

public void afterPropertiesSet()

Specified by:

afterPropertiesSet in interface org.springframework.beans.factory.InitializingBean

Overrides:

afterPropertiesSet in class org.springframework.jdbc.support.JdbcAccessor

setIgnoreWarnings

public void setIgnoreWarnings(boolean ignoreWarnings)

Overrides:

setIgnoreWarnings in class org.springframework.jdbc.core.JdbcTemplate

isIgnoreWarnings

public boolean isIgnoreWarnings()

Overrides:

isIgnoreWarnings in class org.springframework.jdbc.core.JdbcTemplate

setFetchSize

public void setFetchSize(int fetchSize)

Overrides:

setFetchSize in class org.springframework.jdbc.core.JdbcTemplate

getFetchSize

public int getFetchSize()

Overrides:

getFetchSize in class org.springframework.jdbc.core.JdbcTemplate

setMaxRows

public void setMaxRows(int maxRows)

Overrides:

setMaxRows in class org.springframework.jdbc.core.JdbcTemplate

toString

public String toString()

Overrides:

toString in class Object

getMaxRows

public int getMaxRows()

Overrides:

getMaxRows in class org.springframework.jdbc.core.JdbcTemplate

setQueryTimeout

public void setQueryTimeout(int queryTimeout)

Overrides:

setQueryTimeout in class org.springframework.jdbc.core.JdbcTemplate

getQueryTimeout

public int getQueryTimeout()

Overrides:

getQueryTimeout in class org.springframework.jdbc.core.JdbcTemplate

setSkipResultsProcessing

public void setSkipResultsProcessing(boolean skipResultsProcessing)

Overrides:

setSkipResultsProcessing in class org.springframework.jdbc.core.JdbcTemplate

isSkipResultsProcessing

public boolean isSkipResultsProcessing()

Overrides:

isSkipResultsProcessing in class org.springframework.jdbc.core.JdbcTemplate

setSkipUndeclaredResults

public void setSkipUndeclaredResults(boolean skipUndeclaredResults)

Overrides:

setSkipUndeclaredResults in class org.springframework.jdbc.core.JdbcTemplate

isSkipUndeclaredResults

public boolean isSkipUndeclaredResults()

Overrides:

isSkipUndeclaredResults in class org.springframework.jdbc.core.JdbcTemplate

setResultsMapCaseInsensitive

public void setResultsMapCaseInsensitive(boolean resultsMapCaseInsensitive)

Overrides:

setResultsMapCaseInsensitive in class org.springframework.jdbc.core.JdbcTemplate

isResultsMapCaseInsensitive

public boolean isResultsMapCaseInsensitive()

Overrides:

isResultsMapCaseInsensitive in class org.springframework.jdbc.core.JdbcTemplate

execute

public <T> T execute(org.springframework.jdbc.core.ConnectionCallback<T> action)
              throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

execute

public <T> T execute(org.springframework.jdbc.core.StatementCallback<T> action)
              throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

execute

public void execute(String sql)
             throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(String sql,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public void query(String sql,
 org.springframework.jdbc.core.RowCallbackHandler rch)
           throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> List<T> query(String sql,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                  throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForMap

public Map<String,Object> queryForMap(String sql)
                               throws org.springframework.dao.DataAccessException

Specified by:

queryForMap in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForMap in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 Class<T> requiredType)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public <T> List<T> queryForList(String sql,
 Class<T> elementType)
                         throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public List<Map<String,Object>> queryForList(String sql)
                                      throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForRowSet

public org.springframework.jdbc.support.rowset.SqlRowSet queryForRowSet(String sql)
                                                                 throws org.springframework.dao.DataAccessException

Specified by:

queryForRowSet in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForRowSet in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

update

public int update(String sql)
           throws org.springframework.dao.DataAccessException

Specified by:

update in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

update in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

batchUpdate

public int[] batchUpdate(String... sql)
                  throws org.springframework.dao.DataAccessException

Specified by:

batchUpdate in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

batchUpdate in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

execute

public <T> T execute(org.springframework.jdbc.core.PreparedStatementCreator psc,
 org.springframework.jdbc.core.PreparedStatementCallback<T> action)
              throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

execute

public <T> T execute(String sql,
 org.springframework.jdbc.core.PreparedStatementCallback<T> action)
              throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(org.springframework.jdbc.core.PreparedStatementCreator psc,
 org.springframework.jdbc.core.PreparedStatementSetter pss,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(org.springframework.jdbc.core.PreparedStatementCreator psc,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(String sql,
 org.springframework.jdbc.core.PreparedStatementSetter pss,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(SqlWithArguments sqlWithArgs,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.query(String, Object[], ResultSetExtractor)

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.query(String, Object[], ResultSetExtractor)

query

public <T> T query(String sql,
 Object[] args,
 int[] argTypes,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(String sql,
 Object[] args,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse)
            throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> T query(String sql,
 org.springframework.jdbc.core.ResultSetExtractor<T> rse,
 Object... args)
            throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public void query(org.springframework.jdbc.core.PreparedStatementCreator psc,
 org.springframework.jdbc.core.RowCallbackHandler rch)
           throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public void query(String sql,
 org.springframework.jdbc.core.PreparedStatementSetter pss,
 org.springframework.jdbc.core.RowCallbackHandler rch)
           throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public void query(SqlWithArguments sqlWithArgs,
 org.springframework.jdbc.core.RowCallbackHandler rch)
           throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.query(String, Object[], int[], RowCallbackHandler)

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.query(String, Object[], int[], RowCallbackHandler)

query

public void query(String sql,
 Object[] args,
 int[] argTypes,
 org.springframework.jdbc.core.RowCallbackHandler rch)
           throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public void query(String sql,
 Object[] args,
 org.springframework.jdbc.core.RowCallbackHandler rch)
           throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public void query(String sql,
 org.springframework.jdbc.core.RowCallbackHandler rch,
 Object... args)
           throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> List<T> query(org.springframework.jdbc.core.PreparedStatementCreator psc,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                  throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> List<T> query(String sql,
 org.springframework.jdbc.core.PreparedStatementSetter pss,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                  throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> List<T> query(SqlWithArguments sqlWithArgs,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                  throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.query(String, Object[], RowMapper)

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.query(String, Object[], RowMapper)

query

public <T> List<T> query(String sql,
 Object[] args,
 int[] argTypes,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                  throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> List<T> query(String sql,
 Object[] args,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                  throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

query

public <T> List<T> query(String sql,
 org.springframework.jdbc.core.RowMapper<T> rowMapper,
 Object... args)
                  throws org.springframework.dao.DataAccessException

Specified by:

query in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

query in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 Object[] args,
 int[] argTypes,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 Object[] args,
 org.springframework.jdbc.core.RowMapper<T> rowMapper)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 org.springframework.jdbc.core.RowMapper<T> rowMapper,
 Object... args)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(SqlWithArguments sqlWithArgs,
 Class<T> requiredType)
                     throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.queryForObject(String, Object[], int[], Class)

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.queryForObject(String, Object[], int[], Class)

queryForObject

public <T> T queryForObject(String sql,
 Object[] args,
 int[] argTypes,
 Class<T> requiredType)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 Object[] args,
 Class<T> requiredType)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForObject

public <T> T queryForObject(String sql,
 Class<T> requiredType,
 Object... args)
                     throws org.springframework.dao.DataAccessException

Specified by:

queryForObject in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForObject in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForMap

public Map<String,Object> queryForMap(SqlWithArguments sqlWithArgs)
                               throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.queryForMap(String, Object[], int[])

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.queryForMap(String, Object[], int[])

queryForMap

public Map<String,Object> queryForMap(String sql,
 Object[] args,
 int[] argTypes)
                               throws org.springframework.dao.DataAccessException

Specified by:

queryForMap in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForMap in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForMap

public Map<String,Object> queryForMap(String sql,
 Object... args)
                               throws org.springframework.dao.DataAccessException

Specified by:

queryForMap in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForMap in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public <T> List<T> queryForList(SqlWithArguments sqlWithArgs,
 Class<T> elementType)
                         throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.queryForList(String, Object[], int[], Class)

Throws:

org.springframework.dao.DataAccessException

queryForList

public <T> List<T> queryForList(String sql,
 Object[] args,
 int[] argTypes,
 Class<T> elementType)
                         throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public <T> List<T> queryForList(String sql,
 Object[] args,
 Class<T> elementType)
                         throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public <T> List<T> queryForList(String sql,
 Class<T> elementType,
 Object... args)
                         throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public List<Map<String,Object>> queryForList(SqlWithArguments sqlWithArgs)
                                      throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.queryForList(String, Object[], int[])

Throws:

org.springframework.dao.DataAccessException

See Also:

• }

queryForList

public List<Map<String,Object>> queryForList(String sql,
 Object[] args,
 int[] argTypes)
                                      throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForList

public List<Map<String,Object>> queryForList(String sql,
 Object... args)
                                      throws org.springframework.dao.DataAccessException

Specified by:

queryForList in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForList in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForRowSet

public org.springframework.jdbc.support.rowset.SqlRowSet queryForRowSet(SqlWithArguments sqlWithArgs)
                                                                 throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.queryForRowSet(String, Object[], int[])

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.queryForRowSet(String, Object[], int[])

queryForRowSet

public org.springframework.jdbc.support.rowset.SqlRowSet queryForRowSet(String sql,
 Object[] args,
 int[] argTypes)
                                                                 throws org.springframework.dao.DataAccessException

Specified by:

queryForRowSet in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForRowSet in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

queryForRowSet

public org.springframework.jdbc.support.rowset.SqlRowSet queryForRowSet(String sql,
 Object... args)
                                                                 throws org.springframework.dao.DataAccessException

Specified by:

queryForRowSet in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

queryForRowSet in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

update

public int update(org.springframework.jdbc.core.PreparedStatementCreator psc)
           throws org.springframework.dao.DataAccessException

Specified by:

update in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

update in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

update

public int update(org.springframework.jdbc.core.PreparedStatementCreator psc,
 org.springframework.jdbc.support.KeyHolder generatedKeyHolder)
           throws org.springframework.dao.DataAccessException

Specified by:

update in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

update in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

update

public int update(String sql,
 org.springframework.jdbc.core.PreparedStatementSetter pss)
           throws org.springframework.dao.DataAccessException

Specified by:

update in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

update in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

update

public int update(SqlWithArguments sqlWithArgs)
           throws org.springframework.dao.DataAccessException

Calls JdbcTemplate.update(String, Object[], int[])

Throws:

org.springframework.dao.DataAccessException

See Also:

• JdbcTemplate.update(String, Object[], int[])

update

public int update(String sql,
 Object[] args,
 int[] argTypes)
           throws org.springframework.dao.DataAccessException

Specified by:

update in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

update in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

update

public int update(String sql,
 Object... args)
           throws org.springframework.dao.DataAccessException

Specified by:

update in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

update in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

batchUpdate

public int[] batchUpdate(String sql,
 org.springframework.jdbc.core.BatchPreparedStatementSetter pss)
                  throws org.springframework.dao.DataAccessException

Specified by:

batchUpdate in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

batchUpdate in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

batchUpdate

public int[] batchUpdate(String sql,
 List<Object[]> batchArgs)
                  throws org.springframework.dao.DataAccessException

Specified by:

batchUpdate in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

batchUpdate in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

batchUpdate

public int[] batchUpdate(String sql,
 List<Object[]> batchArgs,
 int[] argTypes)
                  throws org.springframework.dao.DataAccessException

Specified by:

batchUpdate in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

batchUpdate in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

batchUpdate

public <T> int[][] batchUpdate(String sql,
 Collection<T> batchArgs,
 int batchSize,
 org.springframework.jdbc.core.ParameterizedPreparedStatementSetter<T> pss)
                        throws org.springframework.dao.DataAccessException

Specified by:

batchUpdate in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

batchUpdate in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

execute

public <T> T execute(org.springframework.jdbc.core.CallableStatementCreator csc,
 org.springframework.jdbc.core.CallableStatementCallback<T> action)
              throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

execute

public <T> T execute(String callString,
 org.springframework.jdbc.core.CallableStatementCallback<T> action)
              throws org.springframework.dao.DataAccessException

Specified by:

execute in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

execute in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException

call

public Map<String,Object> call(org.springframework.jdbc.core.CallableStatementCreator csc,
 List<org.springframework.jdbc.core.SqlParameter> declaredParameters)
                        throws org.springframework.dao.DataAccessException

Specified by:

call in interface org.springframework.jdbc.core.JdbcOperations

Overrides:

call in class org.springframework.jdbc.core.JdbcTemplate

Throws:

org.springframework.dao.DataAccessException