org.waarp.common.database

Class DbPreparedStatement

java.lang.Object

org.waarp.common.database.DbPreparedStatement

public class DbPreparedStatement
extends Object

Class to handle PrepareStatement

Constructor Summary

Constructors

Constructor and Description
DbPreparedStatement(DbSession ls) Create a DbPreparedStatement from DbSession object
DbPreparedStatement(DbSession ls, String request) Create a DbPreparedStatement from DbSession object and a request
DbPreparedStatement(DbSession ls, String request, int nbFetch) Create a DbPreparedStatement from DbSession object and a request

Method Summary

Modifier and Type	Method and Description
void	close() Close the resultSet if any
void	createPrepareStatement(String requestarg) Create a preparedStatement from request
void	executeQuery() Execute a Select preparedStatement
int	executeUpdate() Execute the Update/Insert/Delete preparedStatement
DbSession	getDbSession()
boolean	getNext() Move the cursor to the next result
PreparedStatement	getPreparedStatement()
ResultSet	getResultSet()
boolean	isReady()
void	realClose() Really close the preparedStatement and the resultSet if any
void	recreatePreparedStatement() In case of closing database connection, it is possible to reopen a long term preparedStatement as it was at creation.

Methods inherited from class java.lang.Object

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

Constructor Detail

DbPreparedStatement

public DbPreparedStatement(DbSession ls)
                    throws WaarpDatabaseNoConnectionException

Create a DbPreparedStatement from DbSession object

Parameters:

ls -

Throws:

WaarpDatabaseNoConnectionException

DbPreparedStatement

public DbPreparedStatement(DbSession ls,
                           String request)
                    throws WaarpDatabaseNoConnectionException,
                           WaarpDatabaseSqlException

Create a DbPreparedStatement from DbSession object and a request

Parameters:

ls -

request -

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

DbPreparedStatement

public DbPreparedStatement(DbSession ls,
                           String request,
                           int nbFetch)
                    throws WaarpDatabaseNoConnectionException,
                           WaarpDatabaseSqlException

Create a DbPreparedStatement from DbSession object and a request

Parameters:

ls -

request -

nbFetch - the number of pre fetch rows

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

Method Detail

createPrepareStatement

public void createPrepareStatement(String requestarg)
                            throws WaarpDatabaseNoConnectionException,
                                   WaarpDatabaseSqlException

Create a preparedStatement from request

Parameters:

requestarg -

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

recreatePreparedStatement

public void recreatePreparedStatement()
                               throws WaarpDatabaseNoConnectionException,
                                      WaarpDatabaseSqlException

In case of closing database connection, it is possible to reopen a long term preparedStatement as it was at creation.

Throws:

WaarpDatabaseSqlException

WaarpDatabaseNoConnectionException

executeQuery

public void executeQuery()
                  throws WaarpDatabaseNoConnectionException,
                         WaarpDatabaseSqlException

Execute a Select preparedStatement

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

executeUpdate

public int executeUpdate()
                  throws WaarpDatabaseNoConnectionException,
                         WaarpDatabaseSqlException

Execute the Update/Insert/Delete preparedStatement

Returns:

the number of row

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

close

public void close()

Close the resultSet if any

realClose

public void realClose()

Really close the preparedStatement and the resultSet if any

getNext

public boolean getNext()
                throws WaarpDatabaseNoConnectionException,
                       WaarpDatabaseSqlException

Move the cursor to the next result

Returns:

True if there is a next result, else False

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

getResultSet

public ResultSet getResultSet()
                       throws WaarpDatabaseNoConnectionException

Returns:

The resultSet (can be used in conjunction of getNext())

Throws:

WaarpDatabaseNoConnectionException

getPreparedStatement

public PreparedStatement getPreparedStatement()
                                       throws WaarpDatabaseNoConnectionException

Returns:

The preparedStatement (should be used in conjunction of createPreparedStatement)

Throws:

WaarpDatabaseNoConnectionException

getDbSession

public DbSession getDbSession()

Returns:

the dbSession

isReady

public boolean isReady()

Returns:

the isReady