org.wandora.modules

Class GenericDatabaseInterface.GenericPreparedDatabaseStatement

java.lang.Object

org.wandora.modules.GenericDatabaseInterface.GenericPreparedDatabaseStatement

All Implemented Interfaces:

DatabaseInterface.PreparedDatabaseStatement

Enclosing class:

GenericDatabaseInterface

protected class GenericDatabaseInterface.GenericPreparedDatabaseStatement
extends java.lang.Object
implements DatabaseInterface.PreparedDatabaseStatement

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	connection
private int	numRetries
private java.util.ArrayList<Tuples.T2<java.lang.Integer,java.lang.Object>>	params
private java.lang.String	query
private java.sql.PreparedStatement	statement

Constructor Summary

Constructors

Constructor and Description
GenericPreparedDatabaseStatement(java.lang.String query)

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.
private void	openConnection()
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)

Methods inherited from class java.lang.Object

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

Field Detail

query

private java.lang.String query

params

private java.util.ArrayList<Tuples.T2<java.lang.Integer,java.lang.Object>> params

connection

private java.sql.Connection connection

statement

private java.sql.PreparedStatement statement

numRetries

private int numRetries

Constructor Detail

GenericPreparedDatabaseStatement

public GenericPreparedDatabaseStatement(java.lang.String query)

Method Detail

openConnection

private void openConnection()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

close

public void close()

Description copied from interface: DatabaseInterface.PreparedDatabaseStatement

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

Specified by:

close in interface DatabaseInterface.PreparedDatabaseStatement

executeQuery

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

Description copied from interface: DatabaseInterface.PreparedDatabaseStatement

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

Specified by:

executeQuery in interface DatabaseInterface.PreparedDatabaseStatement

Returns:

The results of the query.

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Description copied from interface: DatabaseInterface.PreparedDatabaseStatement

Executes this prepared statement as an update statement.

Specified by:

executeUpdate in interface DatabaseInterface.PreparedDatabaseStatement

Returns:

The number of rows affected.

Throws:

java.sql.SQLException

setParam

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

Description copied from interface: DatabaseInterface.PreparedDatabaseStatement

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.

Specified by:

setParam in interface DatabaseInterface.PreparedDatabaseStatement

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

setBoolean

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

Specified by:

setBoolean in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setDouble

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

Specified by:

setDouble in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setFloat

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

Specified by:

setFloat in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setInt

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

Specified by:

setInt in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setLong

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

Specified by:

setLong in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setNull

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

Specified by:

setNull in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setShort

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

Specified by:

setShort in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException

setString

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

Specified by:

setString in interface DatabaseInterface.PreparedDatabaseStatement

Throws:

java.sql.SQLException