|
|||||||||
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
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.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |