public class JDBCCallableStatement extends JDBCPreparedStatement implements CallableStatement
TYPE_BLOCKED_INSERT, TYPE_CALL, TYPE_COMMIT, TYPE_CONNECT, TYPE_INSERT_UPDATE_DELETE, TYPE_ROLLBACK, TYPE_SELECT, TYPE_UNKNOWNCLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO| Constructor and Description |
|---|
JDBCCallableStatement(JDBCConnection conn,
String sql,
Calendar calendar,
String statementName,
String cursorName,
int rpbID) |
| Modifier and Type | Method and Description |
|---|---|
Array |
getArray(int i) |
Array |
getArray(String parameterName) |
BigDecimal |
getBigDecimal(int parameterIndex) |
BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
BigDecimal |
getBigDecimal(String parameterName) |
Blob |
getBlob(int i) |
Blob |
getBlob(String parameterName) |
boolean |
getBoolean(int parameterIndex) |
boolean |
getBoolean(String parameterName) |
byte |
getByte(int parameterIndex) |
byte |
getByte(String parameterName) |
byte[] |
getBytes(int parameterIndex) |
byte[] |
getBytes(String parameterName) |
Reader |
getCharacterStream(int parm) |
Reader |
getCharacterStream(String parm) |
Clob |
getClob(int i) |
Clob |
getClob(String parameterName) |
Date |
getDate(int parameterIndex) |
Date |
getDate(int parameterIndex,
Calendar cal) |
Date |
getDate(String parameterName) |
Date |
getDate(String parameterName,
Calendar cal) |
double |
getDouble(int parameterIndex) |
double |
getDouble(String parameterName) |
float |
getFloat(int parameterIndex) |
float |
getFloat(String parameterName) |
int |
getInt(int parameterIndex) |
int |
getInt(String parameterName) |
long |
getLong(int parameterIndex) |
long |
getLong(String parameterName) |
Reader |
getNCharacterStream(int parm) |
Reader |
getNCharacterStream(String parm) |
String |
getNString(int parm) |
String |
getNString(String parm) |
Object |
getObject(int parameterIndex) |
Object |
getObject(int i,
Map<String,Class<?>> map) |
Object |
getObject(String parameterName) |
Object |
getObject(String parameterName,
Map<String,Class<?>> map) |
Ref |
getRef(int i) |
Ref |
getRef(String parameterName) |
short |
getShort(int parameterIndex) |
short |
getShort(String parameterName) |
String |
getString(int parameterIndex) |
String |
getString(String parameterName) |
Time |
getTime(int parameterIndex) |
Time |
getTime(int parameterIndex,
Calendar cal) |
Time |
getTime(String parameterName) |
Time |
getTime(String parameterName,
Calendar cal) |
Timestamp |
getTimestamp(int parameterIndex) |
Timestamp |
getTimestamp(int parameterIndex,
Calendar cal) |
Timestamp |
getTimestamp(String parameterName) |
Timestamp |
getTimestamp(String parameterName,
Calendar cal) |
URL |
getURL(int parameterIndex) |
URL |
getURL(String parameterName) |
void |
registerOutParameter(int parameterIndex,
int sqlType) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
void |
registerOutParameter(int paramIndex,
int sqlType,
String typeName) |
void |
registerOutParameter(String parameterName,
int sqlType) |
void |
registerOutParameter(String parameterName,
int sqlType,
int scale) |
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName) |
void |
setAsciiStream(String parm,
InputStream arg1) |
void |
setAsciiStream(String parameterName,
InputStream x,
int length) |
void |
setAsciiStream(String parm,
InputStream arg1,
long arg2) |
void |
setBigDecimal(String parameterName,
BigDecimal x) |
void |
setBinaryStream(String parm,
InputStream arg1) |
void |
setBinaryStream(String parameterName,
InputStream x,
int length) |
void |
setBinaryStream(String parm,
InputStream arg1,
long arg2) |
void |
setBlob(String parm,
Blob arg1) |
void |
setBlob(String parm,
InputStream arg1) |
void |
setBlob(String parm,
InputStream arg1,
long arg2) |
void |
setBoolean(String parameterName,
boolean x) |
void |
setByte(String parameterName,
byte x) |
void |
setBytes(String parameterName,
byte[] x) |
void |
setCharacterStream(String parm,
Reader arg1) |
void |
setCharacterStream(String parameterName,
Reader reader,
int length) |
void |
setCharacterStream(String parm,
Reader arg1,
long arg2) |
void |
setClob(String parm,
Clob arg1) |
void |
setClob(String parm,
Reader arg1) |
void |
setClob(String parm,
Reader arg1,
long arg2) |
void |
setDate(String parameterName,
Date x) |
void |
setDate(String parameterName,
Date x,
Calendar cal) |
void |
setDouble(String parameterName,
double x) |
void |
setFloat(String parameterName,
float x) |
void |
setInt(String parameterName,
int x) |
void |
setLong(String parameterName,
long x) |
void |
setNCharacterStream(String parm,
Reader arg1) |
void |
setNCharacterStream(String parm,
Reader arg1,
long arg2) |
void |
setNClob(String parm,
Reader arg1) |
void |
setNClob(String parm,
Reader arg1,
long arg2) |
void |
setNString(String parm,
String arg1) |
void |
setNull(String parameterName,
int sqlType) |
void |
setNull(String parameterName,
int sqlType,
String typeName) |
void |
setObject(String parameterName,
Object x) |
void |
setObject(String parameterName,
Object x,
int targetSqlType) |
void |
setObject(String parameterName,
Object x,
int targetSqlType,
int scale) |
void |
setShort(String parameterName,
short x) |
void |
setString(String parameterName,
String x) |
void |
setTime(String parameterName,
Time x) |
void |
setTime(String parameterName,
Time x,
Calendar cal) |
void |
setTimestamp(String parameterName,
Timestamp x) |
void |
setTimestamp(String parameterName,
Timestamp x,
Calendar cal) |
void |
setURL(String parameterName,
URL val) |
boolean |
wasNull() |
addBatch, clearParameters, close, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLaddBatch, 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, setQueryTimeoutclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitgetNClob, getNClob, getRowId, getRowId, getSQLXML, getSQLXML, setNClob, setRowId, setSQLXMLaddBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLaddBatch, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutisWrapperFor, unwrappublic JDBCCallableStatement(JDBCConnection conn, String sql, Calendar calendar, String statementName, String cursorName, int rpbID) throws SQLException
SQLExceptionpublic Array getArray(int i) throws SQLException
getArray in interface CallableStatementSQLExceptionpublic Array getArray(String parameterName) throws SQLException
getArray in interface CallableStatementSQLExceptionpublic BigDecimal getBigDecimal(int parameterIndex) throws SQLException
getBigDecimal in interface CallableStatementSQLExceptionpublic BigDecimal getBigDecimal(String parameterName) throws SQLException
getBigDecimal in interface CallableStatementSQLExceptionpublic BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
getBigDecimal in interface CallableStatementSQLExceptionpublic Blob getBlob(int i) throws SQLException
getBlob in interface CallableStatementSQLExceptionpublic Blob getBlob(String parameterName) throws SQLException
getBlob in interface CallableStatementSQLExceptionpublic boolean getBoolean(int parameterIndex)
throws SQLException
getBoolean in interface CallableStatementSQLExceptionpublic boolean getBoolean(String parameterName) throws SQLException
getBoolean in interface CallableStatementSQLExceptionpublic byte getByte(int parameterIndex)
throws SQLException
getByte in interface CallableStatementSQLExceptionpublic byte getByte(String parameterName) throws SQLException
getByte in interface CallableStatementSQLExceptionpublic byte[] getBytes(int parameterIndex)
throws SQLException
getBytes in interface CallableStatementSQLExceptionpublic byte[] getBytes(String parameterName) throws SQLException
getBytes in interface CallableStatementSQLExceptionpublic Clob getClob(int i) throws SQLException
getClob in interface CallableStatementSQLExceptionpublic Clob getClob(String parameterName) throws SQLException
getClob in interface CallableStatementSQLExceptionpublic Date getDate(int parameterIndex) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Date getDate(String parameterName) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Date getDate(int parameterIndex, Calendar cal) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Date getDate(String parameterName, Calendar cal) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic double getDouble(int parameterIndex)
throws SQLException
getDouble in interface CallableStatementSQLExceptionpublic double getDouble(String parameterName) throws SQLException
getDouble in interface CallableStatementSQLExceptionpublic float getFloat(int parameterIndex)
throws SQLException
getFloat in interface CallableStatementSQLExceptionpublic float getFloat(String parameterName) throws SQLException
getFloat in interface CallableStatementSQLExceptionpublic int getInt(int parameterIndex)
throws SQLException
getInt in interface CallableStatementSQLExceptionpublic int getInt(String parameterName) throws SQLException
getInt in interface CallableStatementSQLExceptionpublic long getLong(int parameterIndex)
throws SQLException
getLong in interface CallableStatementSQLExceptionpublic long getLong(String parameterName) throws SQLException
getLong in interface CallableStatementSQLExceptionpublic Object getObject(int parameterIndex) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic Object getObject(String parameterName) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic Object getObject(int i, Map<String,Class<?>> map) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic Ref getRef(int i) throws SQLException
getRef in interface CallableStatementSQLExceptionpublic Ref getRef(String parameterName) throws SQLException
getRef in interface CallableStatementSQLExceptionpublic short getShort(int parameterIndex)
throws SQLException
getShort in interface CallableStatementSQLExceptionpublic short getShort(String parameterName) throws SQLException
getShort in interface CallableStatementSQLExceptionpublic String getString(int parameterIndex) throws SQLException
getString in interface CallableStatementSQLExceptionpublic String getString(String parameterName) throws SQLException
getString in interface CallableStatementSQLExceptionpublic Time getTime(int parameterIndex) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Time getTime(String parameterName) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Time getTime(int parameterIndex, Calendar cal) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Time getTime(String parameterName, Calendar cal) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(int parameterIndex) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(String parameterName) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic URL getURL(int parameterIndex) throws SQLException
getURL in interface CallableStatementSQLExceptionpublic URL getURL(String parameterName) throws SQLException
getURL in interface CallableStatementSQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType)
throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(String parameterName, int sqlType) throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(int paramIndex,
int sqlType,
String typeName)
throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
setAsciiStream in interface CallableStatementSQLExceptionpublic void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
setBigDecimal in interface CallableStatementSQLExceptionpublic void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
setBinaryStream in interface CallableStatementSQLExceptionpublic void setBoolean(String parameterName, boolean x) throws SQLException
setBoolean in interface CallableStatementSQLExceptionpublic void setByte(String parameterName, byte x) throws SQLException
setByte in interface CallableStatementSQLExceptionpublic void setBytes(String parameterName, byte[] x) throws SQLException
setBytes in interface CallableStatementSQLExceptionpublic void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
setCharacterStream in interface CallableStatementSQLExceptionpublic void setDate(String parameterName, Date x) throws SQLException
setDate in interface CallableStatementSQLExceptionpublic void setDate(String parameterName, Date x, Calendar cal) throws SQLException
setDate in interface CallableStatementSQLExceptionpublic void setDouble(String parameterName, double x) throws SQLException
setDouble in interface CallableStatementSQLExceptionpublic void setFloat(String parameterName, float x) throws SQLException
setFloat in interface CallableStatementSQLExceptionpublic void setInt(String parameterName, int x) throws SQLException
setInt in interface CallableStatementSQLExceptionpublic void setLong(String parameterName, long x) throws SQLException
setLong in interface CallableStatementSQLExceptionpublic void setNull(String parameterName, int sqlType) throws SQLException
setNull in interface CallableStatementSQLExceptionpublic void setNull(String parameterName, int sqlType, String typeName) throws SQLException
setNull in interface CallableStatementSQLExceptionpublic void setObject(String parameterName, Object x) throws SQLException
setObject in interface CallableStatementSQLExceptionpublic void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObject in interface CallableStatementSQLExceptionpublic void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
setObject in interface CallableStatementSQLExceptionpublic void setShort(String parameterName, short x) throws SQLException
setShort in interface CallableStatementSQLExceptionpublic void setString(String parameterName, String x) throws SQLException
setString in interface CallableStatementSQLExceptionpublic void setTime(String parameterName, Time x) throws SQLException
setTime in interface CallableStatementSQLExceptionpublic void setTime(String parameterName, Time x, Calendar cal) throws SQLException
setTime in interface CallableStatementSQLExceptionpublic void setTimestamp(String parameterName, Timestamp x) throws SQLException
setTimestamp in interface CallableStatementSQLExceptionpublic void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
setTimestamp in interface CallableStatementSQLExceptionpublic void setURL(String parameterName, URL val) throws SQLException
setURL in interface CallableStatementSQLExceptionpublic boolean wasNull()
throws SQLException
wasNull in interface CallableStatementSQLExceptionpublic Reader getCharacterStream(int parm) throws SQLException
getCharacterStream in interface CallableStatementparm - SQLExceptionpublic Reader getCharacterStream(String parm) throws SQLException
getCharacterStream in interface CallableStatementparm - SQLExceptionpublic Reader getNCharacterStream(int parm) throws SQLException
getNCharacterStream in interface CallableStatementparm - SQLExceptionpublic Reader getNCharacterStream(String parm) throws SQLException
getNCharacterStream in interface CallableStatementparm - SQLExceptionpublic String getNString(int parm) throws SQLException
getNString in interface CallableStatementparm - SQLExceptionpublic String getNString(String parm) throws SQLException
getNString in interface CallableStatementparm - SQLExceptionpublic void setAsciiStream(String parm, InputStream arg1) throws SQLException
setAsciiStream in interface CallableStatementparm - arg1 - SQLExceptionpublic void setAsciiStream(String parm, InputStream arg1, long arg2) throws SQLException
setAsciiStream in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setBinaryStream(String parm, InputStream arg1) throws SQLException
setBinaryStream in interface CallableStatementparm - arg1 - SQLExceptionpublic void setBinaryStream(String parm, InputStream arg1, long arg2) throws SQLException
setBinaryStream in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setBlob(String parm, Blob arg1) throws SQLException
setBlob in interface CallableStatementparm - arg1 - SQLExceptionpublic void setBlob(String parm, InputStream arg1) throws SQLException
setBlob in interface CallableStatementparm - arg1 - SQLExceptionpublic void setBlob(String parm, InputStream arg1, long arg2) throws SQLException
setBlob in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setCharacterStream(String parm, Reader arg1) throws SQLException
setCharacterStream in interface CallableStatementparm - arg1 - SQLExceptionpublic void setCharacterStream(String parm, Reader arg1, long arg2) throws SQLException
setCharacterStream in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setClob(String parm, Clob arg1) throws SQLException
setClob in interface CallableStatementparm - arg1 - SQLExceptionpublic void setClob(String parm, Reader arg1) throws SQLException
setClob in interface CallableStatementparm - arg1 - SQLExceptionpublic void setClob(String parm, Reader arg1, long arg2) throws SQLException
setClob in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setNCharacterStream(String parm, Reader arg1) throws SQLException
setNCharacterStream in interface CallableStatementparm - arg1 - SQLExceptionpublic void setNCharacterStream(String parm, Reader arg1, long arg2) throws SQLException
setNCharacterStream in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setNClob(String parm, Reader arg1) throws SQLException
setNClob in interface CallableStatementparm - arg1 - SQLExceptionpublic void setNClob(String parm, Reader arg1, long arg2) throws SQLException
setNClob in interface CallableStatementparm - arg1 - arg2 - SQLExceptionpublic void setNString(String parm, String arg1) throws SQLException
setNString in interface CallableStatementparm - arg1 - SQLException