|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.sas.rio.MVAStatement | +--com.sas.rio.MVAPreparedStatement | +--com.sas.rio.MVACallableStatement
Note: None of the methods in this class are supported because SAS software does not support stored procedures. All methods in this class throw an SQLException.
MVAConnection.prepareCall(java.lang.String)
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 |
Method Summary | |
Array |
getArray(int i)
JDBC 2.0 Gets an Array OUT parameter. |
Array |
getArray(String parameterName)
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language. |
BigDecimal |
getBigDecimal(int parameterIndex)
Deprecated. |
BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated. |
BigDecimal |
getBigDecimal(String parameterName)
Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains. |
Blob |
getBlob(int i)
JDBC 2.0 Gets a BLOB OUT parameter. |
Blob |
getBlob(String parameterName)
Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language. |
boolean |
getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language. |
boolean |
getBoolean(String parameterName)
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language. |
byte |
getByte(int parameterIndex)
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language. |
byte |
getByte(String parameterName)
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language. |
byte[] |
getBytes(int parameterIndex)
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. |
byte[] |
getBytes(String parameterName)
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. |
Clob |
getClob(int i)
JDBC 2.0 Gets a CLOB OUT parameter. |
Clob |
getClob(String parameterName)
Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming language. |
Date |
getDate(int parameterIndex)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. |
Date |
getDate(int parameterIndex,
Calendar cal)
Gets the value of a SQL DATE parameter as a java.sql.Date object. |
Date |
getDate(String parameterName)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. |
Date |
getDate(String parameterName,
Calendar cal)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. |
double |
getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language. |
double |
getDouble(String parameterName)
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language. |
float |
getFloat(int parameterIndex)
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language. |
float |
getFloat(String parameterName)
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language. |
int |
getInt(int parameterIndex)
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language. |
int |
getInt(String parameterName)
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language. |
long |
getLong(int parameterIndex)
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language. |
long |
getLong(String parameterName)
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language. |
Object |
getObject(int parameterIndex)
Retrieves the value of the designated parameter as an Object in the Java programming language. |
Object |
getObject(int i,
Map map)
JDBC 2.0 Gets an object representing the value of OUT parameter @i. |
Object |
getObject(String parameterName)
Retrieves the value of the designated parameter as an Object in the Java programming language. |
Object |
getObject(String parameterName,
Map map)
Retrieves the value of the designated parameter as an Object in the Java programming language. |
Ref |
getRef(int i)
JDBC 2.0 Gets a REF(<structured-type>) OUT parameter. |
Ref |
getRef(String parameterName)
Retrieves the value of the designated JDBC REF( |
short |
getShort(int parameterIndex)
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language. |
short |
getShort(String parameterName)
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language. |
String |
getString(int parameterIndex)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
String |
getString(String parameterName)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
Time |
getTime(int parameterIndex)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. |
Time |
getTime(int parameterIndex,
Calendar cal)
Gets the value of a SQL TIME parameter as a java.sql.Time object. |
Time |
getTime(String parameterName)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. |
Time |
getTime(String parameterName,
Calendar cal)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. |
Timestamp |
getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. |
Timestamp |
getTimestamp(int parameterIndex,
Calendar cal)
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object. |
Timestamp |
getTimestamp(String parameterName)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. |
Timestamp |
getTimestamp(String parameterName,
Calendar cal)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. |
URL |
getURL(int parameterIndex)
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object. |
URL |
getURL(String parameterName)
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object. |
void |
registerOutParameter(int parameterIndex,
int sqlType)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(String parameterName,
int sqlType)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(String parameterName,
int sqlType,
int scale)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
setAsciiStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
setBigDecimal(String parameterName,
BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value. |
void |
setBinaryStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
setBoolean(String parameterName,
boolean x)
Sets the designated parameter to the given Java boolean value. |
void |
setByte(String parameterName,
byte x)
Sets the designated parameter to the given Java byte value. |
void |
setBytes(String parameterName,
byte[] x)
Sets the designated parameter to the given Java array of bytes. |
void |
setCharacterStream(String parameterName,
Reader reader,
int length)
Sets the designated parameter to the given Reader object, which is the given number of characters long. |
void |
setDate(String parameterName,
Date x)
Sets the designated parameter to the given java.sql.Date value. |
void |
setDate(String parameterName,
Date x,
Calendar cal)
Sets the designated parameter to the given java.sql.Date value. |
void |
setDouble(String parameterName,
double x)
Sets the designated parameter to the given Java double value. |
void |
setFloat(String parameterName,
float x)
Sets the designated parameter to the given Java float value. |
void |
setInt(String parameterName,
int x)
Sets the designated parameter to the given Java int value. |
void |
setLong(String parameterName,
long x)
Sets the designated parameter to the given Java long value. |
void |
setNull(String parameterName,
int sqlType)
Sets the designated parameter to SQL NULL. |
void |
setNull(String parameterName,
int sqlType,
String typeName)
Sets the designated parameter to SQL NULL. |
void |
setObject(String parameterName,
Object x)
Sets the value of the designated parameter with the given object. |
void |
setObject(String parameterName,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object. |
void |
setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object. |
void |
setShort(String parameterName,
short x)
Sets the designated parameter to the given Java short value. |
void |
setString(String parameterName,
String x)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
void |
setTime(String parameterName,
Time x)
Sets the designated parameter to the given java.sql.Time value. |
void |
setTime(String parameterName,
Time x,
Calendar cal)
Sets the designated parameter to the given java.sql.Time value. |
void |
setTimestamp(String parameterName,
Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value. |
void |
setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value. |
void |
setURL(String parameterName,
URL val)
Sets the designated parameter to the given java.net.URL object. |
boolean |
wasNull()
Retrieves whether the last OUT parameter read had the value of SQL NULL. |
Methods inherited from class com.sas.rio.MVAPreparedStatement |
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, registerOutParameter, setArray, setAsciiStream,
setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.CallableStatement |
registerOutParameter |
Methods inherited from interface java.sql.PreparedStatement |
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setChara
cterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTi
me, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL |
Methods inherited from interface java.sql.Statement |
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, exe
cute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, <
A HREF="http://java.sun.com/j2se/1.4.1/docs/api/java/sql/Statement.html#getFetchSize()">getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcu
rrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
Constructor Detail |
Method Detail |
public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
- This exception is always thrown.public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
- This exception is always thrown.public boolean wasNull() throws SQLException
wasNull
in interface CallableStatement
SQLException
- This exception is always thrown.public String getString(int parameterIndex) throws SQLException
getString
in interface CallableStatement
SQLException
- This exception is always thrown.public boolean getBoolean(int parameterIndex) throws SQLException
getBoolean
in interface CallableStatement
SQLException
- This exception is always thrown.public byte getByte(int parameterIndex) throws SQLException
getByte
in interface CallableStatement
SQLException
- This exception is always thrown.public short getShort(int parameterIndex) throws SQLException
getShort
in interface CallableStatement
SQLException
- This exception is always thrown.public int getInt(int parameterIndex) throws SQLException
getInt
in interface CallableStatement
SQLException
- This exception is always thrown.public long getLong(int parameterIndex) throws SQLException
getLong
in interface CallableStatement
SQLException
- This exception is always thrown.public float getFloat(int parameterIndex) throws SQLException
getFloat
in interface CallableStatement
SQLException
- This exception is always thrown.public double getDouble(int parameterIndex) throws SQLException
getDouble
in interface CallableStatement
SQLException
- This exception is always thrown.public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
getBigDecimal
in interface CallableStatement
SQLException
- This exception is always thrown.public byte[] getBytes(int parameterIndex) throws SQLException
getBytes
in interface CallableStatement
SQLException
- This exception is always thrown.public Date getDate(int parameterIndex) throws SQLException
getDate
in interface CallableStatement
SQLException
- This exception is always thrown.public Time getTime(int parameterIndex) throws SQLException
getTime
in interface CallableStatement
SQLException
- This exception is always thrown.public Timestamp getTimestamp(int parameterIndex) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
- This exception is always thrown.public Object getObject(int parameterIndex) throws SQLException
getObject
in interface CallableStatement
SQLException
- This exception is always thrown.public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
getBigDecimal
in interface CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Object getObject(int i, Map map) throws SQLException
getObject
in interface CallableStatement
i
- the first parameter is 1, the second is 2, ...map
- the mapping from SQL type names to Java classesSQLException
- This exception is always thrown.public Ref getRef(int i) throws SQLException
getRef
in interface CallableStatement
i
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Blob getBlob(int i) throws SQLException
getBlob
in interface CallableStatement
i
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Clob getClob(int i) throws SQLException
getClob
in interface CallableStatement
i
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Array getArray(int i) throws SQLException
getArray
in interface CallableStatement
i
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Date getDate(int parameterIndex, Calendar cal) throws SQLException
getDate
in interface CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Time getTime(int parameterIndex, Calendar cal) throws SQLException
getTime
in interface CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
getTimestamp
in interface CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...SQLException
- This exception is always thrown.public Array getArray(String parameterName) throws SQLException
getArray
in interface CallableStatement
SQLException
- This exception is always thrown.public BigDecimal getBigDecimal(String parameterName) throws SQLException
getBigDecimal
in interface CallableStatement
SQLException
- This exception is always thrown.public Blob getBlob(String parameterName) throws SQLException
getBlob
in interface CallableStatement
SQLException
- This exception is always thrown.public boolean getBoolean(String parameterName) throws SQLException
getBoolean
in interface CallableStatement
SQLException
- This exception is always thrown.public byte getByte(String parameterName) throws SQLException
getByte
in interface CallableStatement
SQLException
- This exception is always thrown.public byte[] getBytes(String parameterName) throws SQLException
getBytes
in interface CallableStatement
SQLException
- This exception is always thrown.public Clob getClob(String parameterName) throws SQLException
getClob
in interface CallableStatement
SQLException
- This exception is always thrown.public Date getDate(String parameterName) throws SQLException
getDate
in interface CallableStatement
SQLException
- This exception is always thrown.public Date getDate(String parameterName, Calendar cal) throws SQLException
getDate
in interface CallableStatement
SQLException
- This exception is always thrown.public double getDouble(String parameterName) throws SQLException
getDouble
in interface CallableStatement
SQLException
- This exception is always thrown.public float getFloat(String parameterName) throws SQLException
getFloat
in interface CallableStatement
SQLException
- This exception is always thrown.public int getInt(String parameterName) throws SQLException
getInt
in interface CallableStatement
SQLException
- This exception is always thrown.public long getLong(String parameterName) throws SQLException
getLong
in interface CallableStatement
SQLException
- This exception is always thrown.public Object getObject(String parameterName) throws SQLException
getObject
in interface CallableStatement
SQLException
- This exception is always thrown.public Object getObject(String parameterName, Map map) throws SQLException
getObject
in interface CallableStatement
SQLException
- This exception is always thrown.public Ref getRef(String parameterName) throws SQLException
getRef
in interface CallableStatement
SQLException
- This exception is always thrown.public short getShort(String parameterName) throws SQLException
getShort
in interface CallableStatement
SQLException
- This exception is always thrown.public String getString(String parameterName) throws SQLException
getString
in interface CallableStatement
SQLException
- This exception is always thrown.public Time getTime(String parameterName, Calendar cal) throws SQLException
getTime
in interface CallableStatement
SQLException
- This exception is always thrown.public Time getTime(String parameterName) throws SQLException
getTime
in interface CallableStatement
SQLException
- This exception is always thrown.public Timestamp getTimestamp(String parameterName) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
- This exception is always thrown.public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
getTimestamp
in interface CallableStatement
SQLException
- This exception is always thrown.public URL getURL(int parameterIndex) throws SQLException
getURL
in interface CallableStatement
SQLException
- This exception is always thrown.public URL getURL(String parameterName) throws SQLException
getURL
in interface CallableStatement
SQLException
- This exception is always thrown.public void registerOutParameter(String parameterName, int sqlType) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
- This exception is always thrown.public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
- This exception is always thrown.public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
registerOutParameter
in interface CallableStatement
SQLException
- This exception is always thrown.public void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
- This exception is always thrown.public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
setBigDecimal
in interface CallableStatement
SQLException
- This exception is always thrown.public void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
- This exception is always thrown.public void setBoolean(String parameterName, boolean x) throws SQLException
setBoolean
in interface CallableStatement
SQLException
- This exception is always thrown.public void setByte(String parameterName, byte x) throws SQLException
setByte
in interface CallableStatement
SQLException
- This exception is always thrown.public void setBytes(String parameterName, byte[] x) throws SQLException
setBytes
in interface CallableStatement
SQLException
- This exception is always thrown.public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
- This exception is always thrown.public void setDate(String parameterName, Date x) throws SQLException
setDate
in interface CallableStatement
SQLException
- This exception is always thrown.public void setDate(String parameterName, Date x, Calendar cal) throws SQLException
setDate
in interface CallableStatement
SQLException
- This exception is always thrown.public void setDouble(String parameterName, double x) throws SQLException
setDouble
in interface CallableStatement
SQLException
- This exception is always thrown.public void setFloat(String parameterName, float x) throws SQLException
setFloat
in interface CallableStatement
SQLException
- This exception is always thrown.public void setInt(String parameterName, int x) throws SQLException
setInt
in interface CallableStatement
SQLException
- This exception is always thrown.public void setLong(String parameterName, long x) throws SQLException
setLong
in interface CallableStatement
SQLException
- This exception is always thrown.public void setNull(String parameterName, int sqlType) throws SQLException
setNull
in interface CallableStatement
SQLException
- This exception is always thrown.public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
setNull
in interface CallableStatement
SQLException
- This exception is always thrown.public void setObject(String parameterName, Object x) throws SQLException
setObject
in interface CallableStatement
SQLException
- This exception is always thrown.public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObject
in interface CallableStatement
SQLException
- This exception is always thrown.public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
setObject
in interface CallableStatement
SQLException
- This exception is always thrown.public void setShort(String parameterName, short x) throws SQLException
setShort
in interface CallableStatement
SQLException
- This exception is always thrown.public void setString(String parameterName, String x) throws SQLException
setString
in interface CallableStatement
SQLException
- This exception is always thrown.public void setTime(String parameterName, Time x) throws SQLException
setTime
in interface CallableStatement
SQLException
- This exception is always thrown.public void setTime(String parameterName, Time x, Calendar cal) throws SQLException
setTime
in interface CallableStatement
SQLException
- This exception is always thrown.public void setTimestamp(String parameterName, Timestamp x) throws SQLException
setTimestamp
in interface CallableStatement
SQLException
- This exception is always thrown.public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
setTimestamp
in interface CallableStatement
SQLException
- This exception is always thrown.public void setURL(String parameterName, URL val) throws SQLException
setURL
in interface CallableStatement
SQLException
- This exception is always thrown.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |