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