|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Object
|
+--com.sas.net.sharenet.ShareNetStatement
|
+--com.sas.net.sharenet.ShareNetPreparedStatement
|
+--com.sas.net.sharenet.ShareNetCallableStatement
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.
ShareNetConnection.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 a 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 a 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 a 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 a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. |
double |
getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a float 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)
Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value. |
Ref |
getRef(int i)
JDBC 2.0 Gets a REF(<structured-type>) OUT parameter. |
Ref |
getRef(String parameterName)
Retrieves the value of a 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 a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. |
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 a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object. |
URL |
getURL(int parameterIndex)
Retrieves the value of the designated 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 designated output parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the designated output parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
String typeName)
Registers the designated output parameter. |
void |
registerOutParameter(String parameterName,
int sqlType)
Registers the designated output parameter. |
void |
registerOutParameter(String parameterName,
int sqlType,
int scale)
Registers the designated output parameter. |
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName)
Registers the designated output parameter. |
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, using the given Calendar object. |
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)
Sets the designated parameter to the given Java String value. |
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, using the given Calendar object. |
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, using the given Calendar object. |
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.net.sharenet.ShareNetPreparedStatement |
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, getResultSetMetaData, setArray<
/A>, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterS
tream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, set
Time, 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.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 CallableStatementSQLException - This exception is always thrown.
public void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws SQLException
registerOutParameter in interface CallableStatementSQLException - This exception is always thrown.
public void registerOutParameter(int parameterIndex,
int sqlType,
String typeName)
throws SQLException
registerOutParameter in interface CallableStatementSQLException - This exception is always thrown.
public boolean wasNull()
throws SQLException
wasNull in interface CallableStatementSQLException - This exception is always thrown.
public String getString(int parameterIndex)
throws SQLException
getString in interface CallableStatementSQLException - This exception is always thrown.
public boolean getBoolean(int parameterIndex)
throws SQLException
getBoolean in interface CallableStatementSQLException - This exception is always thrown.
public byte getByte(int parameterIndex)
throws SQLException
getByte in interface CallableStatementSQLException - This exception is always thrown.
public short getShort(int parameterIndex)
throws SQLException
getShort in interface CallableStatementSQLException - This exception is always thrown.
public int getInt(int parameterIndex)
throws SQLException
getInt in interface CallableStatementSQLException - This exception is always thrown.
public long getLong(int parameterIndex)
throws SQLException
getLong in interface CallableStatementSQLException - This exception is always thrown.
public float getFloat(int parameterIndex)
throws SQLException
getFloat in interface CallableStatementSQLException - This exception is always thrown.
public double getDouble(int parameterIndex)
throws SQLException
getDouble in interface CallableStatementSQLException - This exception is always thrown.
public BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws SQLException
getBigDecimal in interface CallableStatementSQLException - This exception is always thrown.
public byte[] getBytes(int parameterIndex)
throws SQLException
getBytes in interface CallableStatementSQLException - This exception is always thrown.
public Date getDate(int parameterIndex)
throws SQLException
getDate in interface CallableStatementSQLException - This exception is always thrown.
public Time getTime(int parameterIndex)
throws SQLException
getTime in interface CallableStatementSQLException - This exception is always thrown.
public Timestamp getTimestamp(int parameterIndex)
throws SQLException
getTimestamp in interface CallableStatementSQLException - This exception is always thrown.
public Object getObject(int parameterIndex)
throws SQLException
getObject in interface CallableStatementSQLException - This exception is always thrown.
public BigDecimal getBigDecimal(int parameterIndex)
throws SQLException
getBigDecimal in interface CallableStatementparameterIndex - 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 CallableStatementi - 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 CallableStatementi - 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 CallableStatementi - 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 CallableStatementi - 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 CallableStatementi - 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 CallableStatementparameterIndex - 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 CallableStatementparameterIndex - 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 CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...SQLException - This exception is always thrown.
public void registerOutParameter(String parameterName,
int sqlType)
throws SQLException
registerOutParameter in interface CallableStatementSQLException - This exception is always thrown.
public void registerOutParameter(String parameterName,
int sqlType,
int scale)
throws SQLException
registerOutParameter in interface CallableStatementSQLException - This exception is always thrown.
public void registerOutParameter(String parameterName,
int sqlType,
String typeName)
throws SQLException
registerOutParameter in interface CallableStatementSQLException - This exception is always thrown.
public URL getURL(int parameterIndex)
throws SQLException
getURL in interface CallableStatementSQLException - This exception is always thrown.
public void setURL(String parameterName,
URL val)
throws SQLException
setURL in interface CallableStatementSQLException - This exception is always thrown.
public void setNull(String parameterName,
int sqlType)
throws SQLException
setNull in interface CallableStatementSQLException - This exception is always thrown.
public void setBoolean(String parameterName,
boolean x)
throws SQLException
setBoolean in interface CallableStatementSQLException - This exception is always thrown.
public void setByte(String parameterName,
byte x)
throws SQLException
setByte in interface CallableStatementSQLException - This exception is always thrown.
public void setShort(String parameterName,
short x)
throws SQLException
setShort in interface CallableStatementSQLException - This exception is always thrown.
public void setInt(String parameterName,
int x)
throws SQLException
setInt in interface CallableStatementSQLException - This exception is always thrown.
public void setLong(String parameterName,
long x)
throws SQLException
setLong in interface CallableStatementSQLException - This exception is always thrown.
public void setFloat(String parameterName,
float x)
throws SQLException
setFloat in interface CallableStatementSQLException - This exception is always thrown.
public void setDouble(String parameterName,
double x)
throws SQLException
setDouble in interface CallableStatementSQLException - This exception is always thrown.
public void setBigDecimal(String parameterName,
BigDecimal x)
throws SQLException
setBigDecimal in interface CallableStatementSQLException - This exception is always thrown.
public void setString(String parameterName,
String x)
throws SQLException
setString in interface CallableStatementSQLException - This exception is always thrown.
public void setBytes(String parameterName,
byte[] x)
throws SQLException
setBytes in interface CallableStatementSQLException - This exception is always thrown.
public void setDate(String parameterName,
Date x)
throws SQLException
setDate in interface CallableStatementSQLException - This exception is always thrown.
public void setTime(String parameterName,
Time x)
throws SQLException
setTime in interface CallableStatementSQLException - This exception is always thrown.
public void setTimestamp(String parameterName,
Timestamp x)
throws SQLException
setTimestamp in interface CallableStatementSQLException - This exception is always thrown.
public void setAsciiStream(String parameterName,
InputStream x,
int length)
throws SQLException
setAsciiStream in interface CallableStatementSQLException - This exception is always thrown.
public void setBinaryStream(String parameterName,
InputStream x,
int length)
throws SQLException
setBinaryStream in interface CallableStatementSQLException - This exception is always thrown.
public void setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
throws SQLException
setObject in interface CallableStatementSQLException - This exception is always thrown.
public void setObject(String parameterName,
Object x,
int targetSqlType)
throws SQLException
setObject in interface CallableStatementSQLException - This exception is always thrown.
public void setObject(String parameterName,
Object x)
throws SQLException
setObject in interface CallableStatementSQLException - This exception is always thrown.
public void setCharacterStream(String parameterName,
Reader reader,
int length)
throws SQLException
setCharacterStream in interface CallableStatementSQLException - This exception is always thrown.
public void setDate(String parameterName,
Date x,
Calendar cal)
throws SQLException
setDate in interface CallableStatementSQLException - This exception is always thrown.
public void setTime(String parameterName,
Time x,
Calendar cal)
throws SQLException
setTime in interface CallableStatementSQLException - This exception is always thrown.
public void setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
throws SQLException
setTimestamp in interface CallableStatementSQLException - This exception is always thrown.
public void setNull(String parameterName,
int sqlType,
String typeName)
throws SQLException
setNull in interface CallableStatementSQLException - This exception is always thrown.
public String getString(String parameterName)
throws SQLException
getString in interface CallableStatementSQLException - This exception is always thrown.
public boolean getBoolean(String parameterName)
throws SQLException
getBoolean in interface CallableStatementSQLException - This exception is always thrown.
public byte getByte(String parameterName)
throws SQLException
getByte in interface CallableStatementSQLException - This exception is always thrown.
public short getShort(String parameterName)
throws SQLException
getShort in interface CallableStatementSQLException - This exception is always thrown.
public int getInt(String parameterName)
throws SQLException
getInt in interface CallableStatementSQLException - This exception is always thrown.
public long getLong(String parameterName)
throws SQLException
getLong in interface CallableStatementSQLException - This exception is always thrown.
public float getFloat(String parameterName)
throws SQLException
getFloat in interface CallableStatementSQLException - This exception is always thrown.
public double getDouble(String parameterName)
throws SQLException
getDouble in interface CallableStatementSQLException - This exception is always thrown.
public byte[] getBytes(String parameterName)
throws SQLException
getBytes in interface CallableStatementSQLException - This exception is always thrown.
public Date getDate(String parameterName)
throws SQLException
getDate in interface CallableStatementSQLException - This exception is always thrown.
public Time getTime(String parameterName)
throws SQLException
getTime in interface CallableStatementSQLException - This exception is always thrown.
public Timestamp getTimestamp(String parameterName)
throws SQLException
getTimestamp in interface CallableStatementSQLException - This exception is always thrown.
public Object getObject(String parameterName)
throws SQLException
getObject in interface CallableStatementSQLException - This exception is always thrown.
public BigDecimal getBigDecimal(String parameterName)
throws SQLException
getBigDecimal in interface CallableStatementSQLException - This exception is always thrown.
public Object getObject(String parameterName,
Map map)
throws SQLException
getObject in interface CallableStatementSQLException - This exception is always thrown.
public Ref getRef(String parameterName)
throws SQLException
getRef in interface CallableStatementSQLException - This exception is always thrown.
public Blob getBlob(String parameterName)
throws SQLException
getBlob in interface CallableStatementSQLException - This exception is always thrown.
public Clob getClob(String parameterName)
throws SQLException
getClob in interface CallableStatementSQLException - This exception is always thrown.
public Array getArray(String parameterName)
throws SQLException
getArray in interface CallableStatementSQLException - This exception is always thrown.
public Date getDate(String parameterName,
Calendar cal)
throws SQLException
getDate in interface CallableStatementSQLException - This exception is always thrown.
public Time getTime(String parameterName,
Calendar cal)
throws SQLException
getTime in interface CallableStatementSQLException - This exception is always thrown.
public Timestamp getTimestamp(String parameterName,
Calendar cal)
throws SQLException
getTimestamp in interface CallableStatementSQLException - This exception is always thrown.
public URL getURL(String parameterName)
throws SQLException
getURL in interface CallableStatementSQLException - This exception is always thrown.
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||