|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
public interface CallableStatement
This interface provides a mechanism for calling stored procedures.
| Field Summary |
|---|
| 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 |
| Method Summary | |
|---|---|
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. |
| Methods inherited from interface java.sql.PreparedStatement |
|---|
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 |
| Method Detail |
|---|
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
Typesscale - 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
TypestypeName - 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.
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||