Package com.github.ddth.dao.jdbc.impl

Class JdbcTemplateJdbcHelper

java.lang.Object

com.github.ddth.dao.jdbc.AbstractJdbcHelper

com.github.ddth.dao.jdbc.impl.JdbcTemplateJdbcHelper

All Implemented Interfaces:

IJdbcHelper, java.lang.AutoCloseable

public class JdbcTemplateJdbcHelper
extends AbstractJdbcHelper

This implementation of IJdbcHelper utilizes Spring's JdbcTemplate to interact with database.

Since:

0.7.0

Author:

Thanh Nguyen

Field Summary

Fields inherited from interface com.github.ddth.dao.jdbc.IJdbcHelper

DEFAULT_DATASOURCE

Constructor Summary

Constructors

Constructor	Description
JdbcTemplateJdbcHelper()

Method Summary

Modifier and Type	Method	Description
int	execute(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a non-SELECT statement.
int	execute(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a non-SELECT statement.
<T> java.util.List<T>	executeSelect(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement.
<T> java.util.List<T>	executeSelect(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement.
protected org.springframework.jdbc.core.JdbcTemplate	jdbcTemplate()	Get a JdbcTemplate instance.
protected org.springframework.jdbc.core.JdbcTemplate	jdbcTemplate(java.sql.Connection conn)	Get JdbcTemplate instance for a given Connection.
protected org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate	namedParameterJdbcTemplate()	Get a NamedParameterJdbcTemplate instance.
protected org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate	namedParameterJdbcTemplate(java.sql.Connection conn)	Get NamedParameterJdbcTemplate instance for a given Connection.

Methods inherited from class com.github.ddth.dao.jdbc.AbstractJdbcHelper

calcFetchSizeForStream, close, commitTransaction, destroy, execute, execute, executeSelect, executeSelect, executeSelectAsStream, executeSelectAsStream, executeSelectOne, executeSelectOne, getConnection, getDataSource, getDataSource, getDataSources, getDefaultFetchSize, getSQLErrorCodesFactory, getSQLExceptionTranslator, init, returnConnection, rollbackTransaction, setDataSource, setDataSource, setDataSources, setDefaultFetchSize, startTransaction, translateSQLException, translateSQLException, translateSQLException

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.github.ddth.dao.jdbc.IJdbcHelper

executeSelect, executeSelect, executeSelect, executeSelect, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectAsStream, executeSelectOne, executeSelectOne, executeSelectOne, executeSelectOne, executeSelectOne, executeSelectOne, getConnection, getConnection, getConnection

Constructor Detail

JdbcTemplateJdbcHelper

public JdbcTemplateJdbcHelper()

Method Detail

jdbcTemplate

protected org.springframework.jdbc.core.JdbcTemplate jdbcTemplate(java.sql.Connection conn)

Get JdbcTemplate instance for a given Connection.

Note: the returned JdbcTemplate will not close the wrapped Connection!

Parameters:

conn -

Returns:

namedParameterJdbcTemplate

protected org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate namedParameterJdbcTemplate(java.sql.Connection conn)

Get NamedParameterJdbcTemplate instance for a given Connection.

Note: the returned JdbcTemplate will not close the wrapped Connection!

Parameters:

conn -

Returns:

Since:

0.8.0

jdbcTemplate

protected org.springframework.jdbc.core.JdbcTemplate jdbcTemplate()

Get a JdbcTemplate instance.

Returns:

namedParameterJdbcTemplate

protected org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate namedParameterJdbcTemplate()

Get a NamedParameterJdbcTemplate instance.

Returns:

Since:

0.8.0

execute

public int execute(java.sql.Connection conn,
                   java.lang.String sql,
                   java.lang.Object... bindValues)

Execute a non-SELECT statement.

bindValues - index-based bind values

Returns:

number of affected rows

execute

public int execute(java.sql.Connection conn,
                   java.lang.String sql,
                   java.util.Map<java.lang.String,?> bindValues)

Execute a non-SELECT statement.

bindValues - name-based bind values

Returns:

executeSelect

public <T> java.util.List<T> executeSelect(IRowMapper<T> rowMapper,
                                           java.sql.Connection conn,
                                           java.lang.String sql,
                                           java.lang.Object... bindValues)

Execute a SELECT statement.

Parameters:

rowMapper - to map the ResultSet to object

bindValues - index-based bind values

Returns:

executeSelect

public <T> java.util.List<T> executeSelect(IRowMapper<T> rowMapper,
                                           java.sql.Connection conn,
                                           java.lang.String sql,
                                           java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement.

Parameters:

rowMapper - to map the ResultSet to object

bindValues - name-based bind values

Returns: