All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class org.xmlmiddleware.db.SPPreparedStatement

java.lang.Object
   |
   +----org.xmlmiddleware.db.SPPreparedStatement

public class SPPreparedStatement
extends Object
implements PreparedStatement, Statement, SPStatementEventSource
Wraps a pooled statement.

NOTE: To compile against JDBC 2.0, uncomment the methods used by the 2.0 version of PreparedStatement and Statement.

Version:
2.0
Author:
Sean Walter, 2001, Ronald Bourret, 2001

Method Index

 o addBatch(String)
 o addStatementEventListener(SPStatementEventListener)
 o cancel()
 o clearBatch()
 o clearParameters()
 o clearWarnings()
 o close()
 o execute()
 o execute(String)
 o executeBatch()
 o executeQuery()
 o executeQuery(String)
 o executeUpdate()
 o executeUpdate(String)
 o getConnection()
 o getFetchDirection()
 o getFetchSize()
 o getMaxFieldSize()
 o getMaxRows()
 o getMoreResults()
 o getQueryTimeout()
 o getResultSet()
 o getResultSetConcurrency()
 o getResultSetType()
 o getUnderlyingStatement()
 o getUpdateCount()
 o getWarnings()
 o removeStatementEventListener(SPStatementEventListener)
 o setAsciiStream(int, InputStream, int)
 o setBigDecimal(int, BigDecimal)
 o setBinaryStream(int, InputStream, int)
 o setBoolean(int, boolean)
 o setByte(int, byte)
 o setBytes(int, byte[])
 o setCursorName(String)
 o setDate(int, Date)
 o setDouble(int, double)
 o setEscapeProcessing(boolean)
 o setFetchDirection(int)
 o setFetchSize(int)
 o setFloat(int, float)
 o setInt(int, int)
 o setLong(int, long)
 o setMaxFieldSize(int)
 o setMaxRows(int)
 o setNull(int, int)
 o setObject(int, Object)
 o setObject(int, Object, int)
 o setObject(int, Object, int, int)
 o setQueryTimeout(int)
 o setShort(int, short)
 o setString(int, String)
 o setTime(int, Time)
 o setTimestamp(int, Timestamp)
 o setUnicodeStream(int, InputStream, int)

Methods

 o executeQuery
 public ResultSet executeQuery() throws SQLException
 o executeUpdate
 public int executeUpdate() throws SQLException
 o setNull
 public void setNull(int parameterIndex,
                     int sqlType) throws SQLException
 o setBoolean
 public void setBoolean(int parameterIndex,
                        boolean x) throws SQLException
 o setByte
 public void setByte(int parameterIndex,
                     byte x) throws SQLException
 o setShort
 public void setShort(int parameterIndex,
                      short x) throws SQLException
 o setInt
 public void setInt(int parameterIndex,
                    int x) throws SQLException
 o setLong
 public void setLong(int parameterIndex,
                     long x) throws SQLException
 o setFloat
 public void setFloat(int parameterIndex,
                      float x) throws SQLException
 o setDouble
 public void setDouble(int parameterIndex,
                       double x) throws SQLException
 o setBigDecimal
 public void setBigDecimal(int parameterIndex,
                           BigDecimal x) throws SQLException
 o setString
 public void setString(int parameterIndex,
                       String x) throws SQLException
 o setBytes
 public void setBytes(int parameterIndex,
                      byte x[]) throws SQLException
 o setDate
 public void setDate(int parameterIndex,
                     Date x) throws SQLException
 o setTime
 public void setTime(int parameterIndex,
                     Time x) throws SQLException
 o setTimestamp
 public void setTimestamp(int parameterIndex,
                          Timestamp x) throws SQLException
 o setAsciiStream
 public void setAsciiStream(int parameterIndex,
                            InputStream x,
                            int length) throws SQLException
 o setUnicodeStream
 public void setUnicodeStream(int parameterIndex,
                              InputStream x,
                              int length) throws SQLException
 o setBinaryStream
 public void setBinaryStream(int parameterIndex,
                             InputStream x,
                             int length) throws SQLException
 o clearParameters
 public void clearParameters() throws SQLException
 o setObject
 public void setObject(int parameterIndex,
                       Object x,
                       int targetSqlType,
                       int scale) throws SQLException
 o setObject
 public void setObject(int parameterIndex,
                       Object x,
                       int targetSqlType) throws SQLException
 o setObject
 public void setObject(int parameterIndex,
                       Object x) throws SQLException
 o execute
 public boolean execute() throws SQLException
 o executeQuery
 public ResultSet executeQuery(String sql) throws SQLException
 o executeUpdate
 public int executeUpdate(String sql) throws SQLException
 o close
 public void close() throws SQLException
 o getMaxFieldSize
 public int getMaxFieldSize() throws SQLException
 o setMaxFieldSize
 public void setMaxFieldSize(int max) throws SQLException
 o getMaxRows
 public int getMaxRows() throws SQLException
 o setMaxRows
 public void setMaxRows(int max) throws SQLException
 o setEscapeProcessing
 public void setEscapeProcessing(boolean enable) throws SQLException
 o getQueryTimeout
 public int getQueryTimeout() throws SQLException
 o setQueryTimeout
 public void setQueryTimeout(int seconds) throws SQLException
 o cancel
 public void cancel() throws SQLException
 o getWarnings
 public SQLWarning getWarnings() throws SQLException
 o clearWarnings
 public void clearWarnings() throws SQLException
 o setCursorName
 public void setCursorName(String name) throws SQLException
 o execute
 public boolean execute(String sql) throws SQLException
 o getResultSet
 public ResultSet getResultSet() throws SQLException
 o getUpdateCount
 public int getUpdateCount() throws SQLException
 o getMoreResults
 public boolean getMoreResults() throws SQLException
 o setFetchDirection
 public void setFetchDirection(int direction) throws SQLException
 o getFetchDirection
 public int getFetchDirection() throws SQLException
 o setFetchSize
 public void setFetchSize(int rows) throws SQLException
 o getFetchSize
 public int getFetchSize() throws SQLException
 o getResultSetConcurrency
 public int getResultSetConcurrency() throws SQLException
 o getResultSetType
 public int getResultSetType() throws SQLException
 o addBatch
 public void addBatch(String sql) throws SQLException
 o clearBatch
 public void clearBatch() throws SQLException
 o executeBatch
 public int[] executeBatch() throws SQLException
 o getConnection
 public Connection getConnection() throws SQLException
 o addStatementEventListener
 public void addStatementEventListener(SPStatementEventListener listener)
 o removeStatementEventListener
 public void removeStatementEventListener(SPStatementEventListener listener)
 o getUnderlyingStatement
 public PreparedStatement getUnderlyingStatement()

All Packages  Class Hierarchy  This Package  Previous  Next  Index