com.ibm.jtopenlite.database.jdbc
Class JDBCPreparedStatement
- java.lang.Object
-
- com.ibm.jtopenlite.database.jdbc.JDBCStatement
-
- com.ibm.jtopenlite.database.jdbc.JDBCPreparedStatement
-
- All Implemented Interfaces:
- DatabaseSQLCommunicationsAreaCallback, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper
- Direct Known Subclasses:
- JDBCCallableStatement
public class JDBCPreparedStatement extends JDBCStatement implements java.sql.PreparedStatement
-
-
Field Summary
-
Fields inherited from class com.ibm.jtopenlite.database.jdbc.JDBCStatement
TYPE_BLOCKED_INSERT, TYPE_CALL, TYPE_COMMIT, TYPE_CONNECT, TYPE_INSERT_UPDATE_DELETE, TYPE_ROLLBACK, TYPE_SELECT, TYPE_UNKNOWN
-
-
Constructor Summary
Constructors Constructor and Description JDBCPreparedStatement(JDBCConnection conn, java.lang.String sql, java.util.Calendar calendar, java.lang.String statementName, java.lang.String cursorName, int rpbID)
-
Method Summary
Methods Modifier and Type Method and Description void
addBatch()
Not implemented.void
clearParameters()
void
close()
boolean
execute()
java.sql.ResultSet
executeQuery()
int
executeUpdate()
java.sql.ResultSetMetaData
getMetaData()
java.sql.ParameterMetaData
getParameterMetaData()
void
setArray(int parameterIndex, java.sql.Array x)
Not implemented.void
setAsciiStream(int parameterIndex, java.io.InputStream arg1)
void
setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
void
setAsciiStream(int parameterIndex, java.io.InputStream arg1, long arg2)
void
setBigDecimal(int parameterIndex, java.math.BigDecimal x)
void
setBinaryStream(int parameterIndex, java.io.InputStream arg1)
void
setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
void
setBinaryStream(int parameterIndex, java.io.InputStream arg1, long arg2)
void
setBlob(int parameterIndex, java.sql.Blob x)
Not implemented.void
setBlob(int parameterIndex, java.io.InputStream arg1)
void
setBlob(int parameterIndex, java.io.InputStream arg1, long arg2)
void
setBoolean(int parameterIndex, boolean x)
void
setByte(int parameterIndex, byte x)
void
setBytes(int parameterIndex, byte[] x)
void
setCharacterStream(int parameterIndex, java.io.Reader arg1)
void
setCharacterStream(int parameterIndex, java.io.Reader x, int length)
void
setCharacterStream(int parameterIndex, java.io.Reader arg1, long arg2)
void
setClob(int parameterIndex, java.sql.Clob x)
Not implemented.void
setClob(int parameterIndex, java.io.Reader arg1)
void
setClob(int parameterIndex, java.io.Reader arg1, long arg2)
void
setDate(int parameterIndex, java.sql.Date x)
void
setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)
void
setDouble(int parameterIndex, double x)
void
setFloat(int parameterIndex, float x)
void
setInt(int parameterIndex, int x)
void
setLong(int parameterIndex, long x)
void
setNCharacterStream(int parameterIndex, java.io.Reader arg1)
void
setNCharacterStream(int parameterIndex, java.io.Reader arg1, long arg2)
void
setNClob(int parameterIndex, java.io.Reader arg1)
void
setNClob(int parameterIndex, java.io.Reader arg1, long arg2)
void
setNString(int parameterIndex, java.lang.String arg1)
void
setNull(int parameterIndex, int sqlType)
void
setNull(int parameterIndex, int sqlType, java.lang.String typeName)
void
setObject(int parameterIndex, java.lang.Object x)
void
setObject(int parameterIndex, java.lang.Object x, int targetSQLType)
Not implemented.void
setObject(int parameterIndex, java.lang.Object x, int targetSQLType, int scale)
Not implemented.void
setRef(int parameterIndex, java.sql.Ref x)
Not implemented.void
setShort(int parameterIndex, short x)
void
setString(int parameterIndex, java.lang.String x)
void
setTime(int parameterIndex, java.sql.Time x)
void
setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
void
setTimestamp(int parameterIndex, java.sql.Timestamp x)
void
setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
void
setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
void
setURL(int parameterIndex, java.net.URL x)
-
Methods inherited from class com.ibm.jtopenlite.database.jdbc.JDBCStatement
addBatch, cancel, clearBatch, clearWarnings, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getStatementType, getUpdateCount, getWarnings, isClosed, isPoolable, newSQLCommunicationsAreaData, setCatalog, setCursorName, setCursorNameInternal, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
-
-
-
Constructor Detail
-
JDBCPreparedStatement
public JDBCPreparedStatement(JDBCConnection conn, java.lang.String sql, java.util.Calendar calendar, java.lang.String statementName, java.lang.String cursorName, int rpbID) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-
Method Detail
-
addBatch
public void addBatch() throws java.sql.SQLException
Not implemented.- Specified by:
addBatch
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
clearParameters
public void clearParameters() throws java.sql.SQLException
- Specified by:
clearParameters
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute() throws java.sql.SQLException
- Specified by:
execute
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
executeQuery
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
- Specified by:
executeQuery
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
close
public void close() throws java.sql.SQLException
- Specified by:
close
in interfacejava.sql.Statement
- Overrides:
close
in classJDBCStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate() throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
- Specified by:
getMetaData
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
getParameterMetaData
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
- Specified by:
getParameterMetaData
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setArray
public void setArray(int parameterIndex, java.sql.Array x) throws java.sql.SQLException
Not implemented.- Specified by:
setArray
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
setBigDecimal
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
Not implemented.- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
- Specified by:
setBoolean
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
- Specified by:
setByte
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
- Specified by:
setBytes
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader x, int length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
Not implemented.- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
- Specified by:
setDouble
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
- Specified by:
setFloat
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
- Specified by:
setInt
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
- Specified by:
setLong
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSQLType) throws java.sql.SQLException
Not implemented.- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSQLType, int scale) throws java.sql.SQLException
Not implemented.- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setRef
public void setRef(int parameterIndex, java.sql.Ref x) throws java.sql.SQLException
Not implemented.- Specified by:
setRef
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
- Specified by:
setShort
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
- Specified by:
setString
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setUnicodeStream
public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setUnicodeStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(int parameterIndex, java.net.URL x) throws java.sql.SQLException
- Specified by:
setURL
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream arg1) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream arg1, long arg2) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream arg1) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream arg1, long arg2) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream arg1) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream arg1, long arg2) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader arg1) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader arg1, long arg2) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader arg1) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader arg1, long arg2) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, java.io.Reader arg1) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, java.io.Reader arg1, long arg2) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(int parameterIndex, java.io.Reader arg1) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(int parameterIndex, java.io.Reader arg1, long arg2) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-arg2
-- Throws:
java.sql.SQLException
-
setNString
public void setNString(int parameterIndex, java.lang.String arg1) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
-arg1
-- Throws:
java.sql.SQLException
-
-