com.jn.sqlhelper.springjdbc

类 JdbcTemplate

java.lang.Object

org.springframework.jdbc.support.JdbcAccessor

org.springframework.jdbc.core.JdbcTemplate

com.jn.sqlhelper.springjdbc.JdbcTemplate

所有已实现的接口:

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

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

字段概要

从类继承的字段 org.springframework.jdbc.support.JdbcAccessor

logger

构造器概要

构造器

构造器和说明
JdbcTemplate()
JdbcTemplate(DataSource dataSource) Construct a new JdbcTemplate, given a DataSource to obtain connections from.
JdbcTemplate(DataSource dataSource, boolean lazyInit) Construct a new JdbcTemplate, given a DataSource to obtain connections from.

方法概要

限定符和类型	方法和说明
protected DataSource	dataSource() supports for under 5.0
<T> T	query(org.springframework.jdbc.core.PreparedStatementCreator psc, org.springframework.jdbc.core.PreparedStatementSetter pss, org.springframework.jdbc.core.ResultSetExtractor<T> rse) Pagination for PreparedStatement
<T> T	query(String sql, org.springframework.jdbc.core.ResultSetExtractor<T> rse) Pagination for Statement
void	setInstrumentConfig(SQLInstrumentorConfig instrumentConfig)
void	setPaginationConfig(JdbcTemplatePaginationProperties paginationConfig)
protected org.springframework.dao.DataAccessException	translateException(String task, String sql, SQLException ex) for Spring 4.x

从类继承的方法 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, getNativeJdbcExtractor, getQueryTimeout, getSingleColumnRowMapper, 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, queryForList, queryForList, queryForList, queryForList, queryForList, queryForList, queryForList, queryForMap, queryForMap, queryForMap, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForObject, queryForRowSet, queryForRowSet, queryForRowSet, setFetchSize, setIgnoreWarnings, setMaxRows, setNativeJdbcExtractor, setQueryTimeout, setResultsMapCaseInsensitive, setSkipResultsProcessing, setSkipUndeclaredResults, update, update, update, update, update, update, update

从类继承的方法 org.springframework.jdbc.support.JdbcAccessor

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

从类继承的方法 java.lang.Object

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

构造器详细资料

JdbcTemplate

public JdbcTemplate()

JdbcTemplate

public JdbcTemplate(DataSource dataSource)

Construct a new JdbcTemplate, given a DataSource to obtain connections from.

Note: This will not trigger initialization of the exception translator.

参数:

dataSource - the JDBC DataSource to obtain connections from

JdbcTemplate

public JdbcTemplate(DataSource dataSource,
                    boolean lazyInit)

Construct a new JdbcTemplate, given a DataSource to obtain connections from.

Note: Depending on the "lazyInit" flag, initialization of the exception translator will be triggered.

参数:

dataSource - the JDBC DataSource to obtain connections from

lazyInit - whether to lazily initialize the SQLExceptionTranslator

方法详细资料

setPaginationConfig

public void setPaginationConfig(JdbcTemplatePaginationProperties paginationConfig)

setInstrumentConfig

public void setInstrumentConfig(SQLInstrumentorConfig instrumentConfig)

dataSource

protected DataSource dataSource()

supports for under 5.0

返回:

DataSource

query

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

Pagination for Statement

指定者:

query 在接口中 org.springframework.jdbc.core.JdbcOperations

覆盖:

query 在类中 org.springframework.jdbc.core.JdbcTemplate

抛出:

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

Pagination for PreparedStatement

覆盖:

query 在类中 org.springframework.jdbc.core.JdbcTemplate

抛出:

org.springframework.dao.DataAccessException

translateException

protected org.springframework.dao.DataAccessException translateException(String task,
                                                                         String sql,
                                                                         SQLException ex)

for Spring 4.x