java.sql
public interface CallableStatement extends PreparedStatement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Modifier and Type | Method and Description |
---|---|
Array |
getArray(int index)
This method returns the value of the specified parameter as a Java
Array . |
Array |
getArray(String name)
This method returns the value of the specified parameter as a Java
Array . |
BigDecimal |
getBigDecimal(int index)
This method returns the value of the specified parameter as a Java
BigDecimal . |
BigDecimal |
getBigDecimal(int index,
int scale)
Deprecated.
Use getBigDecimal(int index)
or getBigDecimal(String name) instead.
|
BigDecimal |
getBigDecimal(String name)
This method returns the value of the specified parameter as a Java
BigDecimal . |
Blob |
getBlob(int index)
This method returns the value of the specified parameter as a Java
Blob . |
Blob |
getBlob(String name)
This method returns the value of the specified parameter as a Java
Blob . |
boolean |
getBoolean(int index)
This method returns the value of the specified parameter as a Java
boolean . |
boolean |
getBoolean(String name)
This method returns the value of the specified parameter as a Java
boolean . |
byte |
getByte(int index)
This method returns the value of the specified parameter as a Java
byte . |
byte |
getByte(String name)
This method returns the value of the specified parameter as a Java
byte . |
byte[] |
getBytes(int index)
This method returns the value of the specified parameter as a Java
byte array.
|
byte[] |
getBytes(String name)
This method returns the value of the specified parameter as a Java
byte array. |
Clob |
getClob(int index)
This method returns the value of the specified parameter as a Java
Clob . |
Clob |
getClob(String name)
This method returns the value of the specified parameter as a Java
Clob . |
Date |
getDate(int index)
This method returns the value of the specified parameter as a Java
java.sql.Date . |
Date |
getDate(int index,
Calendar cal)
This method returns the value of the specified parameter as a Java
java.sql.Date . |
Date |
getDate(String name)
This method returns the value of the specified parameter as a Java
java.sql.Date . |
Date |
getDate(String name,
Calendar cal)
This method returns the value of the specified parameter as a Java
java.sql.Date . |
double |
getDouble(int index)
This method returns the value of the specified parameter as a Java
double . |
double |
getDouble(String name)
This method returns the value of the specified parameter as a Java
double . |
float |
getFloat(int index)
This method returns the value of the specified parameter as a Java
float . |
float |
getFloat(String name)
This method returns the value of the specified parameter as a Java
float . |
int |
getInt(int index)
This method returns the value of the specified parameter as a Java
int . |
int |
getInt(String name)
This method returns the value of the specified parameter as a Java
int . |
long |
getLong(int index)
This method returns the value of the specified parameter as a Java
long . |
long |
getLong(String name)
This method returns the value of the specified parameter as a Java
long . |
Object |
getObject(int index)
This method returns the value of the specified parameter as a Java
Object . |
Object |
getObject(int index,
Map<String,Class<?>> map)
This method returns the value of the specified parameter as a Java
Object . |
Object |
getObject(String name)
This method returns the value of the specified parameter as a Java
Object . |
Object |
getObject(String name,
Map<String,Class<?>> map)
This method returns the value of the specified parameter as a Java
Object using the specified mapping for conversion from
SQL to Java types. |
Ref |
getRef(int index)
This method returns the value of the specified parameter as a Java
Ref . |
Ref |
getRef(String name)
This method returns the value of the specified parameter as a Java
Ref . |
short |
getShort(int index)
This method returns the value of the specified parameter as a Java
short . |
short |
getShort(String name)
This method returns the value of the specified parameter as a Java
short . |
String |
getString(int index)
This method returns the value of the specified parameter as a Java
String . |
String |
getString(String name)
This method returns the value of the specified parameter as a Java
String . |
Time |
getTime(int index)
This method returns the value of the specified parameter as a Java
java.sql.Time . |
Time |
getTime(int index,
Calendar cal)
This method returns the value of the specified parameter as a Java
java.sql.Time . |
Time |
getTime(String name)
This method returns the value of the specified parameter as a Java
java.sql.Time . |
Time |
getTime(String name,
Calendar cal)
This method returns the value of the specified parameter as a Java
java.sql.Time . |
Timestamp |
getTimestamp(int index)
This method returns the value of the specified parameter as a Java
java.sql.Timestamp . |
Timestamp |
getTimestamp(int index,
Calendar cal)
This method returns the value of the specified parameter as a Java
java.sql.Timestamp . |
Timestamp |
getTimestamp(String name)
This method returns the value of the specified parameter as a Java
java.sql.Timestamp . |
Timestamp |
getTimestamp(String name,
Calendar cal)
This method returns the value of the specified parameter as a Java
java.sql.Timestamp . |
URL |
getURL(int index)
This method returns the value of the specified parameter as a Java
java.net.URL . |
URL |
getURL(String name)
This method returns the value of the specified parameter as a Java
java.net.URL . |
void |
registerOutParameter(int index,
int sqlType)
This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void |
registerOutParameter(int index,
int sqlType,
int scale)
This method registers the specified parameter as an output parameter
of the specified SQL type and scale.
|
void |
registerOutParameter(int index,
int sqlType,
String typeName)
This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void |
registerOutParameter(String name,
int sqlType)
This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void |
registerOutParameter(String name,
int sqlType,
int scale)
This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void |
registerOutParameter(String name,
int sqlType,
String typeName)
This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void |
setAsciiStream(String name,
InputStream stream,
int count)
This method sets the specified parameter from the given Java
ASCII
InputStream value. |
void |
setBigDecimal(String name,
BigDecimal value)
This method sets the specified parameter from the given Java
BigDecimal value. |
void |
setBinaryStream(String name,
InputStream stream,
int count)
This method sets the specified parameter from the given Java
binary
InputStream value. |
void |
setBoolean(String name,
boolean value)
This method sets the specified parameter from the given Java
boolean value. |
void |
setByte(String name,
byte value)
This method sets the specified parameter from the given Java
byte value. |
void |
setBytes(String name,
byte[] value)
This method sets the specified parameter from the given Java
byte array value. |
void |
setCharacterStream(String name,
Reader reader,
int count)
This method sets the specified parameter from the given Java
character
Reader value. |
void |
setDate(String name,
Date value)
This method sets the specified parameter from the given Java
java.sql.Date value. |
void |
setDate(String name,
Date value,
Calendar cal)
This method sets the specified parameter from the given Java
java.sql.Date value. |
void |
setDouble(String name,
double value)
This method sets the specified parameter from the given Java
double value. |
void |
setFloat(String name,
float value)
This method sets the specified parameter from the given Java
float value. |
void |
setInt(String name,
int value)
This method sets the specified parameter from the given Java
int value. |
void |
setLong(String name,
long value)
This method sets the specified parameter from the given Java
long value. |
void |
setNull(String name,
int sqlType)
This method populates the specified parameter with a SQL NULL value
for the specified type.
|
void |
setNull(String name,
int sqlType,
String typeName)
This method populates the specified parameter with a SQL NULL value
for the specified type.
|
void |
setObject(String name,
Object value)
This method sets the specified parameter from the given Java
Object value. |
void |
setObject(String name,
Object value,
int sqlType)
This method sets the specified parameter from the given Java
Object value. |
void |
setObject(String name,
Object value,
int sqlType,
int scale)
This method sets the specified parameter from the given Java
Object value. |
void |
setShort(String name,
short value)
This method sets the specified parameter from the given Java
short value. |
void |
setString(String name,
String value)
This method sets the specified parameter from the given Java
String value. |
void |
setTime(String name,
Time value)
This method sets the specified parameter from the given Java
java.sql.Time value. |
void |
setTime(String name,
Time value,
Calendar cal)
This method sets the specified parameter from the given Java
java.sql.Time value. |
void |
setTimestamp(String name,
Timestamp value)
This method sets the specified parameter from the given Java
java.sql.Timestamp value. |
void |
setTimestamp(String name,
Timestamp value,
Calendar cal)
This method sets the specified parameter from the given Java
java.sql.Timestamp value. |
void |
setURL(String name,
URL value)
This method sets the value of the specified parameter to the specified
java.net.URL |
boolean |
wasNull()
This method tests whether the value of the last parameter that was fetched
was actually a SQL NULL value.
|
addBatch, clearParameters, execute, executeQuery, 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
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
void registerOutParameter(int index, int sqlType) throws SQLException
index
- The index of the parameter to register as output.sqlType
- The SQL type value from Types
.SQLException
- If an error occurs.void registerOutParameter(int index, int sqlType, int scale) throws SQLException
index
- The index of the parameter to register as output.sqlType
- The SQL type value from Types
.scale
- The scale of the value that will be returned.SQLException
- If an error occurs.boolean wasNull() throws SQLException
true
if the last parameter fetched was a NULL,
false
otherwise.SQLException
- If an error occurs.String getString(int index) throws SQLException
String
.index
- The index of the parameter to return.String
.SQLException
- If an error occurs.boolean getBoolean(int index) throws SQLException
boolean
.index
- The index of the parameter to return.boolean
.SQLException
- If an error occurs.byte getByte(int index) throws SQLException
byte
.index
- The index of the parameter to return.byte
.SQLException
- If an error occurs.short getShort(int index) throws SQLException
short
.index
- The index of the parameter to return.short
.SQLException
- If an error occurs.int getInt(int index) throws SQLException
int
.index
- The index of the parameter to return.int
.SQLException
- If an error occurs.long getLong(int index) throws SQLException
long
.index
- The index of the parameter to return.long
.SQLException
- If an error occurs.float getFloat(int index) throws SQLException
float
.index
- The index of the parameter to return.float
.SQLException
- If an error occurs.double getDouble(int index) throws SQLException
double
.index
- The index of the parameter to return.double
.SQLException
- If an error occurs.BigDecimal getBigDecimal(int index, int scale) throws SQLException
BigDecimal
.index
- The index of the parameter to return.scale
- The number of digits to the right of the decimal to return.BigDecimal
.SQLException
- If an error occurs.byte[] getBytes(int index) throws SQLException
index
- The index of the parameter to return.SQLException
- If an error occurs.Date getDate(int index) throws SQLException
java.sql.Date
.index
- The index of the parameter to return.java.sql.Date
.SQLException
- If an error occurs.Time getTime(int index) throws SQLException
java.sql.Time
.index
- The index of the parameter to return.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(int index) throws SQLException
java.sql.Timestamp
.index
- The index of the parameter to return.java.sql.Timestamp
.SQLException
- If an error occurs.Object getObject(int index) throws SQLException
Object
.index
- The index of the parameter to return.Object
.SQLException
- If an error occurs.BigDecimal getBigDecimal(int index) throws SQLException
BigDecimal
.index
- The index of the parameter to return.BigDecimal
.SQLException
- If an error occurs.Object getObject(int index, Map<String,Class<?>> map) throws SQLException
Object
.index
- The index of the parameter to return.map
- The mapping to use for conversion from SQL to Java types.Object
.SQLException
- If an error occurs.Ref getRef(int index) throws SQLException
Ref
.index
- The index of the parameter to return.Ref
.SQLException
- If an error occurs.Blob getBlob(int index) throws SQLException
Blob
.index
- The index of the parameter to return.Blob
.SQLException
- If an error occurs.Clob getClob(int index) throws SQLException
Clob
.index
- The index of the parameter to return.Clob
.SQLException
- If an error occurs.Array getArray(int index) throws SQLException
Array
.index
- The index of the parameter to return.Array
.SQLException
- If an error occurs.Date getDate(int index, Calendar cal) throws SQLException
java.sql.Date
.index
- The index of the parameter to return.cal
- The Calendar
to use for timezone and locale.java.sql.Date
.SQLException
- If an error occurs.Time getTime(int index, Calendar cal) throws SQLException
java.sql.Time
.index
- The index of the parameter to return.cal
- The Calendar
to use for timezone and locale.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(int index, Calendar cal) throws SQLException
java.sql.Timestamp
.index
- The index of the parameter to return.java.sql.Timestamp
.SQLException
- If an error occurs.void registerOutParameter(int index, int sqlType, String typeName) throws SQLException
index
- The index of the parameter to register as output.sqlType
- The SQL type value from Types
.typeName
- The user defined data type name.SQLException
- If an error occurs.void registerOutParameter(String name, int sqlType) throws SQLException
name
- The name of the parameter to register as output.sqlType
- The SQL type value from Types
.SQLException
- If an error occurs.void registerOutParameter(String name, int sqlType, int scale) throws SQLException
name
- The name of the parameter to register as output.sqlType
- The SQL type value from Types
.scale
- Number of digits to the right of the decimal point.SQLException
- If an error occurs.void registerOutParameter(String name, int sqlType, String typeName) throws SQLException
name
- The name of the parameter to register as output.sqlType
- The SQL type value from Types
.typeName
- The SQL structured type name.SQLException
- If an error occurs.URL getURL(int index) throws SQLException
java.net.URL
.index
- The index of the parameter to return.URL
.SQLException
- If an error occurs.void setURL(String name, URL value) throws SQLException
java.net.URL
name
- The name of the parameter to set.value
- The value the parameter.SQLException
void setNull(String name, int sqlType) throws SQLException
name
- The name of the parameter to set.sqlType
- The SQL type identifier of the parameter from
Types
SQLException
- If an error occurs.void setBoolean(String name, boolean value) throws SQLException
boolean
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setByte(String name, byte value) throws SQLException
byte
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setShort(String name, short value) throws SQLException
short
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setInt(String name, int value) throws SQLException
int
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setLong(String name, long value) throws SQLException
long
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setFloat(String name, float value) throws SQLException
float
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setDouble(String name, double value) throws SQLException
double
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setBigDecimal(String name, BigDecimal value) throws SQLException
BigDecimal
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setString(String name, String value) throws SQLException
String
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setBytes(String name, byte[] value) throws SQLException
byte
array value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setDate(String name, Date value) throws SQLException
java.sql.Date
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setTime(String name, Time value) throws SQLException
java.sql.Time
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setTimestamp(String name, Timestamp value) throws SQLException
java.sql.Timestamp
value.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setAsciiStream(String name, InputStream stream, int count) throws SQLException
InputStream
value.name
- The name of the parameter value to set.stream
- The stream from which the parameter value is read.count
- The number of bytes in the stream.SQLException
- If an error occurs.void setBinaryStream(String name, InputStream stream, int count) throws SQLException
InputStream
value.name
- The name of the parameter value to set.stream
- The stream from which the parameter value is read.count
- The number of bytes in the stream.SQLException
- If an error occurs.void setObject(String name, Object value, int sqlType, int scale) throws SQLException
Object
value. The specified SQL object type will be used.name
- The name of the parameter value to set.value
- The value of the parameter.sqlType
- The SQL type to use for the parameter, from
Types
scale
- The scale of the value, for numeric values only.SQLException
- If an error occurs.Types
void setObject(String name, Object value, int sqlType) throws SQLException
Object
value. The specified SQL object type will be used.name
- The name of the parameter value to set.value
- The value of the parameter.sqlType
- The SQL type to use for the parameter, from
Types
SQLException
- If an error occurs.Types
void setObject(String name, Object value) throws SQLException
Object
value. The default object type to SQL type mapping
will be used.name
- The name of the parameter value to set.value
- The value of the parameter.SQLException
- If an error occurs.void setCharacterStream(String name, Reader reader, int count) throws SQLException
Reader
value.name
- The name of the parameter value to set.reader
- The reader from which the parameter value is read.count
- The number of characters in the stream.SQLException
- If an error occurs.void setDate(String name, Date value, Calendar cal) throws SQLException
java.sql.Date
value.name
- The name of the parameter value to set.value
- The value of the parameter.cal
- The Calendar
to use for timezone and locale.SQLException
- If an error occurs.void setTime(String name, Time value, Calendar cal) throws SQLException
java.sql.Time
value.name
- The name of the parameter value to set.value
- The value of the parameter.cal
- The Calendar
to use for timezone and locale.SQLException
- If an error occurs.void setTimestamp(String name, Timestamp value, Calendar cal) throws SQLException
java.sql.Timestamp
value.name
- The name of the parameter value to set.value
- The value of the parameter.cal
- The Calendar
to use for timezone and locale.SQLException
- If an error occurs.void setNull(String name, int sqlType, String typeName) throws SQLException
name
- The name of the parameter to set.sqlType
- The SQL type identifier of the parameter from
Types
typeName
- The name of the data type, for user defined types.SQLException
- If an error occurs.String getString(String name) throws SQLException
String
.name
- The name of the parameter to return.String
.SQLException
- If an error occurs.boolean getBoolean(String name) throws SQLException
boolean
.name
- The name of the parameter to return.boolean
.SQLException
- If an error occurs.byte getByte(String name) throws SQLException
byte
.name
- The name of the parameter to return.byte
.SQLException
- If an error occurs.short getShort(String name) throws SQLException
short
.name
- The name of the parameter to return.short
.SQLException
- If an error occurs.int getInt(String name) throws SQLException
int
.name
- The name of the parameter to return.int
.SQLException
- If an error occurs.long getLong(String name) throws SQLException
long
.name
- The name of the parameter to return.long
.SQLException
- If an error occurs.float getFloat(String name) throws SQLException
float
.name
- The name of the parameter to return.float
.SQLException
- If an error occurs.double getDouble(String name) throws SQLException
double
.name
- The name of the parameter to return.double
.SQLException
- If an error occurs.byte[] getBytes(String name) throws SQLException
byte
array.name
- The name of the parameter to return.byte[]
.SQLException
- If an error occurs.Date getDate(String name) throws SQLException
java.sql.Date
.name
- The name of the parameter to return.java.sql.Date
.SQLException
- If an error occurs.Time getTime(String name) throws SQLException
java.sql.Time
.name
- The name of the parameter to return.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(String name) throws SQLException
java.sql.Timestamp
.name
- The name of the parameter to return.java.sql.Timestamp
.SQLException
- If an error occurs.Object getObject(String name) throws SQLException
Object
.name
- The name of the parameter to return.Object
.SQLException
- If an error occurs.BigDecimal getBigDecimal(String name) throws SQLException
BigDecimal
.name
- The name of the parameter to return.BigDecimal
.SQLException
- If an error occurs.Object getObject(String name, Map<String,Class<?>> map) throws SQLException
Object
using the specified mapping for conversion from
SQL to Java types.name
- The name of the parameter to return.map
- The mapping to use for conversion from SQL to Java types.Object
.SQLException
- If an error occurs.Ref getRef(String name) throws SQLException
Ref
.name
- The name of the parameter to return.Ref
.SQLException
- If an error occurs.Blob getBlob(String name) throws SQLException
Blob
.name
- The name of the parameter to return.Blob
.SQLException
- If an error occurs.Clob getClob(String name) throws SQLException
Clob
.name
- The name of the parameter to return.Clob
.SQLException
- If an error occurs.Array getArray(String name) throws SQLException
Array
.name
- The name of the parameter to return.Array
.SQLException
- If an error occurs.Date getDate(String name, Calendar cal) throws SQLException
java.sql.Date
.name
- The name of the parameter to return.cal
- The Calendar
to use for timezone and locale.java.sql.Date
.SQLException
- If an error occurs.Time getTime(String name, Calendar cal) throws SQLException
java.sql.Time
.name
- The name of the parameter to return.cal
- The Calendar
to use for timezone and locale.java.sql.Time
.SQLException
- If an error occurs.Timestamp getTimestamp(String name, Calendar cal) throws SQLException
java.sql.Timestamp
.name
- The name of the parameter to return.cal
- The Calendar
to use for timezone and locale.java.sql.Timestamp
.SQLException
- If an error occurs.URL getURL(String name) throws SQLException
java.net.URL
.name
- The name of the parameter to return.java.net.URL
.SQLException
- If an error occurs.