org.waarp.common.database

Class DbRequest

java.lang.Object

org.waarp.common.database.DbRequest

public class DbRequest
extends Object

Class to handle request

Constructor Summary

Constructors

Constructor and Description
DbRequest(DbSession ls) Create a new request from the DbSession

Method Summary

Modifier and Type	Method and Description
void	close() Finished a Request (ready for a new one)
static String	getIsNull(String value) Test if value is null and create the string for insert/update
long	getLastId() Get the last ID autoincrement from the last request
boolean	getNext() Move the cursor to the next result
ResultSet	getResultSet()
int	query(String query) Execute a UPDATE/INSERT/DELETE statement and returns the number of row.
void	select(String select) Execute a SELECT statement and set of Result.
void	select(String select, int timeout) Execute a SELECT statement and set of Result.

Methods inherited from class java.lang.Object

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

Constructor Detail

DbRequest

public DbRequest(DbSession ls)
          throws WaarpDatabaseNoConnectionException

Create a new request from the DbSession

Parameters:

ls -

Throws:

WaarpDatabaseNoConnectionException

Method Detail

select

public void select(String select)
            throws WaarpDatabaseNoConnectionException,
                   WaarpDatabaseSqlException

Execute a SELECT statement and set of Result. The statement must not be an update/insert/delete. The previous statement and resultSet are closed.

Parameters:

select -

Throws:

WaarpDatabaseSqlException

WaarpDatabaseNoConnectionException

select

public void select(String select,
                   int timeout)
            throws WaarpDatabaseNoConnectionException,
                   WaarpDatabaseSqlException

Execute a SELECT statement and set of Result. The statement must not be an update/insert/delete. The previous statement and resultSet are closed. The timeout is applied if > 0.

Parameters:

select -

timeout - in seconds

Throws:

WaarpDatabaseSqlException

WaarpDatabaseNoConnectionException

query

public int query(String query)
          throws WaarpDatabaseNoConnectionException,
                 WaarpDatabaseSqlException

Execute a UPDATE/INSERT/DELETE statement and returns the number of row. The previous statement and resultSet are closed.

Parameters:

query -

Returns:

the number of row in the query

Throws:

WaarpDatabaseSqlException

WaarpDatabaseNoConnectionException

close

public void close()

Finished a Request (ready for a new one)

getLastId

public long getLastId()
               throws WaarpDatabaseNoDataException

Get the last ID autoincrement from the last request

Returns:

the long Id or DbConstant.ILLEGALVALUE (Long.MIN_VALUE) if an error occurs.

Throws:

WaarpDatabaseNoDataException

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

getIsNull

public static String getIsNull(String value)

Test if value is null and create the string for insert/update

Parameters:

value -

Returns:

the string as result