Package 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
- All Implemented Interfaces:
AutoCloseable
,PreparedStatement
,Statement
,Wrapper
Use this class for creating wrapper classes around the
PreparedStatement
interface. The subclass can override the
methods that need to show a different behavior than the wrapped object.- Since:
- 3.0
- See Also:
-
Field Summary
Fields inherited from class com.spotfire.ws.im.ds.sql.StatementWrapper
m_stmt
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
ConstructorDescriptionCreates a newPreparedStatementWrapper
instance. -
Method Summary
Modifier and TypeMethodDescriptionvoid
addBatch()
void
boolean
execute()
int
void
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 parameterIndex, InputStream inputStream) void
setBlob
(int parameterIndex, InputStream inputStream, long length) void
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
void
void
void
void
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
void
void
void
setNString
(int parameterIndex, String value) void
setNull
(int idx, int sqlType) void
void
void
void
void
void
void
setShort
(int idx, short x) void
void
void
void
void
setTimestamp
(int idx, Timestamp x) void
setTimestamp
(int idx, Timestamp x, Calendar cal) void
setUnicodeStream
(int idx, InputStream x, int length) Deprecated.deprecatedvoid
Methods inherited from class com.spotfire.ws.im.ds.sql.StatementWrapper
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, 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, isCloseOnCompletion, 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
Methods inherited from interface java.sql.PreparedStatement
executeLargeUpdate, setObject, setObject
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
Constructor Details
-
PreparedStatementWrapper
Creates a newPreparedStatementWrapper
instance.- Parameters:
stmt
- thePreparedStatement
to be wrapped- Since:
- 3.0
-
-
Method Details
-
executeQuery
- Specified by:
executeQuery
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
executeUpdate
- Specified by:
executeUpdate
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNull
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBoolean
- Specified by:
setBoolean
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setByte
- Specified by:
setByte
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setShort
- Specified by:
setShort
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setInt
- Specified by:
setInt
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setLong
- Specified by:
setLong
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setFloat
- Specified by:
setFloat
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setDouble
- Specified by:
setDouble
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBigDecimal
- Specified by:
setBigDecimal
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setString
- Specified by:
setString
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBytes
- Specified by:
setBytes
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setDate
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setTime
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setTimestamp
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setAsciiStream
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setUnicodeStream
Deprecated.deprecated- Specified by:
setUnicodeStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBinaryStream
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
clearParameters
- Specified by:
clearParameters
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setObject
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setObject
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setObject
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
execute
- Specified by:
execute
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
addBatch
- Specified by:
addBatch
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setCharacterStream
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setRef
- Specified by:
setRef
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBlob
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setClob
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setArray
- Specified by:
setArray
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
getMetaData
- Specified by:
getMetaData
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setDate
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setTime
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setTimestamp
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNull
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setURL
- Specified by:
setURL
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
getParameterMetaData
- Specified by:
getParameterMetaData
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setAsciiStream
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setAsciiStream
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBinaryStream
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBinaryStream
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBlob
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setBlob
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setCharacterStream
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setCharacterStream
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setClob
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setClob
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNClob
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNClob
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNClob
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNString
- Specified by:
setNString
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNCharacterStream
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setNCharacterStream
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setRowId
- Specified by:
setRowId
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-
setSQLXML
- Specified by:
setSQLXML
in interfacePreparedStatement
- Throws:
SQLException
- Since:
- 3.0
-