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

Class DdthJdbcHelper

java.lang.Object

com.github.ddth.dao.jdbc.AbstractJdbcHelper

com.github.ddth.dao.jdbc.impl.DdthJdbcHelper

All Implemented Interfaces:

IJdbcHelper, java.lang.AutoCloseable

public class DdthJdbcHelper
extends AbstractJdbcHelper

Pure-JDBC implementation of IJdbcHelper.

Since:

0.8.0

Author:

Thanh Nguyen

Field Summary

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

DEFAULT_DATASOURCE

Constructor Summary

Constructors

Constructor	Description
DdthJdbcHelper()

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.

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

DdthJdbcHelper

public DdthJdbcHelper()

Method Detail

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: