Package com.github.kagkarlsson.jdbc

Class JdbcRunner

java.lang.Object

com.github.kagkarlsson.jdbc.JdbcRunner

public class JdbcRunner
extends Object

Constructor Summary

Constructors

Constructor	Description
JdbcRunner(ConnectionSupplier connectionSupplier, TransactionContextProvider transactionContextProvider)
JdbcRunner(DataSource dataSource)
JdbcRunner(DataSource dataSource, boolean commitWhenAutocommitDisabled)
JdbcRunner(DataSource dataSource, boolean commitWhenAutocommitDisabled, TransactionContextProvider transactionContextProvider)

Method Summary

Modifier and Type	Method	Description
int	execute(String query, PreparedStatementSetter setParameters)
<T> T	execute(String query, PreparedStatementSetter setParameters, com.github.kagkarlsson.jdbc.JdbcRunner.AfterExecution<T,Boolean> afterExecution)
<U> int[]	executeBatch(String query, List<U> batchValues, BatchPreparedStatementSetter<U> setParameters)
<T> T	inTransaction(Function<JdbcRunner,T> doInTransaction)	Creates a transactional JdbcRunner that can be used to execute operations in a single transaction.
<T> T	query(String query, PreparedStatementSetter setParameters, ResultSetMapper<T> resultSetMapper)
<T> List<T>	query(String query, PreparedStatementSetter setParameters, RowMapper<T> rowMapper)

Methods inherited from class java.lang.Object

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

Constructor Details

JdbcRunner

public JdbcRunner(DataSource dataSource)

JdbcRunner

public JdbcRunner(DataSource dataSource,
 boolean commitWhenAutocommitDisabled)

JdbcRunner

public JdbcRunner(DataSource dataSource,
 boolean commitWhenAutocommitDisabled,
 TransactionContextProvider transactionContextProvider)

JdbcRunner

public JdbcRunner(ConnectionSupplier connectionSupplier,
 TransactionContextProvider transactionContextProvider)

Method Details

inTransaction

public <T> T inTransaction(Function<JdbcRunner,T> doInTransaction)

Creates a transactional JdbcRunner that can be used to execute operations in a single transaction. Will currently not detect externally managed transactions (e.g. Spring-transactions), only prevent nested transactions using inTransaction(..). Will always commit or rollback.

Type Parameters:

T -

Parameters:

doInTransaction -

Returns:

execute

public int execute(String query,
 PreparedStatementSetter setParameters)

query

public <T> List<T> query(String query,
 PreparedStatementSetter setParameters,
 RowMapper<T> rowMapper)

query

public <T> T query(String query,
 PreparedStatementSetter setParameters,
 ResultSetMapper<T> resultSetMapper)

execute

public <T> T execute(String query,
 PreparedStatementSetter setParameters,
 com.github.kagkarlsson.jdbc.JdbcRunner.AfterExecution<T,Boolean> afterExecution)

executeBatch

public <U> int[] executeBatch(String query,
 List<U> batchValues,
 BatchPreparedStatementSetter<U> setParameters)