public class SQLRunner
extends java.lang.Object
sql-mapper
. SQL runner contains methods to run SQL
queries and updates.Constructor and Description |
---|
SQLRunner(javax.sql.DataSource dataSource) |
Modifier and Type | Method and Description |
---|---|
void |
beginTransaction(TransactionLevel level)
Begins a new database transaction.
|
void |
closeConnection()
Closes a connection to database or returns a connection to the pool if a
pooled data source was passed to constructor.
|
void |
endTransaction()
Ends a database transaction.
|
void |
openConnection()
Opens a connection to database or gets a connection from the pool if a
pooled data source was passed to constructor.
|
<E> java.util.List<E> |
selectMany(java.lang.String query,
java.lang.Class<E> resultClass,
java.lang.Object... parameters)
Runs an SQL query and maps its results to a list of objects.
|
<E> java.util.List<E> |
selectMany(java.lang.String query,
MultipleResultsMapper<E> mapper,
java.lang.Object... parameters)
Runs an SQL query and maps its results to a list of entities.
|
<E> E |
selectOne(java.lang.String query,
java.lang.Class<E> resultClass,
java.lang.Object... parameters)
Runs an SQL query and maps its result to a single object.
|
<E> E |
selectOne(java.lang.String query,
SingleResultMapper<E> mapper,
java.lang.Object... parameters)
Runs an SQL query and maps its results to a single entity.
|
void |
update(java.lang.String update,
java.lang.Object... parameters)
Runs an SQL insert, update or delete statement.
|
public <E> E selectOne(java.lang.String query, java.lang.Class<E> resultClass, java.lang.Object... parameters) throws SQLMapperException
E
- result object typequery
- SQL select statementresultClass
- result object classparameters
- query parametersSQLMapperException
- if a database access error occurs; if query
returns more than one column; if query returns more than one resultpublic <E> E selectOne(java.lang.String query, SingleResultMapper<E> mapper, java.lang.Object... parameters) throws SQLMapperException
E
- result entity typequery
- SQL select statementmapper
- mapper which processes SQL query resultsparameters
- query parametersSQLMapperException
- if a database access error occurs; if query
returns more than one entitypublic <E> java.util.List<E> selectMany(java.lang.String query, java.lang.Class<E> resultClass, java.lang.Object... parameters) throws SQLMapperException
E
- result object typequery
- SQL select statementresultClass
- result object classparameters
- query parametersSQLMapperException
- if a database access error occurs; if query
returns more than one columnpublic <E> java.util.List<E> selectMany(java.lang.String query, MultipleResultsMapper<E> mapper, java.lang.Object... parameters) throws SQLMapperException
E
- result entity typequery
- SQL select statementmapper
- mapper which processes SQL query resultsparameters
- query parametersSQLMapperException
- if a database access error occurspublic void update(java.lang.String update, java.lang.Object... parameters) throws SQLMapperException
update
- SQL statementparameters
- update parametersSQLMapperException
- if a database access error occurspublic void beginTransaction(TransactionLevel level) throws SQLMapperException
level
- transaction isolation levelSQLMapperException
- if a database access error occurspublic void endTransaction() throws SQLMapperException
SQLMapperException
- if a database access error occurspublic void openConnection() throws SQLMapperException
SQLMapperException
- if a database access error occurspublic void closeConnection() throws SQLMapperException
SQLMapperException