void afterPropertiesSet() Eagerly initialize the exception translator, if demanded, creating a default one for the specified DataSource if none set. int[] batchUpdate(final String... sql) int[] batchUpdate(String sql, final BatchPreparedStatementSetter pss) int[] batchUpdate(String sql, List batchArgs) int[] batchUpdate(String sql, List batchArgs, final int[] argTypes) Map call(CallableStatementCreator csc, List declaredParameters) T execute(ConnectionCallback action) T execute(StatementCallback action) void execute(final String sql) T execute(PreparedStatementCreator psc, PreparedStatementCallback action) T execute(String sql, PreparedStatementCallback action) T execute(CallableStatementCreator csc, CallableStatementCallback action) T execute(String callString, CallableStatementCallback action) Class> getClass() Returns the runtime class of this Object . DataSource getDataSource() Return the DataSource used by this template. boolean isIgnoreWarnings() Return whether or not we ignore SQLWarnings. boolean isResultsMapCaseInsensitive() Return whether execution of a CallableStatement will return the results in a Map that uses case insensitive names for the parameters. T query(final String sql, final ResultSetExtractor rse) void query(String sql, RowCallbackHandler rch) List query(String sql, RowMapper rowMapper) T query(PreparedStatementCreator psc, ResultSetExtractor rse) void query(PreparedStatementCreator psc, RowCallbackHandler rch) List query(PreparedStatementCreator psc, RowMapper rowMapper) T query(PreparedStatementCreator psc, @Nullable final PreparedStatementSetter pss, final ResultSetExtractor rse) Query using a prepared statement, allowing for a PreparedStatementCreator and a PreparedStatementSetter. T query(String sql, @Nullable PreparedStatementSetter pss, ResultSetExtractor rse) T query(String sql, @Nullable Object[] args, ResultSetExtractor rse) T query(String sql, ResultSetExtractor rse, @Nullable Object... args) void query(String sql, @Nullable PreparedStatementSetter pss, RowCallbackHandler rch) void query(String sql, Object[] args, RowCallbackHandler rch) void query(String sql, RowCallbackHandler rch, @Nullable Object... args) List query(String sql, @Nullable PreparedStatementSetter pss, RowMapper rowMapper) List query(String sql, @Nullable Object[] args, RowMapper rowMapper) List query(String sql, RowMapper rowMapper, @Nullable Object... args) List> queryForList(String sql) List queryForList(String sql, Object[] args, int[] argTypes, Class elementType) List queryForList(String sql, Class elementType) List> queryForList(String sql, @Nullable Object... args) List queryForList(String sql, Object[] args, Class elementType) List queryForList(String sql, Class elementType, @Nullable Object... args) List> queryForList(String sql, Object[] args, int[] argTypes) Map queryForMap(String sql, @Nullable Object... args) Map queryForMap(String sql) T queryForObject(String sql, @Nullable Object[] args, RowMapper rowMapper) T queryForObject(String sql, RowMapper rowMapper, @Nullable Object... args) T queryForObject(String sql, Object[] args, Class requiredType) T queryForObject(String sql, Class requiredType, @Nullable Object... args) T queryForObject(String sql, RowMapper rowMapper) T queryForObject(String sql, Class requiredType) T queryForObject(String sql, Object[] args, int[] argTypes, RowMapper rowMapper) T queryForObject(String sql, Object[] args, int[] argTypes, Class requiredType) SqlRowSet queryForRowSet(String sql) SqlRowSet queryForRowSet(String sql, @Nullable Object... args) void setDatabaseProductName(String dbName) Specify the database product name for the DataSource that this accessor uses. void setDataSource(@Nullable DataSource dataSource) Set the JDBC DataSource to obtain connections from. void setExceptionTranslator(SQLExceptionTranslator exceptionTranslator) Set the exception translator for this instance. void setFetchSize(int fetchSize) Set the fetch size for this JdbcTemplate. void setIgnoreWarnings(boolean ignoreWarnings) Set whether or not we want to ignore SQLWarnings. void setLazyInit(boolean lazyInit) Set whether to lazily initialize the SQLExceptionTranslator for this accessor, on first encounter of a SQLException. void setMaxRows(int maxRows) Set the maximum number of rows for this JdbcTemplate. void setQueryTimeout(int queryTimeout) Set the query timeout for statements that this JdbcTemplate executes. void setResultsMapCaseInsensitive(boolean resultsMapCaseInsensitive) Set whether execution of a CallableStatement will return the results in a Map that uses case insensitive names for the parameters. void setSkipResultsProcessing(boolean skipResultsProcessing) Set whether results processing should be skipped. void setSkipUndeclaredResults(boolean skipUndeclaredResults) Set whether undeclared results should be skipped. int update(final String sql) int update(PreparedStatementCreator psc) int update(String sql, Object[] args, int[] argTypes) int update(final PreparedStatementCreator psc, @Nullable final PreparedStatementSetter pss) int update(final PreparedStatementCreator psc, final KeyHolder generatedKeyHolder) int update(String sql, @Nullable PreparedStatementSetter pss) int update(String sql, @Nullable Object... args)