org.wandora.modules

Interface DatabaseInterface.PreparedDatabaseStatement

All Known Implementing Classes:

GenericDatabaseInterface.GenericPreparedDatabaseStatement

Enclosing interface:

DatabaseInterface

public static interface DatabaseInterface.PreparedDatabaseStatement

A class that holds information about a stored database statement that can be executed later, possibly multiple times.

Method Summary

Modifier and Type	Method and Description
void	close() Closes this prepared statement, indicating that it will not be needed anymore and any resources related to it can be released.
DatabaseInterface.Rows	executeQuery() Executes this prepared statement as a query and returns the query results.
int	executeUpdate() Executes this prepared statement as an update statement.
void	setBoolean(int paramIndex, boolean o)
void	setDouble(int paramIndex, double o)
void	setFloat(int paramIndex, float o)
void	setInt(int paramIndex, int o)
void	setLong(int paramIndex, long o)
void	setNull(int paramIndex, int type)
void	setParam(int paramIndex, java.lang.Object param, int paramType) Sets a parameter of the prepared statement.
void	setShort(int paramIndex, short o)
void	setString(int paramIndex, java.lang.String o)

Method Detail

executeQuery

DatabaseInterface.Rows executeQuery()
                             throws java.sql.SQLException

Executes this prepared statement as a query and returns the query results.

Returns:

The results of the query.

Throws:

java.sql.SQLException

executeUpdate

int executeUpdate()
           throws java.sql.SQLException

Executes this prepared statement as an update statement.

Returns:

The number of rows affected.

Throws:

java.sql.SQLException

close

void close()

Closes this prepared statement, indicating that it will not be needed anymore and any resources related to it can be released.

setParam

void setParam(int paramIndex,
              java.lang.Object param,
              int paramType)
       throws java.sql.SQLException

Sets a parameter of the prepared statement. Parameters are indexed starting at 1. You can use any of the other specialised set methods for specific types of parameters.

Parameters:

paramIndex - The index of the parameter to set.

param - The value of the parameter.

paramType - The type of the parameter, as set in java.sql.Types.

Throws:

java.sql.SQLException

setString

void setString(int paramIndex,
               java.lang.String o)
        throws java.sql.SQLException

Throws:

java.sql.SQLException

setBoolean

void setBoolean(int paramIndex,
                boolean o)
         throws java.sql.SQLException

Throws:

java.sql.SQLException

setInt

void setInt(int paramIndex,
            int o)
     throws java.sql.SQLException

Throws:

java.sql.SQLException

setShort

void setShort(int paramIndex,
              short o)
       throws java.sql.SQLException

Throws:

java.sql.SQLException

setLong

void setLong(int paramIndex,
             long o)
      throws java.sql.SQLException

Throws:

java.sql.SQLException

setDouble

void setDouble(int paramIndex,
               double o)
        throws java.sql.SQLException

Throws:

java.sql.SQLException

setFloat

void setFloat(int paramIndex,
              float o)
       throws java.sql.SQLException

Throws:

java.sql.SQLException

setNull

void setNull(int paramIndex,
             int type)
      throws java.sql.SQLException

Throws:

java.sql.SQLException