| java.lang.Object
 com.uwyn.rife.database.DbQueryManager
All known Subclasses: com.uwyn.rife.scheduler.taskoptionmanagers.DatabaseTaskoptions, com.uwyn.rife.authentication.sessionvalidators.DatabaseSessionValidator, com.uwyn.rife.resources.DatabaseResources, com.uwyn.rife.scheduler.taskmanagers.DatabaseTasks, com.uwyn.rife.cmf.dam.contentstores.DatabaseContentStore, com.uwyn.rife.authentication.credentialsmanagers.DatabaseUsers, database.Basic, com.uwyn.rife.database.querymanagers.generic.AbstractGenericQueryManager, com.uwyn.rife.authentication.sessionmanagers.DatabaseSessions, com.uwyn.rife.authentication.remembermanagers.DatabaseRemember, com.uwyn.rife.cmf.dam.contentstores.DatabaseRawStore, tutorial.friends.backend.FriendManager, com.uwyn.rife.database.TestDbQueryManagerImpl, com.uwyn.rife.mail.dam.DatabaseMailQueue, com.uwyn.rife.cmf.dam.contentmanagers.DatabaseContent, com.uwyn.rife.scheduler.schedulermanagers.DatabaseScheduler,
| Constructor Summary | |
| public | DbQueryManager(Datasource datasource)
Instantiates a new DbQueryManager object and ties it to
the provided datasource. |
| Method Summary | |
| public Object | clone()
Simply clones the instance with the default clone method. | | public boolean | executeFetchAll(ReadQuery query, DbRowProcessor rowProcessor)
Safely and quickly fetches all the rows from the results of a select
query. | | public boolean | executeFetchAll(ReadQuery query, DbRowProcessor rowProcessor, DbPreparedStatementHandler handler)
Safely fetches all the rows from the results of a customizable select
query. | | public List<BeanType> | executeFetchAllBeans(ReadQuery query, Class<BeanType> beanClass)
Safely and quickly fetches the all the bean instances from the results
of a select query. | | public List<BeanType> | executeFetchAllBeans(ReadQuery query, Class<BeanType> beanClass, DbPreparedStatementHandler handler)
Safely fetches the all the bean instances from the results of a
customizable select query. | | public boolean | executeFetchFirst(ReadQuery query, DbRowProcessor rowProcessor)
Safely and quickly fetches the first row from the results of a select
query. | | public boolean | executeFetchFirst(ReadQuery query, DbRowProcessor rowProcessor, DbPreparedStatementHandler handler)
Safely fetches the first row from the results of a customizable select
query. | | public BeanType | executeFetchFirstBean(ReadQuery query, Class<BeanType> beanClass)
Safely and quickly fetches the first bean instance from the results of
a select query. | | public BeanType | executeFetchFirstBean(ReadQuery query, Class<BeanType> beanClass, DbPreparedStatementHandler handler)
Safely fetches the first bean instance from the results of a
customizable select query. | | public boolean | executeGetFirstBoolean(ReadQuery query)
Safely and quickly retrieves the first cell as a boolean
from the results of a select query. | | public boolean | executeGetFirstBoolean(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a boolean from the
results of a customizable select query. | | public byte | executeGetFirstByte(ReadQuery query)
Safely and quickly retrieves the first cell as a byte from
the results of a select query. | | public byte | executeGetFirstByte(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a byte from the results
of a customizable select query. | | public byte[] | executeGetFirstBytes(ReadQuery query)
Safely and quickly retrieves the first cell as a byte
array from the results of a select query. | | public byte[] | executeGetFirstBytes(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a byte array from the
results of a customizable select query. | | public java.sql.Date | executeGetFirstDate(ReadQuery query)
Safely and quickly retrieves the first cell as a sql Date
from the results of a select query. | | public java.sql.Date | executeGetFirstDate(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a sql Date from the
results of a customizable select query. | | public java.sql.Date | executeGetFirstDate(ReadQuery query, Calendar cal)
Safely and quickly retrieves the first cell as a sql Date
from the results of a select query. | | public java.sql.Date | executeGetFirstDate(ReadQuery query, Calendar cal, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a sql Date from the
results of a customizable select query. | | public double | executeGetFirstDouble(ReadQuery query)
Safely and quickly retrieves the first cell as a double
from the results of a select query. | | public double | executeGetFirstDouble(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a double from the
results of a customizable select query. | | public float | executeGetFirstFloat(ReadQuery query)
Safely and quickly retrieves the first cell as a float
from the results of a select query. | | public float | executeGetFirstFloat(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a float from the
results of a customizable select query. | | public int | executeGetFirstInt(ReadQuery query)
Safely and quickly retrieves the first cell as a int from
the results of a select query. | | public int | executeGetFirstInt(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a int from the results
of a customizable select query. | | public long | executeGetFirstLong(ReadQuery query)
Safely and quickly retrieves the first cell as a long from
the results of a select query. | | public long | executeGetFirstLong(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a long from the results
of a customizable select query. | | public short | executeGetFirstShort(ReadQuery query)
Safely and quickly retrieves the first cell as a short
from the results of a select query. | | public short | executeGetFirstShort(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a short from the
results of a customizable select query. | | public String | executeGetFirstString(ReadQuery query)
Safely and quickly retrieves the first cell as a String
from the results of a select query. | | public String | executeGetFirstString(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a String from the
results of a customizable select query. | | public java.sql.Time | executeGetFirstTime(ReadQuery query)
Safely and quickly retrieves the first cell as a sql Time
from the results of a select query. | | public java.sql.Time | executeGetFirstTime(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a sql Time from the
results of a customizable select query. | | public java.sql.Time | executeGetFirstTime(ReadQuery query, Calendar cal)
Safely and quickly retrieves the first cell as a sql Time
from the results of a select query. | | public java.sql.Time | executeGetFirstTime(ReadQuery query, Calendar cal, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a sql Time from the
results of a customizable select query. | | public java.sql.Timestamp | executeGetFirstTimestamp(ReadQuery query)
Safely and quickly retrieves the first cell as a sql
Timestamp from the results of a select query. | | public java.sql.Timestamp | executeGetFirstTimestamp(ReadQuery query, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a sql Timestamp from
the results of a customizable select query. | | public java.sql.Timestamp | executeGetFirstTimestamp(ReadQuery query, Calendar cal)
Safely and quickly retrieves the first cell as a sql
Timestamp from the results of a select query. | | public java.sql.Timestamp | executeGetFirstTimestamp(ReadQuery query, Calendar cal, DbPreparedStatementHandler handler)
Safely retrieves the first cell as a sql Timestamp from
the results of a customizable select query. | | public boolean | executeHasResultRows(ReadQuery query)
Safely and quickly verifies if a select query returns any rows. | | public boolean | executeHasResultRows(ReadQuery query, DbPreparedStatementHandler handler)
Safely verifies if a customizable select query returns any rows. | | public ResultType | executeQuery(ReadQuery query, DbPreparedStatementHandler handler)
Executes a customizable select statement. | | public ResultType | executeQuery(ReadQuery query, DbResultSetHandler handler)
Executes a select statement and handle the results in a custom fashion.
It relies on the wrapped
DbPreparedStatement.executeQuery method, but also automatically closes the statement after its execution
and allows interaction with the resultset through an optional instance
of
DbResultSetHandler .
This method is typically used when you need to interact with the
results of a query, but still want to benefit of a safety net that
ensures that the allocated statement will be closed. | | public DbStatement | executeQuery(ReadQuery query)
Executes a query statement in a connection of this
DbQueryManager's Datasource. | | public int | executeUpdate(String sql)
Safely and quickly executes an update statement. | | public int | executeUpdate(Query query)
Safely and quickly executes an update statement. | | public int | executeUpdate(Query query, DbPreparedStatementHandler handler)
Safely execute an updates statement. | | public ResultType | executeUseFirstAsciiStream(ReadQuery query, InputStreamUser user)
Safely and quickly retrieves the first cell as an ASCII
InputStream from the results of a select query. | | public ResultType | executeUseFirstAsciiStream(ReadQuery query, InputStreamUser user, DbPreparedStatementHandler handler)
Safely retrieves the first cell as an ASCII InputStream
from the results of a customizable select query. | | public ResultType | executeUseFirstBinaryStream(ReadQuery query, InputStreamUser user)
Safely and quickly retrieves the first cell as an binary
InputStream from the results of a select query. | | public ResultType | executeUseFirstBinaryStream(ReadQuery query, InputStreamUser user, DbPreparedStatementHandler handler)
Safely retrieves the first cell as an binary InputStream
from the results of a customizable select query. | | public ResultType | executeUseFirstCharacterStream(ReadQuery query, ReaderUser user)
Safely and quickly retrieves the first cell as an character
Reader from the results of a select query. | | public ResultType | executeUseFirstCharacterStream(ReadQuery query, ReaderUser user, DbPreparedStatementHandler handler)
Safely retrieves the first cell as an character Reader
from the results of a customizable select query. | | public boolean | fetch(ResultSet resultSet)
Fetches the next row of a resultset without processing it in any way. | | public boolean | fetch(ResultSet resultSet, DbRowProcessor rowProcessor)
Fetches the next row of a resultset and processes it through a
DbRowProcessor. | | public boolean | fetchAll(ResultSet resultSet, DbRowProcessor rowProcessor)
Fetches all the next rows of a resultset and processes it through a
DbRowProcessor. | | public DbConnection | getConnection()
Obtains a DbConnection of this DbQueryManager's
Datasource. | | public Datasource | getDatasource()
Retrieves the Datasource of this
DbQueryManager. | | public ResultType | inTransaction(DbTransactionUser user)
Ensures that all the instructions that are executed in the provided
DbTransactionUser instance are executed inside a transaction
and committed afterwards. | | public ResultType | reserveConnection(DbConnectionUser user)
Reserves a database connection for a this particular thread for all the
instructions that are executed in the provided
DbConnectionUser instance. |
| DbQueryManager | | public DbQueryManager(Datasource datasource)(Code) | | Instantiates a new DbQueryManager object and ties it to
the provided datasource.
Parameters:
datasource - the datasource that will be used to obtain databaseconnections from
since:
1.0 |
| clone | | public Object clone()(Code) | | Simply clones the instance with the default clone method. This creates
a shallow copy of all fields and the clone will in fact just be another
reference to the same underlying data. The independence of each cloned
instance is consciously not respected since they rely on resources that
can't be cloned.
since:
1.0 a clone of this instance |
| executeFetchAll | | public boolean executeFetchAll(ReadQuery query, DbRowProcessor rowProcessor, DbPreparedStatementHandler handler) throws DatabaseException(Code) | | Safely fetches all the rows from the results of a customizable select
query. It relies on the wrapped
DbQueryManager.fetchAll(ResultSet,DbRowProcessor) method, but also automatically
closes the statement after its execution and allows customization of
the prepared statement through an optional instance of
DbPreparedStatementHandler .
Example
DbQueryManager manager = new DbQueryManager(datasource);
Select select = new Select(datasource);
select.from("person").whereParameter("gender", "=");
DbRowProcessor processor = new YourProcessor();
final String name = "m";
boolean result = manager.executeFetchAll(select, processor, new DbPreparedStatementHandler() {
public void setParameters(DbPreparedStatement statement)
{
statement
.setString("gender", name);
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
rowProcessor - a DbRowProcessor instance, if it'snull no processing will be performed on the fetched row
Parameters:
handler - an instance of DbPreparedStatementHandlerthat will be used to customize the query execution; ornull if you don't want to customize it at all true if rows were retrieved; orfalse if there are no more rows .
exception:
DatabaseException - see DbPreparedStatement.executeQueryand DbQueryManager.fetchAll(ResultSet,DbRowProcessor)
See Also: DbQueryManager.fetchAll(ResultSet,DbRowProcessor)
See Also: DbRowProcessor
since:
1.0
|
| executeFetchAllBeans | | public List<BeanType> executeFetchAllBeans(ReadQuery query, Class<BeanType> beanClass, DbPreparedStatementHandler handler) throws DatabaseException(Code) | | Safely fetches the all the bean instances from the results of a
customizable select query. It relies on the wrapped
DbQueryManager.executeFetchAll(ReadQuery,DbRowProcessor) method, but automatically
uses an appropriate
DbBeanFetcher instance, returns the results
and allows customization of the prepared statement through an optional
instance of
DbPreparedStatementHandler .
Example
DbQueryManager manager = new DbQueryManager(datasource);
Select select = new Select(datasource);
select.from("person").fields(Person.class).whereParameter("gender", "=");
final String name = "m";
List persons = manager.executeFetchAllBeans(select, Person.class, new DbPreparedStatementHandler() {
public void setParameters(DbPreparedStatement statement)
{
statement
.setString("gender", name);
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
beanClass - the class of the bean
Parameters:
handler - an instance of DbPreparedStatementHandlerthat will be used to customize the query execution; ornull if you don't want to customize it at all a List instance with all the beans, the list is empty ifno beans could be returned
exception:
DatabaseException - see DbBeanFetcher and DbQueryManager.executeFetchAll(ReadQuery,DbRowProcessor)
See Also: DbQueryManager.executeFetchAll(ReadQuery,DbRowProcessor)
See Also: DbBeanFetcher
since:
1.0 |
| executeFetchFirst | | public boolean executeFetchFirst(ReadQuery query, DbRowProcessor rowProcessor, DbPreparedStatementHandler handler) throws DatabaseException(Code) | | Safely fetches the first row from the results of a customizable select
query. It relies on the wrapped
DbQueryManager.fetch(ResultSet,DbRowProcessor) method, but also automatically
closes the statement after its execution and allows customization of
the prepared statement through an optional instance of
DbPreparedStatementHandler .
Example
DbQueryManager manager = new DbQueryManager(datasource);
Select select = new Select(datasource);
select.from("person").whereParameter("name", "=");
DbRowProcessor processor = new YourProcessor();
final String name = "you";
boolean result = manager.executeFetchFirst(select, processor, new DbPreparedStatementHandler() {
public void setParameters(DbPreparedStatement statement)
{
statement
.setString("name", name);
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
rowProcessor - a DbRowProcessor instance, if it'snull no processing will be performed on the fetched row
Parameters:
handler - an instance of DbPreparedStatementHandlerthat will be used to customize the query execution; ornull if you don't want to customize it at all true if a row was retrieved; orfalse if there are no more rows .
exception:
DatabaseException - see DbPreparedStatement.executeQueryand DbQueryManager.fetch(ResultSet,DbRowProcessor)
See Also: DbQueryManager.fetch(ResultSet,DbRowProcessor)
See Also: DbRowProcessor
since:
1.0
|
| executeFetchFirstBean | | public BeanType executeFetchFirstBean(ReadQuery query, Class<BeanType> beanClass, DbPreparedStatementHandler handler) throws DatabaseException(Code) | | Safely fetches the first bean instance from the results of a
customizable select query. It relies on the wrapped
DbQueryManager.executeFetchFirst(ReadQuery,DbRowProcessor) method, but automatically
uses an appropriate
DbBeanFetcher instance, returns the
resulting bean and allows customization of the prepared statement
through an optional instance of
DbPreparedStatementHandler .
Example
DbQueryManager manager = new DbQueryManager(datasource);
Select select = new Select(datasource);
select.from("person").fields(Person.class).whereParameter("name", "=");
final String name = "you";
Person person = manager.executeFetchFirstBean(select, Person.class, new DbPreparedStatementHandler() {
public void setParameters(DbPreparedStatement statement)
{
statement
.setString("name", name);
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
beanClass - the class of the bean
Parameters:
handler - an instance of DbPreparedStatementHandlerthat will be used to customize the query execution; ornull if you don't want to customize it at all true if a row was retrieved; orfalse if there are no more rows .
exception:
DatabaseException - see DbBeanFetcher and DbQueryManager.executeFetchFirst(ReadQuery,DbRowProcessor)
See Also: DbQueryManager.executeFetchFirst(ReadQuery,DbRowProcessor)
See Also: DbBeanFetcher
since:
1.0
|
| executeQuery | | public ResultType executeQuery(ReadQuery query, DbPreparedStatementHandler handler) throws DatabaseException(Code) | | Executes a customizable select statement. It relies on the wrapped
DbPreparedStatement.executeQuery method, but also
automatically closes the statement after its execution and allows
complete customization of the prepared statement through an optional
instance of
DbPreparedStatementHandler .
This method is typically used when you need to fully customize a
query at runtime, but still want to benefit of a safety net that
ensures that the allocated statement will be closed. Often another more
specialized method in this class will already serve your needs, so be
sure to verify that you actually need to intervene on every front.
Example
DbQueryManager manager = new DbQueryManager(datasource);
Select select = new Select(datasource);
select
.field("first")
.field("last")
.from("person")
.whereParameter("name", "=");
final String name = "you";
String result = (String)manager.executeQuery(select, new DbPreparedStatementHandler() {
public void setParameters(DbPreparedStatement statement)
{
statement
.setString("name", name);
}
public Object concludeResults(DbResultSet resultset)
throws SQLException
{
return resultset.getString("first")+" "+resultset.getString("last");
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
handler - an instance of DbPreparedStatementHandlerthat will be used to customize the query execution; ornull if you don't want to customize it at all the object that was returned by the overridden DbResultSetHandler.concludeResults(DbResultSet) concludeResultsmethod; ornull if this method wasn't overridden
exception:
DatabaseException - see DbPreparedStatement.executeQuery
See Also: DbPreparedStatement.executeQuery
See Also: DbPreparedStatementHandler
since:
1.0
|
| executeQuery | | public ResultType executeQuery(ReadQuery query, DbResultSetHandler handler) throws DatabaseException(Code) | | Executes a select statement and handle the results in a custom fashion.
It relies on the wrapped
DbPreparedStatement.executeQuery method, but also automatically closes the statement after its execution
and allows interaction with the resultset through an optional instance
of
DbResultSetHandler .
This method is typically used when you need to interact with the
results of a query, but still want to benefit of a safety net that
ensures that the allocated statement will be closed. Often another more
specialized method in this class will already serve your needs, so be
sure to verify that there isn't another one that's better suited.
Example
DbQueryManager manager = new DbQueryManager(datasource);
Select select = new Select(datasource);
select
.field("first")
.field("last")
.from("person");
String result = (String)manager.executeQuery(select, new DbResultSetHandler() {
public Object concludeResults(DbResultSet resultset)
throws SQLException
{
return resultset.getString("first")+" "+resultset.getString("last");
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
handler - an instance of DbResultSetHandlernull if you don't want to customize it at all the object that was returned by the overridden DbResultSetHandler.concludeResults(DbResultSet) concludeResultsmethod; ornull if this method wasn't overridden
exception:
DatabaseException - see DbPreparedStatement.executeQuery
See Also: DbPreparedStatement.executeQuery
See Also: DbResultSetHandler
since:
1.0
|
| executeUpdate | | public int executeUpdate(Query query, DbPreparedStatementHandler handler) throws DatabaseException(Code) | | Safely execute an updates statement. It relies on the wrapped
DbPreparedStatement.executeUpdate method, but also automatically
closes the statement after its execution and allows customization of
the prepared statement through an optional instance of
DbPreparedStatementHandler .
This method is typically used when you need to fully customize a
query at runtime, but still want to benefit of a safety net that
ensures that the allocated statement will be closed.
Example
DbQueryManager manager = new DbQueryManager(datasource);
Insert insert = new Insert(datasource);
insert.into("person").fieldParameter("name");
final String name = "me";
int count = manager.executeUpdate(insert, new DbPreparedStatementHandler() {
public void setParameters(DbPreparedStatement statement)
{
statement
.setString("name", name);
}
});
Parameters:
query - the query builder instance that needs to be executed
Parameters:
handler - an instance of DbPreparedStatementHandlerthat will be used to customize the query execution; ornull if you don't want to customize it at all the row count for the executed query
exception:
DatabaseException - see DbPreparedStatement.executeUpdate
See Also: DbPreparedStatement.executeUpdate
See Also: DbPreparedStatementHandler
since:
1.0 |
| fetch | | public boolean fetch(ResultSet resultSet, DbRowProcessor rowProcessor) throws DatabaseException(Code) | | Fetches the next row of a resultset and processes it through a
DbRowProcessor.
Parameters:
resultSet - a valid ResultSet instance
Parameters:
rowProcessor - a DbRowProcessor instance, if it'snull no processing will be performed on the fetched row true if a new row was retrieved; orfalse if there are no more rows .
exception:
DatabaseException - when an error occurred during the fetch ofthe next row in the resultset
See Also: DbQueryManager.fetch(ResultSet)
See Also: DbRowProcessor
since:
1.0
|
| fetchAll | | public boolean fetchAll(ResultSet resultSet, DbRowProcessor rowProcessor) throws DatabaseException(Code) | | Fetches all the next rows of a resultset and processes it through a
DbRowProcessor.
Parameters:
resultSet - a valid ResultSet instance
Parameters:
rowProcessor - a DbRowProcessor instance, if it'snull no processing will be performed on the fetched rows true if rows were fetched; orfalse if the resultset contained no rows.
exception:
DatabaseException - when an error occurred during the fetch ofthe next rows in the resultset
See Also: DbRowProcessor
since:
1.0
|
| getDatasource | | public Datasource getDatasource()(Code) | | Retrieves the Datasource of this
DbQueryManager.
the requested Datasource
since:
1.0 |
| inTransaction | | public ResultType inTransaction(DbTransactionUser user) throws InnerClassException, DatabaseException(Code) | | Ensures that all the instructions that are executed in the provided
DbTransactionUser instance are executed inside a transaction
and committed afterwards. This doesn't mean that a new transaction will
always be created. If a transaction is already active, it will simply
be re-used. The commit will also only be take place if a new
transaction has actually been started, otherwise it's the
responsibility of the enclosing code to execute the commit. If an
runtime exception occurs during the execution and a new transaction has
been started beforehand, it will be automatically rolled back.
If you need to explicitly roll back an active transaction, use the
DbTransactionUser.rollback rollback method of the
DbTransactionUser class. If you use a regular rollback
method, it's possible that you're inside a nested transaction executed
and that after the rollback, other logic continues to be executed
outside the transaction. Using the correct
DbTransactionUser.rollback rollback method, stops the execution of
the active DbTransactionUser and breaks out of any number
of them nesting.
It's recommended to always use transactions through this method
since it ensures that transactional code can be re-used and enclosed in
other transactional code. Correctly using the regular
transaction-related methods requires great care and planning and often
results in error-prone and not reusable code.
Example
final Insert insert = new Insert(mDatasource).into("valuelist").field("value", 232);
final DbQueryManager manager = new DbQueryManager(datasource);
manager.inTransaction(new DbTransactionUserWithoutResult() {
public void useTransactionWithoutResult()
throws InnerClassException
{
manager.executeUpdate(insert);
manager.executeUpdate(insert);
}
});
Parameters:
user - an instance of DbTransactionUser that containsthe logic that will be executed the return value from the useTransaction method ofthe provided DbTransactionUser instance
exception:
DatabaseException - when errors occurs during the handling ofthe transaction
exception:
InnerClassException - when errors occurs inside theDbTransactionUser
See Also: DbTransactionUser.useTransaction
See Also: DbTransactionUserWithoutResult.useTransactionWithoutResult
since:
1.0 |
| reserveConnection | | public ResultType reserveConnection(DbConnectionUser user) throws InnerClassException, DatabaseException(Code) | | Reserves a database connection for a this particular thread for all the
instructions that are executed in the provided
DbConnectionUser instance.
This is typically used to ensure that a series of operations is done
with the same connection, even though a database pool is used in the
background.
Example
Person person;
final Insert store_data = new Insert(datasource).into("person").fields(person);
final Select get_last_id = new Select(datasource).from("person").field("LAST_INSERT_ID()");
final DbQueryManager manager = new DbQueryManager(datasource);
int id = ((Integer)manager.reserveConnection(new DbConnectionUser() {
public Integer useConnection(DbConnection connection)
{
manager.executeUpdate(store_data);
return new Integer(manager.executeGetFirstInt(get_last_id));
}
})).intValue();
Parameters:
user - an instance of DbConnectionUser that containsthe logic that will be executed the return value from the useConnection method ofthe provided DbConnectionUser instance
exception:
DatabaseException - when errors occurs during the reservationof a connection for this thread
exception:
InnerClassException - when errors occurs inside theDbConnectionUser
See Also: DbConnectionUser.useConnection(DbConnection)
since:
1.0 |
|
|