|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.as400.access.AS400JDBCStatement | +--com.ibm.as400.access.AS400JDBCPreparedStatement | +--com.ibm.as400.access.AS400JDBCCallableStatement
The AS400JDBCCallableStatement class runs a stored procedure. Use Connection.prepareCall() to create new CallableStatement objects.
Parameters are indexed sequentially, by number, starting at 1. The caller must register output parameters before executing the stored procedure.
The new JDK 1.4 methods add the ability to retrieve information by column name in addition to column index. Be aware you will see better performance accessing columns by their index rather than accessing them by their name.
Method Summary | |
java.sql.Array |
getArray(int parameterIndex)
Returns the value of an SQL ARRAY output parameter as an Array value. |
java.sql.Array |
getArray(java.lang.String parameterName)
Returns the value of an SQL ARRAY output parameter as an Array value. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex)
Returns the value of an SQL NUMERIC or DECIMAL output parameter as a BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated. Use getBigDecimal(int) or getBigDecimal(String) instead. |
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName)
Returns the value of an SQL NUMERIC or DECIMAL output parameter as a BigDecimal object. |
java.sql.Blob |
getBlob(int parameterIndex)
Returns the value of an SQL BLOB output parameter as a Blob value. |
java.sql.Blob |
getBlob(java.lang.String parameterName)
Returns the value of an SQL BLOB output parameter as a Blob value. |
boolean |
getBoolean(int parameterIndex)
Returns the value of an SQL SMALLINT output parameter as a Java boolean. |
boolean |
getBoolean(java.lang.String parameterName)
Returns the value of an SQL SMALLINT output parameter as a Java boolean. |
byte |
getByte(int parameterIndex)
Returns the value of an SQL SMALLINT output parameter as a Java byte. |
byte |
getByte(java.lang.String parameterName)
Returns the value of an SQL SMALLINT output parameter as a Java byte. |
byte[] |
getBytes(int parameterIndex)
Returns the value of an SQL BINARY or VARBINARY output parameter as a Java byte array. |
byte[] |
getBytes(java.lang.String parameterName)
Returns the value of an SQL BINARY or VARBINARY output parameter as a Java byte array. |
java.sql.Clob |
getClob(int parameterIndex)
Returns the value of an SQL CLOB output parameter as a Clob value. |
java.sql.Clob |
getClob(java.lang.String parameterName)
Returns the value of an SQL CLOB output parameter as a Clob value. |
java.sql.Date |
getDate(int parameterIndex)
Returns the value of an SQL DATE output parameter as a java.sql.Date object using the default calendar. |
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar calendar)
Returns the value of an SQL DATE output parameter as a java.sql.Date object using a calendar other than the default. |
java.sql.Date |
getDate(java.lang.String parameterName)
Returns the value of an SQL DATE output parameter as a java.sql.Date object using the default calendar. |
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar calendar)
Returns the value of an SQL DATE output parameter as a java.sql.Date object using a calendar other than the default. |
double |
getDouble(int parameterIndex)
Returns the value of an SQL DOUBLE or FLOAT output parameter as a Java double. |
double |
getDouble(java.lang.String parameterName)
Returns the value of an SQL DOUBLE or FLOAT output parameter as a Java double. |
float |
getFloat(int parameterIndex)
Returns the value of an SQL REAL or FLOAT output parameter as a Java float. |
float |
getFloat(java.lang.String parameterName)
Returns the value of an SQL REAL or FLOAT output parameter as a Java float. |
int |
getInt(int parameterIndex)
Returns the value of an SQL INTEGER output parameter as a Java int. |
int |
getInt(java.lang.String parameterName)
Returns the value of an SQL INTEGER output parameter as a Java int. |
long |
getLong(int parameterIndex)
If the connected AS/400 or iSeries server supports SQL BIGINT data, this returns the value of an SQL BIGINT output parameter as a Java long. |
long |
getLong(java.lang.String parameterName)
If the connected AS/400 or iSeries server supports SQL BIGINT data, this returns the value of an SQL BIGINT output parameter as a Java long. |
java.lang.Object |
getObject(int parameterIndex)
Returns the value of an output parameter as a Java Object. |
java.lang.Object |
getObject(int parameterIndex,
java.util.Map typeMap)
Returns the value of an output parameter as a Java Object. |
java.lang.Object |
getObject(java.lang.String parameterName)
Returns the value of an output parameter as a Java Object. |
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map typeMap)
Returns the value of an output parameter as a Java Object. |
java.sql.Ref |
getRef(int parameterIndex)
Returns the value of an SQL REF output parameter as a Ref value. |
java.sql.Ref |
getRef(java.lang.String parameterName)
Returns the value of an SQL REF output parameter as a Ref value. |
short |
getShort(int parameterIndex)
Returns the value of an SQL SMALLINT output parameter as a Java short value. |
short |
getShort(java.lang.String parameterName)
Returns the value of an SQL SMALLINT output parameter as a Java short value. |
java.lang.String |
getString(int parameterIndex)
Returns the value of an SQL CHAR or VARCHAR output parameter as a Java String object. |
java.lang.String |
getString(java.lang.String parameterName)
Returns the value of an SQL CHAR or VARCHAR output parameter as a Java String object. |
java.sql.Time |
getTime(int parameterIndex)
Returns the value of an SQL TIME output parameter as a java.sql.Time object using the default calendar. |
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar calendar)
Returns the value of an SQL TIME output parameter as a java.sql.Time object using a calendar other than the default. |
java.sql.Time |
getTime(java.lang.String parameterName)
Returns the value of an SQL TIME output parameter as a java.sql.Time object using the default calendar. |
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar calendar)
Returns the value of an SQL TIME output parameter as a java.sql.Time object using a calendar other than the default. |
java.sql.Timestamp |
getTimestamp(int parameterIndex)
Returns the value of an SQL TIMESTAMP output parameter as a java.sql.Timestamp object using the default calendar. |
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar calendar)
Returns the value of an SQL TIMESTAMP output parameter as a java.sql.Timestamp object using a calendar other than the default. |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName)
Returns the value of an SQL TIMESTAMP output parameter as a java.sql.Timestamp object using the default calendar. |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar calendar)
Returns the value of an SQL TIMESTAMP output parameter as a java.sql.Timestamp object using a calendar other than the default. |
java.net.URL |
getURL(int parameterIndex)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object. |
java.net.URL |
getURL(java.lang.String parameterName)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object. |
void |
registerOutParameter(int parameterIndex,
int sqlType)
Registers the type for an output parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the type for an output parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
Registers the type for an output parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType)
Registers the type for an output parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
Registers the type for an output parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Registers the type for an output parameter. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream parameterValue,
int length)
Sets an input parameter to an ASCII stream value. |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal parameterValue)
Sets an input parameter to a BigDecimal value. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream parameterValue,
int length)
Sets an input parameter to a binary stream value. |
void |
setBoolean(java.lang.String parameterName,
boolean parameterValue)
Sets an input parameter to a Java boolean value. |
void |
setByte(java.lang.String parameterName,
byte parameterValue)
Sets an input parameter to a Java byte value. |
void |
setBytes(java.lang.String parameterName,
byte[] parameterValue)
Sets an input parameter to a Java byte array value. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader parameterValue,
int length)
Sets an input parameter to a character stream value. |
void |
setDate(java.lang.String parameterName,
java.sql.Date parameterValue)
Sets an input parameter to a java.sql.Date value using the default calendar. |
void |
setDate(java.lang.String parameterName,
java.sql.Date parameterValue,
java.util.Calendar cal)
Sets an input parameter to a java.sql.Date value using a calendar other than the default. |
void |
setDouble(java.lang.String parameterName,
double parameterValue)
Sets an input parameter to a Java double value. |
void |
setFloat(java.lang.String parameterName,
float parameterValue)
Sets an input parameter to a Java float value. |
void |
setInt(java.lang.String parameterName,
int parameterValue)
Sets an input parameter to a Java int value. |
void |
setLong(java.lang.String parameterName,
long parameterValue)
Sets an input parameter to a Java long value. |
void |
setNull(java.lang.String parameterName,
int sqlType)
Sets an input parameter to SQL NULL. |
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Sets an input parameter to SQL NULL. |
void |
setObject(java.lang.String parameterName,
java.lang.Object parameterValue)
Sets an input parameter to an Object value. |
void |
setObject(java.lang.String parameterName,
java.lang.Object parameterValue,
int targetSqlType)
Sets an input parameter to an Object value. |
void |
setObject(java.lang.String parameterName,
java.lang.Object parameterValue,
int targetSqlType,
int scale)
Sets an input parameter to an Object value. |
void |
setShort(java.lang.String parameterName,
short parameterValue)
Sets an input parameter to a Java short value. |
void |
setString(java.lang.String parameterName,
java.lang.String parameterValue)
Sets an input parameter to a String value. |
void |
setTime(java.lang.String parameterName,
java.sql.Time parameterValue)
Sets an input parameter to a java.sql.Time value using the default calendar. |
void |
setTime(java.lang.String parameterName,
java.sql.Time parameterValue,
java.util.Calendar cal)
Sets an input parameter to a java.sql.Time value using a calendar other than the default. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp parameterValue)
Sets an input parameter to a java.sql.Timestamp value using the default calendar. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp parameterValue,
java.util.Calendar cal)
Sets an input parameter to a java.sql.Timestamp value using a calendar other than the default. |
void |
setURL(java.lang.String parameterName,
java.net.URL parameterValue)
Sets an input parameter to a URL value. |
boolean |
wasNull()
Indicates if the last parameter read has the value of SQL NULL. |
Methods inherited from class com.ibm.as400.access.AS400JDBCPreparedStatement |
addBatch, addBatch, clearParameters, close, execute, execute, execute, executeBatch, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, getMetaData, getParameterMetaData, 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 com.ibm.as400.access.AS400JDBCStatement |
cancel, clearBatch, clearWarnings, execute, execute, executeUpdate, executeUpdate, finalize, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, toString |
Methods inherited from class java.lang.Object |
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Methods inherited from interface java.sql.PreparedStatement |
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, 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 |
Methods inherited from interface java.sql.Statement |
addBatch, cancel, clearBatch, clearWarnings, close, execute, executeBatch, executeQuery, executeUpdate, getConnection, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
Method Detail |
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support arrays.public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support arrays.public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).scale
- The number of digits after the decimal.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the scale is not valid,
the statement was not executed, or
the requested conversion is not valid.getBigDecimal(int)
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid,
or an error occurs.public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid,
or an error occurs.public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Date getDate(int parameterIndex, java.util.Calendar calendar) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed,
the calendar is null, or
the requested conversion is not valid.public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar calendar) throws java.sql.SQLException
parameterName
- The parameter name.calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed,
the calendar is null, or
the requested conversion is not valid.public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public int getInt(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public long getLong(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.lang.Object getObject(int parameterIndex, java.util.Map typeMap) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).type
- The type map. This is not used.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.lang.Object getObject(java.lang.String parameterName, java.util.Map typeMap) throws java.sql.SQLException
parameterName
- The parameter name.type
- The type map. This is not used.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support REFs.public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support REFs.public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public short getShort(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
parameterIndex
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Time getTime(int parameterIndex, java.util.Calendar calendar) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed,
the calendar is null, or
the requested conversion is not valid.public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar calendar) throws java.sql.SQLException
parameterName
- The parameter name.calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed,
the calendar is null, or
the requested conversion is not valid.public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar calendar) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the index is
not registered as an output parameter,
the statement was not executed,
the calendar is null, or
the requested conversion is not valid.public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed, or
the requested conversion is not valid.public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar calendar) throws java.sql.SQLException
parameterName
- The parameter name.calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed,
the calendar is null, or
the requested conversion is not valid.public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
parameterIndex
- The parameter index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed or
the requested conversion is not valid.public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- The parameter name.java.sql.SQLException
- If the statement is not open,
the name is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed or
the requested conversion is not valid.public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).sqlType
- The SQL type code defined in java.sql.Types.scale
- The number of digits after the decimal
if sqlType is DECIMAL or NUMERIC.java.sql.SQLException
- If the index is not valid,
the scale is not valid,
the parameter is not an output parameter,
or the requested conversion is not valid.public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).sqlType
- The SQL type code defined in java.sql.Types.java.sql.SQLException
- If the index is not valid,
the parameter is not an output parameter,
or the requested conversion is not valid.public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- The parameter index (1-based).sqlType
- The SQL type code defined in java.sql.Types.typeName
- The fully-qualified name of an SQL structured type. This value will be ignored.java.sql.SQLException
- If the index is not valid,
the parameter is not an output parameter,
or the requested conversion is not valid.public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
parameterName
- The parameter name.sqlType
- The SQL type code defined in java.sql.Types.java.sql.SQLException
- If the index is not valid,
the parameter is not an output parameter,
or the requested conversion is not valid.public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
parameterName
- The parameter name.sqlType
- The SQL type code defined in java.sql.Types.scale
- The number of digits after the decimal
if sqlType is DECIMAL or NUMERIC.java.sql.SQLException
- If the index is not valid,
the scale is not valid,
the parameter is not an output parameter,
or the requested conversion is not valid.public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
parameterName
- The parameter name.sqlType
- The SQL type code defined in java.sql.Types.typeName
- The fully-qualified name of an SQL structured type. This value will be ignored.java.sql.SQLException
- If the index is not valid,
the parameter is not an output parameter,
or the requested conversion is not valid.public void setAsciiStream(java.lang.String parameterName, java.io.InputStream parameterValue, int length) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.length
- The number of bytes in the stream.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter
is not an input parameter,
the length is not valid,
the input stream does not contain all
ASCII characters, or an error occurs
while reading the input stream.public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal parameterValue) throws java.sql.SQLException
parameterIndex
- The parameter index (1-based).parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the index is not valid, or the parameter
is not an input parameter.public void setBinaryStream(java.lang.String parameterName, java.io.InputStream parameterValue, int length) throws java.sql.SQLException
parameterIndex
- The parameter index (1-based).parameterValue
- The parameter value or null to set
the value to SQL NULL.length
- The number of bytes in the stream.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter
is not an input parameter,
the length is not valid, or
an error occurs while reading the
input stream.public void setBoolean(java.lang.String parameterName, boolean parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameterName is not valid, or
the parameter is not an input parameter.public void setByte(java.lang.String parameterName, byte parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or
the parameter is not an input parameter.public void setBytes(java.lang.String parameterName, byte[] parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or the parameter
is not an input parameter.public void setCharacterStream(java.lang.String parameterName, java.io.Reader parameterValue, int length) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.length
- The number of bytes in the reader.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter
is not an input parameter,
the length is not valid,
or an error occurs while reading the
character streampublic void setDate(java.lang.String parameterName, java.sql.Date parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or the parameter
is not an input parameter.public void setDate(java.lang.String parameterName, java.sql.Date parameterValue, java.util.Calendar cal) throws java.sql.SQLException
parameterIndex
- The parameter index (1-based).parameterValue
- The parameter value or null to set
the value to SQL NULL.calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter
is not an input parameter,
or the calendar is null.public void setDouble(java.lang.String parameterName, double parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid or
the parameter is not an input parameter.public void setFloat(java.lang.String parameterName, float parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or
the parameter is not an input parameter.public void setInt(java.lang.String parameterName, int parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid or
the parameter is not an input parameter.public void setLong(java.lang.String parameterName, long parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or
the parameter is not an input parameter.public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
parameterName
- The parameter name.sqlType
- The SQL type code defined in java.sql.Types.java.sql.SQLException
- If the statement is not open,
the parameterName is not valid,
the parameter is not an input parameter,
or the SQL type is not valid.public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
parameterName
- The parameter name.sqlType
- The SQL type code defined in java.sql.Types.typeName
- The fully-qualified name of an SQL structured type. This value will be ignored.java.sql.SQLException
- If the statement is not open,
the index is not valid,
the parameter is not an input parameter,
or the SQL type is not valid.public void setObject(java.lang.String parameterName, java.lang.Object parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the index is not valid,
the parameter is not an input parameter,
the type of value is not supported,
or the parameter is not serializable
(when proxy support is in use).public void setObject(java.lang.String parameterName, java.lang.Object parameterValue, int targetSqlType) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.targetSQLType
- The SQL type code defined in java.sql.Types.java.sql.SQLException
- If the statement is not open,
the index is not valid,
the parameter is not an input parameter,
the SQL type is not valid,
the scale is not valid,
or the parameter is not serializable
(when proxy support is in use).public void setObject(java.lang.String parameterName, java.lang.Object parameterValue, int targetSqlType, int scale) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.targetSQLType
- The SQL type code defined in java.sql.Types.scale
- The number of digits after the decimal
if sqlType is DECIMAL or NUMERIC.java.sql.SQLException
- If the statement is not open,
the index is not valid,
the parameter is not an input parameter,
the SQL type is not valid,
the scale is not valid,
or the parameter is not serializable
(when proxy support is in use).public void setShort(java.lang.String parameterName, short parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid or
the parameter is not an input parameter.public void setString(java.lang.String parameterName, java.lang.String parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or the parameter
is not an input parameter.public void setTime(java.lang.String parameterName, java.sql.Time parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or the parameter
is not an input parameter.public void setTime(java.lang.String parameterName, java.sql.Time parameterValue, java.util.Calendar cal) throws java.sql.SQLException
parameterIndex
- The parameter index (1-based).parameterValue
- The parameter value or null to set
the value to SQL NULL.calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter
is not an input parameter,
or the calendar is null.public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or the parameter
is not an input parameter.public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp parameterValue, java.util.Calendar cal) throws java.sql.SQLException
parameterIndex
- The parameter index (1-based).parameterValue
- The parameter value or null to set
the value to SQL NULL.calendar
- The calendar.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter
is not an input parameter,
or the calendar is null.public void setURL(java.lang.String parameterName, java.net.URL parameterValue) throws java.sql.SQLException
parameterName
- The parameter name.parameterValue
- The parameter value or null to set
the value to SQL NULL.java.sql.SQLException
- If the statement is not open,
the parameter name is not valid, or the parameter
is not an input parameter.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
- If the statement is not open.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |