Package org.springframework.jdbc.core

Class JdbcPerunTemplate

java.lang.Object

org.springframework.jdbc.support.JdbcAccessor

org.springframework.jdbc.core.JdbcTemplate

org.springframework.jdbc.core.JdbcPerunTemplate

All Implemented Interfaces:

InitializingBean, JdbcOperations

public class JdbcPerunTemplate
extends JdbcTemplate

Class JdbcPerunTemplate extends JdbcTemplate from spring. - it has 1 additional method queryForObject(String sql, ResultSetExtractor rse, Object... args)

Author:

Sona Mastrakova

Field Summary

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

logger

Constructor Summary

Constructors

Constructor	Description
JdbcPerunTemplate(DataSource perunPool)

Method Summary

Modifier and Type	Method	Description
int	queryForInt(String sql, Object... args)	Implements a method removed from spring-jdbc
<T> T	queryForObject(String sql, ResultSetExtractor<? extends List<T>> rse, Object... args)	Returns one object from the query, else throws an exception.

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

applyStatementSettings, batchUpdate, batchUpdate, batchUpdate, batchUpdate, batchUpdate, call, createConnectionProxy, createResultsMap, execute, execute, execute, execute, execute, execute, execute, extractOutputParameters, extractReturnedResults, getColumnMapRowMapper, getFetchSize, getMaxRows, getQueryTimeout, getSingleColumnRowMapper, handleWarnings, handleWarnings, handleWarnings, isIgnoreWarnings, isResultsMapCaseInsensitive, isSkipResultsProcessing, isSkipUndeclaredResults, newArgPreparedStatementSetter, newArgTypePreparedStatementSetter, processResultSet, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, queryForList, queryForList, queryForList, queryForList, queryForList, queryForList, queryForList, queryForMap, queryForMap, queryForMap, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForRowSet, queryForRowSet, queryForRowSet, queryForStream, queryForStream, queryForStream, queryForStream, queryForStream, setFetchSize, setIgnoreWarnings, setMaxRows, setQueryTimeout, setResultsMapCaseInsensitive, setSkipResultsProcessing, setSkipUndeclaredResults, translateException, update, update, update, update, update, update, update

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

afterPropertiesSet, getDataSource, getExceptionTranslator, isLazyInit, obtainDataSource, setDatabaseProductName, setDataSource, setExceptionTranslator, setLazyInit

Methods inherited from class java.lang.Object

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

Constructor Details

JdbcPerunTemplate

public JdbcPerunTemplate(DataSource perunPool)

Method Details

queryForInt

public int queryForInt(String sql,
 Object... args)

Implements a method removed from spring-jdbc

Parameters:

sql - SQL query

args - arguments for the SQL query

Returns:

result of the query or zero if null

queryForObject

public <T> T queryForObject(String sql,
 ResultSetExtractor<? extends List<T>> rse,
 Object... args)

Returns one object from the query, else throws an exception.

Parameters:

sql - sql query

rse - result set extractor that returns List of objects

args - arguments for the query

Returns:

the single object obtained from the query

Throws:

IncorrectResultSizeDataAccessException - if more than one element has been found in the given Collection

EmptyResultDataAccessException - if no element at all has been found in the given Collection