Package com.github.ddth.dao.jdbc

Class BaseJdbcDao

java.lang.Object

com.github.ddth.dao.BaseDao

com.github.ddth.dao.jdbc.BaseJdbcDao

All Implemented Interfaces:

IJdbcHelper, java.lang.AutoCloseable

Direct Known Subclasses:

GenericBoJdbcDao, GenericMultiBoJdbcDao

public class BaseJdbcDao
extends BaseDao
implements IJdbcHelper

Base class for JDBC-based DAOs.

Since:

0.1.0

Author:

Thanh Nguyen

Field Summary

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

DEFAULT_DATASOURCE

Constructor Summary

Constructors

Constructor	Description
BaseJdbcDao()

Method Summary

Modifier and Type	Method	Description
boolean	commitTransaction(java.sql.Connection conn)	Commit a transaction.
int	execute(java.lang.String sql, java.lang.Object... bindValues)	Execute a non-SELECT statement.
int	execute(java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a non-SELECT statement.
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.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement.
<T> java.util.List<T>	executeSelect(IRowMapper<T> rowMapper, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a 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.
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	executeSelect(java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement.
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	executeSelect(java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement.
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	executeSelect(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement.
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	executeSelect(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(int fetchSize, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return the result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return result as a Stream.
<T> java.util.stream.Stream<T>	executeSelectAsStream(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and return the result as a Stream.
java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>>	executeSelectAsStream(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and return the result as a Stream.
<T> T	executeSelectOne(IRowMapper<T> rowMapper, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and fetch one row.
<T> T	executeSelectOne(IRowMapper<T> rowMapper, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and fetch one row.
<T> T	executeSelectOne(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and fetch one row.
<T> T	executeSelectOne(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and fetch one row.
java.util.Map<java.lang.String,java.lang.Object>	executeSelectOne(java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and fetch one row.
java.util.Map<java.lang.String,java.lang.Object>	executeSelectOne(java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and fetch one row.
java.util.Map<java.lang.String,java.lang.Object>	executeSelectOne(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)	Execute a SELECT statement and fetch one row.
java.util.Map<java.lang.String,java.lang.Object>	executeSelectOne(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,?> bindValues)	Execute a SELECT statement and fetch one row.
java.sql.Connection	getConnection()	Obtain a Connection instance from the "default" data source, without transaction (autoCommit=false).
java.sql.Connection	getConnection(boolean startTransaction)	Obtain a Connection instance from the "default" data source, starts a transaction if specified.
java.sql.Connection	getConnection(java.lang.String dsName)	Obtain a Connection instance from the specified data source, without transaction (autoCommit=false).
java.sql.Connection	getConnection(java.lang.String dsName, boolean startTransaction)	Obtain a Connection instance from the specified data source, starts a transaction if specified.
IJdbcHelper	getJdbcHelper()
void	returnConnection(java.sql.Connection conn)	Return a previously obtained Connection via IJdbcHelper.getConnection() or IJdbcHelper.getConnection(boolean).
boolean	rollbackTransaction(java.sql.Connection conn)	Rollback a transaction.
BaseJdbcDao	setJdbcHelper(IJdbcHelper jdbcHelper)
boolean	startTransaction(java.sql.Connection conn)	Start a transaction.

Methods inherited from class com.github.ddth.dao.BaseDao

addProfiling, clearProfiling, close, destroy, getCache, getCacheFactory, getFromCache, getFromCache, getProfiling, init, isCacheEnabled, isCacheItemsExpireAfterWrite, putToCache, putToCache, putToCache, removeFromCache, setCacheFactory, setCacheItemsExpireAfterWrite, startProfiling

Methods inherited from class java.lang.Object

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

Constructor Detail

BaseJdbcDao

public BaseJdbcDao()

Method Detail

setJdbcHelper

public BaseJdbcDao setJdbcHelper(IJdbcHelper jdbcHelper)

getJdbcHelper

public IJdbcHelper getJdbcHelper()

getConnection

public java.sql.Connection getConnection()

Obtain a Connection instance from the "default" data source, without transaction (autoCommit=false).

Specified by:

getConnection in interface IJdbcHelper

Returns:

getConnection

public java.sql.Connection getConnection(java.lang.String dsName)

Obtain a Connection instance from the specified data source, without transaction (autoCommit=false).

Specified by:

getConnection in interface IJdbcHelper

Returns:

Since:

0.8.1

getConnection

public java.sql.Connection getConnection(boolean startTransaction)

Obtain a Connection instance from the "default" data source, starts a transaction if specified.

Specified by:

getConnection in interface IJdbcHelper

Returns:

getConnection

public java.sql.Connection getConnection(java.lang.String dsName,
                                         boolean startTransaction)

Obtain a Connection instance from the specified data source, starts a transaction if specified.

Specified by:

getConnection in interface IJdbcHelper

Returns:

Since:

0.8.1

returnConnection

public void returnConnection(java.sql.Connection conn)

Return a previously obtained Connection via IJdbcHelper.getConnection() or IJdbcHelper.getConnection(boolean).

Specified by:

returnConnection in interface IJdbcHelper

startTransaction

public boolean startTransaction(java.sql.Connection conn)

Start a transaction. Has no effect if already in a transaction.

Specified by:

startTransaction in interface IJdbcHelper

Returns:

commitTransaction

public boolean commitTransaction(java.sql.Connection conn)

Commit a transaction. Has no effect if not in a transaction.

Note: autoCommit is set to true after calling this method.

Specified by:

commitTransaction in interface IJdbcHelper

Returns:

rollbackTransaction

public boolean rollbackTransaction(java.sql.Connection conn)

Rollback a transaction. Has no effect if not in a transaction.

Note: autoCommit is set to true after calling this method.

Specified by:

rollbackTransaction in interface IJdbcHelper

Returns:

execute

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

Execute a non-SELECT statement.

Specified by:

execute in interface IJdbcHelper

bindValues - index-based bind values

Returns:

DaoException

execute

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

Execute a non-SELECT statement.

Specified by:

execute in interface IJdbcHelper

bindValues - name-based bind values

Returns:

DaoException

execute

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

Execute a non-SELECT statement.

Specified by:

execute in interface IJdbcHelper

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.

Specified by:

execute in interface IJdbcHelper

bindValues - name-based bind values

Returns:

executeSelect

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

Execute a SELECT statement.

Specified by:

executeSelect in interface IJdbcHelper

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.lang.String sql,
                                           java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement.

Specified by:

executeSelect in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

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.

Specified by:

executeSelect in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

bindValues - index-based bind values

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.lang.String sql,
                                                            java.lang.Object... bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            int fetchSize,
                                                            java.lang.String sql,
                                                            java.lang.Object... bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            java.lang.String sql,
                                                            java.lang.Object... bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            boolean autoCloseConnection,
                                                            java.lang.String sql,
                                                            java.lang.Object... bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            int fetchSize,
                                                            java.lang.String sql,
                                                            java.lang.Object... bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            boolean autoCloseConnection,
                                                            int fetchSize,
                                                            java.lang.String sql,
                                                            java.lang.Object... bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

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.

Specified by:

executeSelect in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

bindValues - name-based bind values

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.lang.String sql,
                                                            java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            int fetchSize,
                                                            java.lang.String sql,
                                                            java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

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

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            boolean autoCloseConnection,
                                                            java.lang.String sql,
                                                            java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            int fetchSize,
                                                            java.lang.String sql,
                                                            java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public <T> java.util.stream.Stream<T> executeSelectAsStream(IRowMapper<T> rowMapper,
                                                            java.sql.Connection conn,
                                                            boolean autoCloseConnection,
                                                            int fetchSize,
                                                            java.lang.String sql,
                                                            java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelect

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> executeSelect(java.lang.String sql,
                                                                                            java.lang.Object... bindValues)

Execute a SELECT statement.

Specified by:

executeSelect in interface IJdbcHelper

bindValues - index-based bind values

Returns:

executeSelect

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> executeSelect(java.lang.String sql,
                                                                                            java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement.

Specified by:

executeSelect in interface IJdbcHelper

bindValues - name-based bind value

Returns:

executeSelect

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

Execute a SELECT statement.

Specified by:

executeSelect in interface IJdbcHelper

bindValues - index-based bind values

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.lang.String sql,
                                                                                                             java.lang.Object... bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(int fetchSize,
                                                                                                             java.lang.String sql,
                                                                                                             java.lang.Object... bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             java.lang.String sql,
                                                                                                             java.lang.Object... bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             boolean autoCloseConnection,
                                                                                                             java.lang.String sql,
                                                                                                             java.lang.Object... bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             int fetchSize,
                                                                                                             java.lang.String sql,
                                                                                                             java.lang.Object... bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             boolean autoCloseConnection,
                                                                                                             int fetchSize,
                                                                                                             java.lang.String sql,
                                                                                                             java.lang.Object... bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelect

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

Execute a SELECT statement.

Specified by:

executeSelect in interface IJdbcHelper

bindValues - name-based bind values

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.lang.String sql,
                                                                                                             java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(int fetchSize,
                                                                                                             java.lang.String sql,
                                                                                                             java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             java.lang.String sql,
                                                                                                             java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             boolean autoCloseConnection,
                                                                                                             java.lang.String sql,
                                                                                                             java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             int fetchSize,
                                                                                                             java.lang.String sql,
                                                                                                             java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

Returns:

executeSelectAsStream

public java.util.stream.Stream<java.util.Map<java.lang.String,java.lang.Object>> executeSelectAsStream(java.sql.Connection conn,
                                                                                                             boolean autoCloseConnection,
                                                                                                             int fetchSize,
                                                                                                             java.lang.String sql,
                                                                                                             java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and return the result as a Stream.

Specified by:

executeSelectAsStream in interface IJdbcHelper

autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.

Returns:

executeSelectOne

public <T> T executeSelectOne(IRowMapper<T> rowMapper,
                              java.lang.String sql,
                              java.lang.Object... bindValues)

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

bindValues - index-based bind values

Returns:

executeSelectOne

public <T> T executeSelectOne(IRowMapper<T> rowMapper,
                              java.lang.String sql,
                              java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

bindValues - name-based bind values

Returns:

executeSelectOne

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

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

bindValues - index-based bind values

Returns:

executeSelectOne

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

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

Parameters:

rowMapper - to map the ResultSet to object

bindValues - name-based bind values

Returns:

executeSelectOne

public java.util.Map<java.lang.String,java.lang.Object> executeSelectOne(java.lang.String sql,
                                                                               java.lang.Object... bindValues)

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

bindValues - index-based bind values

Returns:

executeSelectOne

public java.util.Map<java.lang.String,java.lang.Object> executeSelectOne(java.lang.String sql,
                                                                               java.util.Map<java.lang.String,?> bindValues)

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

bindValues - name-based bind value

Returns:

executeSelectOne

public java.util.Map<java.lang.String,java.lang.Object> executeSelectOne(java.sql.Connection conn,
                                                                               java.lang.String sql,
                                                                               java.lang.Object... bindValues)

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

bindValues - index-based bind values

Returns:

executeSelectOne

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

Execute a SELECT statement and fetch one row.

Specified by:

executeSelectOne in interface IJdbcHelper

bindValues - name-based bind values

Returns: