com.spotfire.ws.im.ds.sql
Class PreparedStatementWrapper

java.lang.Object
  com.spotfire.ws.im.ds.sql.StatementWrapper
      com.spotfire.ws.im.ds.sql.PreparedStatementWrapper

public class PreparedStatementWrapper
extends StatementWrapper

Use this class for creating wrapper classes around the PreparedStatement interface. The subclass can override the methods that need to show a different behaviour than the wrapped object.

Since:

7.2

See Also:

SQLRuntime.prepareUpdate(java.lang.String), SQLRuntime.prepareQuery(java.lang.String)

Field Summary

Fields inherited from class com.spotfire.ws.im.ds.sql.StatementWrapper

m_stmt

Constructor Summary

PreparedStatementWrapper(PreparedStatement stmt)
Creates a new PreparedStatementWrapper instance.

Method Summary

void	addBatch()
void	clearParameters()
boolean	execute()
ResultSet	executeQuery()
int	executeUpdate()
ResultSetMetaData	getMetaData()
ParameterMetaData	getParameterMetaData()
void	setArray(int idx, Array x)
void	setAsciiStream(int parameterIndex, InputStream x)
void	setAsciiStream(int idx, InputStream x, int length)
void	setAsciiStream(int parameterIndex, InputStream x, long length)
void	setBigDecimal(int idx, BigDecimal x)
void	setBinaryStream(int parameterIndex, InputStream x)
void	setBinaryStream(int idx, InputStream x, int length)
void	setBinaryStream(int parameterIndex, InputStream x, long length)
void	setBlob(int idx, Blob x)
void	setBlob(int parameterIndex, InputStream inputStream)
void	setBlob(int parameterIndex, InputStream inputStream, long length)
void	setBoolean(int idx, boolean x)
void	setByte(int idx, byte x)
void	setBytes(int idx, byte[] x)
void	setCharacterStream(int parameterIndex, Reader x)
void	setCharacterStream(int idx, Reader reader, int length)
void	setCharacterStream(int parameterIndex, Reader x, long length)
void	setClob(int idx, Clob x)
void	setClob(int parameterIndex, Reader reader)
void	setClob(int parameterIndex, Reader reader, long length)
void	setDate(int idx, Date x)
void	setDate(int idx, Date x, Calendar cal)
void	setDouble(int idx, double x)
void	setFloat(int idx, float x)
void	setInt(int idx, int x)
void	setLong(int idx, long x)
void	setNCharacterStream(int parameterIndex, Reader x)
void	setNCharacterStream(int parameterIndex, Reader x, long length)
void	setNClob(int parameterIndex, NClob value)
void	setNClob(int parameterIndex, Reader reader)
void	setNClob(int parameterIndex, Reader reader, long length)
void	setNString(int parameterIndex, String value)
void	setNull(int idx, int sqlType)
void	setNull(int idx, int sqlType, String typeName)
void	setObject(int idx, Object x)
void	setObject(int idx, Object x, int targetSqlType)
void	setObject(int idx, Object x, int targetSqlType, int scale)
void	setRef(int idx, Ref x)
void	setRowId(int parameterIndex, RowId x)
void	setShort(int idx, short x)
void	setSQLXML(int parameterIndex, SQLXML xmlObject)
void	setString(int idx, String x)
void	setTime(int idx, Time x)
void	setTime(int idx, Time x, Calendar cal)
void	setTimestamp(int idx, Timestamp x)
void	setTimestamp(int idx, Timestamp x, Calendar cal)
void	setUnicodeStream(int idx, InputStream x, int length)
void	setURL(int parameterIndex, URL x)

Methods inherited from class com.spotfire.ws.im.ds.sql.StatementWrapper

addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

Methods inherited from class java.lang.Object

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

Constructor Detail

PreparedStatementWrapper

public PreparedStatementWrapper(PreparedStatement stmt)

Creates a new PreparedStatementWrapper instance.

Parameters:

stmt - the PreparedStatement to be wrapped

Method Detail

executeQuery

public ResultSet executeQuery()

executeUpdate

public int executeUpdate()

setNull

public void setNull(int idx,
                    int sqlType)

setBoolean

public void setBoolean(int idx,
                       boolean x)

setByte

public void setByte(int idx,
                    byte x)

setShort

public void setShort(int idx,
                     short x)

setInt

public void setInt(int idx,
                   int x)

setLong

public void setLong(int idx,
                    long x)

setFloat

public void setFloat(int idx,
                     float x)

setDouble

public void setDouble(int idx,
                      double x)

setBigDecimal

public void setBigDecimal(int idx,
                          BigDecimal x)

setString

public void setString(int idx,
                      String x)

setBytes

public void setBytes(int idx,
                     byte[] x)

setDate

public void setDate(int idx,
                    Date x)

setTime

public void setTime(int idx,
                    Time x)

setTimestamp

public void setTimestamp(int idx,
                         Timestamp x)

setAsciiStream

public void setAsciiStream(int idx,
                           InputStream x,
                           int length)

setUnicodeStream

public void setUnicodeStream(int idx,
                             InputStream x,
                             int length)

setBinaryStream

public void setBinaryStream(int idx,
                            InputStream x,
                            int length)

clearParameters

public void clearParameters()

setObject

public void setObject(int idx,
                      Object x,
                      int targetSqlType,
                      int scale)

setObject

public void setObject(int idx,
                      Object x,
                      int targetSqlType)

setObject

public void setObject(int idx,
                      Object x)

execute

public boolean execute()

addBatch

public void addBatch()

setCharacterStream

public void setCharacterStream(int idx,
                               Reader reader,
                               int length)

setRef

public void setRef(int idx,
                   Ref x)

setBlob

public void setBlob(int idx,
                    Blob x)

setClob

public void setClob(int idx,
                    Clob x)

setArray

public void setArray(int idx,
                     Array x)

getMetaData

public ResultSetMetaData getMetaData()

setDate

public void setDate(int idx,
                    Date x,
                    Calendar cal)

setTime

public void setTime(int idx,
                    Time x,
                    Calendar cal)

setTimestamp

public void setTimestamp(int idx,
                         Timestamp x,
                         Calendar cal)

setNull

public void setNull(int idx,
                    int sqlType,
                    String typeName)

setURL

public void setURL(int parameterIndex,
                   URL x)

getParameterMetaData

public ParameterMetaData getParameterMetaData()

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x)

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           long length)

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x)

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x,
                            long length)

setBlob

public void setBlob(int parameterIndex,
                    InputStream inputStream)

setBlob

public void setBlob(int parameterIndex,
                    InputStream inputStream,
                    long length)

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader x)

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader x,
                               long length)

setClob

public void setClob(int parameterIndex,
                    Reader reader)

setClob

public void setClob(int parameterIndex,
                    Reader reader,
                    long length)

setNClob

public void setNClob(int parameterIndex,
                     NClob value)

setNClob

public void setNClob(int parameterIndex,
                     Reader reader)

setNClob

public void setNClob(int parameterIndex,
                     Reader reader,
                     long length)

setNString

public void setNString(int parameterIndex,
                       String value)

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                Reader x)

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                Reader x,
                                long length)

setRowId

public void setRowId(int parameterIndex,
                     RowId x)

setSQLXML

public void setSQLXML(int parameterIndex,
                      SQLXML xmlObject)