com.elvyx
Class Statement

java.lang.Object
  com.elvyx.Relayer
      com.elvyx.ExtStatement
          com.elvyx.Statement

All Implemented Interfaces:

java.sql.Statement

public class Statement
extends ExtStatement
implements java.sql.Statement

Statement wrapper

Since:

1.0

Version:

$Revision: 1.7 $

Author:

Armando Perdomo

Field Summary

protected java.sql.Statement

realStatement

Fields inherited from class com.elvyx.ExtStatement

connection, extra, sql

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

protected	Statement()
	Statement(Connection _connection)
	Statement(Connection _connection, int resultSetType, int resultSetConcurrency)
	Statement(Connection _connection, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

Method Summary

void	addBatch(java.lang.String _sql)
void	cancel()
void	clearBatch()
void	clearWarnings()
void	close()
boolean	execute(java.lang.String _sql)
boolean	execute(java.lang.String _sql, int autoGeneratedKeys)
boolean	execute(java.lang.String _sql, int[] columnIndexes)
boolean	execute(java.lang.String _sql, java.lang.String[] columnNames)
int[]	executeBatch()
java.sql.ResultSet	executeQuery(java.lang.String _sql)
int	executeUpdate(java.lang.String _sql)
int	executeUpdate(java.lang.String _sql, int autoGeneratedKeys)
int	executeUpdate(java.lang.String _sql, int[] columnIndexes)
int	executeUpdate(java.lang.String _sql, java.lang.String[] columnNames)
java.sql.Connection	getConnection()
int	getFetchDirection()
int	getFetchSize()
java.sql.ResultSet	getGeneratedKeys()
int	getMaxFieldSize()
int	getMaxRows()
boolean	getMoreResults()
boolean	getMoreResults(int current)
int	getQueryTimeout()
java.sql.ResultSet	getRealResultSet(java.lang.String _sql)
java.sql.ResultSet	getResultSet()
int	getResultSetConcurrency()
int	getResultSetHoldability()
int	getResultSetType()
int	getUpdateCount()
java.sql.SQLWarning	getWarnings()
void	setCursorName(java.lang.String name)
void	setEscapeProcessing(boolean enable)
void	setFetchDirection(int direction)
void	setFetchSize(int rows)
void	setMaxFieldSize(int max)
void	setMaxRows(int max)
void	setQueryTimeout(int seconds)
protected void	submit()

Methods inherited from class com.elvyx.ExtStatement

getSql, submit

Methods inherited from class com.elvyx.Relayer

beforeSubmit, getCloseDate, getInitDate, setCloseDate, setInitDate, startTimer, stopTimer

Methods inherited from class java.lang.Object

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

Field Detail

realStatement

protected java.sql.Statement realStatement

Constructor Detail

Statement

protected Statement()

Statement

public Statement(Connection _connection)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

Statement

public Statement(Connection _connection,
                 int resultSetType,
                 int resultSetConcurrency)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

Statement

public Statement(Connection _connection,
                 int resultSetType,
                 int resultSetConcurrency,
                 int resultSetHoldability)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

executeUpdate

public int executeUpdate(java.lang.String _sql)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

Specified by:

executeUpdate in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.executeUpdate(java.lang.String)

getMaxFieldSize

public int getMaxFieldSize()
                    throws java.sql.SQLException

Specified by:

getMaxFieldSize in interface java.sql.Statement

Specified by:

getMaxFieldSize in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getMaxFieldSize()

setMaxFieldSize

public void setMaxFieldSize(int max)
                     throws java.sql.SQLException

Specified by:

setMaxFieldSize in interface java.sql.Statement

Specified by:

setMaxFieldSize in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setMaxFieldSize(int)

getMaxRows

public int getMaxRows()
               throws java.sql.SQLException

Specified by:

getMaxRows in interface java.sql.Statement

Specified by:

getMaxRows in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getMaxRows()

setMaxRows

public void setMaxRows(int max)
                throws java.sql.SQLException

Specified by:

setMaxRows in interface java.sql.Statement

Specified by:

setMaxRows in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setMaxRows(int)

setEscapeProcessing

public void setEscapeProcessing(boolean enable)
                         throws java.sql.SQLException

Specified by:

setEscapeProcessing in interface java.sql.Statement

Specified by:

setEscapeProcessing in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setEscapeProcessing(boolean)

getQueryTimeout

public int getQueryTimeout()
                    throws java.sql.SQLException

Specified by:

getQueryTimeout in interface java.sql.Statement

Specified by:

getQueryTimeout in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getQueryTimeout()

setQueryTimeout

public void setQueryTimeout(int seconds)
                     throws java.sql.SQLException

Specified by:

setQueryTimeout in interface java.sql.Statement

Specified by:

setQueryTimeout in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setQueryTimeout(int)

cancel

public void cancel()
            throws java.sql.SQLException

Specified by:

cancel in interface java.sql.Statement

Specified by:

cancel in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.cancel()

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface java.sql.Statement

Specified by:

getWarnings in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getWarnings()

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Statement

Specified by:

clearWarnings in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.clearWarnings()

setCursorName

public void setCursorName(java.lang.String name)
                   throws java.sql.SQLException

Specified by:

setCursorName in interface java.sql.Statement

Specified by:

setCursorName in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setCursorName(java.lang.String)

getResultSet

public java.sql.ResultSet getResultSet()
                                throws java.sql.SQLException

Specified by:

getResultSet in interface java.sql.Statement

Specified by:

getResultSet in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getResultSet()

getUpdateCount

public int getUpdateCount()
                   throws java.sql.SQLException

Specified by:

getUpdateCount in interface java.sql.Statement

Specified by:

getUpdateCount in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getUpdateCount()

getMoreResults

public boolean getMoreResults()
                       throws java.sql.SQLException

Specified by:

getMoreResults in interface java.sql.Statement

Specified by:

getMoreResults in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getMoreResults()

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException

Specified by:

setFetchDirection in interface java.sql.Statement

Specified by:

setFetchDirection in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setFetchDirection(int)

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Specified by:

getFetchDirection in interface java.sql.Statement

Specified by:

getFetchDirection in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getFetchDirection()

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException

Specified by:

setFetchSize in interface java.sql.Statement

Specified by:

setFetchSize in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.setFetchSize(int)

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Specified by:

getFetchSize in interface java.sql.Statement

Specified by:

getFetchSize in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getFetchSize()

getResultSetConcurrency

public int getResultSetConcurrency()
                            throws java.sql.SQLException

Specified by:

getResultSetConcurrency in interface java.sql.Statement

Specified by:

getResultSetConcurrency in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getResultSetConcurrency()

getResultSetType

public int getResultSetType()
                     throws java.sql.SQLException

Specified by:

getResultSetType in interface java.sql.Statement

Specified by:

getResultSetType in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getResultSetType()

addBatch

public void addBatch(java.lang.String _sql)
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.Statement

Specified by:

addBatch in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.addBatch(java.lang.String)

clearBatch

public void clearBatch()
                throws java.sql.SQLException

Specified by:

clearBatch in interface java.sql.Statement

Specified by:

clearBatch in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.clearBatch()

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException

Specified by:

executeBatch in interface java.sql.Statement

Specified by:

executeBatch in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.executeBatch()

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Specified by:

getConnection in interface java.sql.Statement

Specified by:

getConnection in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getConnection()

getMoreResults

public boolean getMoreResults(int current)
                       throws java.sql.SQLException

Specified by:

getMoreResults in interface java.sql.Statement

Specified by:

getMoreResults in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getMoreResults(int)

getGeneratedKeys

public java.sql.ResultSet getGeneratedKeys()
                                    throws java.sql.SQLException

Specified by:

getGeneratedKeys in interface java.sql.Statement

Specified by:

getGeneratedKeys in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getGeneratedKeys()

executeUpdate

public int executeUpdate(java.lang.String _sql,
                         int autoGeneratedKeys)

Specified by:

executeUpdate in interface java.sql.Statement

Specified by:

executeUpdate in class ExtStatement

See Also:

Statement.executeUpdate(java.lang.String, int)

executeUpdate

public int executeUpdate(java.lang.String _sql,
                         int[] columnIndexes)

Specified by:

executeUpdate in interface java.sql.Statement

Specified by:

executeUpdate in class ExtStatement

See Also:

Statement.executeUpdate(java.lang.String, int[])

executeUpdate

public int executeUpdate(java.lang.String _sql,
                         java.lang.String[] columnNames)

Specified by:

executeUpdate in interface java.sql.Statement

Specified by:

executeUpdate in class ExtStatement

See Also:

Statement.executeUpdate(java.lang.String, java.lang.String[])

execute

public boolean execute(java.lang.String _sql,
                       int autoGeneratedKeys)

Specified by:

execute in interface java.sql.Statement

Specified by:

execute in class ExtStatement

See Also:

Statement.execute(java.lang.String, int)

execute

public boolean execute(java.lang.String _sql,
                       int[] columnIndexes)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Specified by:

execute in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.execute(java.lang.String, int[])

execute

public boolean execute(java.lang.String _sql,
                       java.lang.String[] columnNames)

Specified by:

execute in interface java.sql.Statement

Specified by:

execute in class ExtStatement

See Also:

Statement.execute(java.lang.String, java.lang.String[])

getResultSetHoldability

public int getResultSetHoldability()
                            throws java.sql.SQLException

Specified by:

getResultSetHoldability in interface java.sql.Statement

Specified by:

getResultSetHoldability in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.getResultSetHoldability()

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Statement

Specified by:

close in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.close()

execute

public boolean execute(java.lang.String _sql)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Specified by:

execute in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.execute(java.lang.String)

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String _sql)
                                throws java.sql.SQLException

Specified by:

executeQuery in interface java.sql.Statement

Specified by:

executeQuery in class ExtStatement

Throws:

java.sql.SQLException

See Also:

Statement.executeQuery(java.lang.String)

getRealResultSet

public java.sql.ResultSet getRealResultSet(java.lang.String _sql)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

submit

protected void submit()
               throws java.sql.SQLException

Throws:

java.sql.SQLException