java.sql.CallableStatement |
An interface used to call Stored Procedures .
The JDBC API provides an SQL escape syntax allowing
Stored Procedures
to be called in a standard way for all databases. The JDBC escape syntax has
two forms. One form includes a result parameter. The second form does not
include a result parameter. Where the result parameter is used, it must be
declared as an
OUT
parameter. Other parameters can be declared as
IN
,
OUT
, or
INOUT
. Parameters are referenced either by
name or by a numerical index starting at 1.
The correct syntax is:
IN
parameters are set before calling the procedure,
using the setter methods which are inherited from
PreparedStatement
.
For
OUT
parameters, their type must be registered before executing
the stored procedure. The values are retrieved using the getter methods
defined in the
CallableStatement
interface.
CallableStatement
s can return one or more
ResultSets
. In the
event that multiple
ResultSets
are returned, they are accessed using
the methods inherited from the
Statement
interface.
[Expand]
Inherited Constants
|
|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From interface
java.sql.Statement
|
Public Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
|
Gets the value of a specified JDBC
ARRAY
parameter as a
java.sql.Array
.
|
||||||||||
|
Gets the value of a specified JDBC
ARRAY
parameter as a
java.sql.Array
.
|
||||||||||
|
Returns a new
BigDecimal
representation of the JDBC
NUMERIC
parameter specified by the input name.
|
||||||||||
|
This method was deprecated
in API level 1.
Use
getBigDecimal(int)
or
getBigDecimal(String)
instead.
|
||||||||||
|
Returns a new
BigDecimal
representation of the JDBC
NUMERIC
parameter specified by the input index.
|
||||||||||
|
Gets the value of a specified JDBC
BLOB
parameter as a
java.sql.Blob
.
|
||||||||||
|
Gets the value of a specified JDBC
BLOB
parameter as a
java.sql.Blob
.
|
||||||||||
|
Gets the value of a specified JDBC
BIT
parameter as a boolean.
|
||||||||||
|
Gets the value of a specified JDBC
BIT
parameter as a
boolean
.
|
||||||||||
|
Gets the value of a specified JDBC
TINYINT
parameter as a Java
byte
.
|
||||||||||
|
Gets the value of a specified JDBC
TINYINT
parameter as a
byte
.
|
||||||||||
|
Returns a byte array representation of the indexed JDBC
BINARY
or
VARBINARY
parameter.
|
||||||||||
|
Returns a byte array representation of the named JDBC
BINARY
or
VARBINARY
parameter.
|
||||||||||
|
Returns the value of the specified parameter as a
java.io.Reader
.
|
||||||||||
|
Returns the value of the specified parameter as a
java.io.Reader
.
|
||||||||||
|
Gets the value of a specified JDBC
CLOB
parameter as a
java.sql.Clob
.
|
||||||||||
|
Gets the value of a specified JDBC
CLOB
parameter as a
java.sql.Clob
.
|
||||||||||
|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
, using the specified
Calendar
to construct the date.
|
||||||||||
|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
.
|
||||||||||
|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
, using the specified
Calendar
to construct the date.
|
||||||||||
|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
.
|
||||||||||
|
Gets the value of the specified JDBC
DOUBLE
parameter as a
double
.
|
||||||||||
|
Gets the value of the specified JDBC
DOUBLE
parameter as a
double
.
|
||||||||||
|
Gets the value of the specified JDBC
FLOAT
parameter as a
float
.
|
||||||||||
|
Gets the value of the specified JDBC
FLOAT
parameter as a Java
float
.
|
||||||||||
|
Gets the value of the specified JDBC
INTEGER
parameter as an
int
.
|
||||||||||
|
Gets the value of the specified JDBC
INTEGER
parameter as an
int
.
|
||||||||||
|
Gets the value of the specified JDBC
BIGINT
parameter as a
long
.
|
||||||||||
|
Gets the value of the specified JDBC
BIGINT
parameter as a
long
.
|
||||||||||
|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter
as a
Reader
.
|
||||||||||
|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter as a
java.io.Reader
.
|
||||||||||
|
Returns the value of the specified SQL NCLOB parameter as a
java.sql.NClob
.
|
||||||||||
|
Returns the value of the specified SQL NCLOB parameter as a
java.sql.NClob
.
|
||||||||||
|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter as a
java.lang.String
.
|
||||||||||
|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter as a
java.lang.String
.
|
||||||||||
|
Gets the value of a specified parameter as an
Object
.
|
||||||||||
|
Gets the value of the specified parameter as an
Object
.
|
||||||||||
|
Gets the value of the specified parameter as an
Object
.
|
||||||||||
|
Gets the value of the specified parameter as a Java
Object
.
|
||||||||||
|
Gets the value of a specified SQL
REF(
parameter as a
java.sql.Ref
.
|
||||||||||
|
Gets the value of a specified SQL
REF(
parameter as a
java.sql.Ref
.
|
||||||||||
|
Returns the value of the specified SQL ROWID parameter as a
java.sql.RowId
.
|
||||||||||
|
Gets the value of a specified
ROWID
parameter as a
java.sql.RowId
.
|
||||||||||
|
Returns the value of the specified SQL XML parameter as a
java.sql.SQLXML
.
|
||||||||||
|
Returns the value of the specified SQL XML parameter as a
java.sql.SQLXML
.
|
||||||||||
|
Gets the value of a specified JDBC
SMALLINT
parameter as a
short
.
|
||||||||||
|
Gets the value of a specified JDBC
SMALLINT
parameter as a
short
.
|
||||||||||
|
Returns the indexed parameter's value as a
String
.
|
||||||||||
|
Returns the named parameter's value as a string.
|
||||||||||
|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
, using the supplied
Calendar
to construct
the time.
|
||||||||||
|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
.
|
||||||||||
|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
, using the supplied
Calendar
to construct the
time.
|
||||||||||
|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
.
|
||||||||||
|
Returns the indexed parameter's
TIMESTAMP
value as a
java.sql.Timestamp
.
|
||||||||||
|
Returns the named parameter's
TIMESTAMP
value as a
java.sql.Timestamp
.
|
||||||||||
|
Returns the indexed parameter's
TIMESTAMP
value as a
java.sql.Timestamp
.
|
||||||||||
|
Returns the indexed parameter's
TIMESTAMP
value as a
java.sql.Timestamp
.
|
||||||||||
|
Gets the value of a specified JDBC
DATALINK
parameter as a
java.net.URL
.
|
||||||||||
|
Returns the named parameter's JDBC
DATALINK
value in a new Java
java.net.URL
.
|
||||||||||
|
Defines the Type of a specified
OUT
parameter.
|
||||||||||
|
Defines the type of a specified
OUT
parameter.
|
||||||||||
|
Defines the Type of a specified
OUT
parameter.
|
||||||||||
|
Defines the Type of a specified
OUT
parameter.
|
||||||||||
|
Defines the Type of a specified
OUT
parameter.
|
||||||||||
|
Defines the Type of a specified
OUT
parameter.
|
||||||||||
|
Sets the value of a specified parameter to the content of a supplied
InputStream
, which has a specified number of bytes.
|
||||||||||
|
Sets the named parameter to the bytes from the given
reader
.
|
||||||||||
|
Sets the named parameter to the next
length
bytes from the given
inputStream
.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
java.math.BigDecimal
value.
|
||||||||||
|
Sets the named parameter to the bytes from the given
reader
.
|
||||||||||
|
Sets the named parameter to the next
length
bytes from the given
inputStream
.
|
||||||||||
|
Sets the value of a specified parameter to the content of a supplied
binary
InputStream
, which has a specified number of bytes.
|
||||||||||
|
Sets the named parameter to the next
length
bytes from the given
inputStream
.
|
||||||||||
|
Sets the named parameter to the bytes from the given
inputStream
.
|
||||||||||
|
Sets the named parameter to the given
blob
.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
boolean
value.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
byte
value.
|
||||||||||
|
Sets the value of a specified parameter to a supplied array of bytes.
|
||||||||||
|
Sets the value of a specified parameter to the character content of a
Reader
object, with the specified length of character data.
|
||||||||||
|
Sets the named parameter to the next
length
characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the next
length
characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the given
clob
.
|
||||||||||
|
Sets the named parameter to the characters from the given
reader
.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
java.sql.Date
value, using a supplied calendar to map the date.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
java.sql.Date
value.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
double
value.
|
||||||||||
|
Sets the value of a specified parameter to to a supplied
float
value.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
int
value.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
long
value.
|
||||||||||
|
Sets the named parameter to the characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the next
length
characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the given
nclob
.
|
||||||||||
|
Sets the named parameter to the characters from the given
reader
.
|
||||||||||
|
Sets the named parameter to the given
string
.
|
||||||||||
|
Sets the value of a specified parameter to SQL
NULL
.
|
||||||||||
|
Sets the value of a specified parameter to be SQL
NULL
where the
parameter type is either
REF
or user defined (e.g.
|
||||||||||
|
Sets the value of a specified parameter using a supplied object.
|
||||||||||
|
Sets the value of a specified parameter using a supplied object.
|
||||||||||
|
Sets the value of a specified parameter using a supplied object.
|
||||||||||
|
Sets the named parameter to the given
rowId
.
|
||||||||||
|
Sets the named parameter to the given
sqlXml
.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
short
value.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
String
.
|
||||||||||
|
Sets the value of the parameter named
parameterName
to the value
of the supplied
java.sql.Time
using the supplied calendar.
|
||||||||||
|
Sets the value of the parameter named
parameterName
to the value
of the supplied
java.sql.Time
.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
java.sql.Timestamp
value, using the supplied calendar.
|
||||||||||
|
Sets the value of a specified parameter to a supplied
java.sql.Timestamp
value.
|
||||||||||
|
Sets the value of a specified parameter to the supplied
java.net.URL
.
|
||||||||||
|
Gets whether the value of the last
OUT
parameter read was SQL
NULL
.
|
[Expand]
Inherited Methods
|
|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From interface
java.lang.AutoCloseable
|
|||||||||||
From interface
java.sql.PreparedStatement
|
|||||||||||
From interface
java.sql.Statement
|
|||||||||||
From interface
java.sql.Wrapper
|
Gets the value of a specified JDBC
ARRAY
parameter as a
java.sql.Array
.
parameterIndex | the parameter index, where the first parameter has index 1. |
---|
java.sql.Array
containing the parameter value.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
ARRAY
parameter as a
java.sql.Array
.
parameterName | the desired parameter's name. |
---|
java.sql.Array
containing the parameter's value.
SQLException | if there is a problem accessing the database. |
---|
Returns a new
BigDecimal
representation of the JDBC
NUMERIC
parameter specified by the input name.
parameterName | the desired parameter's name. |
---|
java.math.BigDecimal
representing the value of the
specified parameter. The value
null
is returned if
the parameter in question is an SQL
NULL
.
SQLException | if a database error occurs. |
---|
This method was deprecated
in API level 1.
Use
getBigDecimal(int)
or
getBigDecimal(String)
instead.
Returns a new
BigDecimal
representation of the JDBC
NUMERIC
parameter specified by the input index. The number of digits
after the decimal point is specified by
scale
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|---|
scale | the number of digits after the decimal point to get. |
java.math.BigDecimal
representing the value of the
specified parameter. The value
null
is returned if
the parameter in question is an SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns a new
BigDecimal
representation of the JDBC
NUMERIC
parameter specified by the input index.
parameterIndex | the parameter number index where the first parameter has index 1. |
---|
java.math.BigDecimal
representing the value of the
specified parameter. The value
null
is returned if
the parameter in question is an SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
BLOB
parameter as a
java.sql.Blob
.
parameterName | the desired parameter's name. |
---|
java.sql.Blob
representing the value of the
specified parameter. The value
null
is returned if
the parameter in question is an SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
BLOB
parameter as a
java.sql.Blob
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
java.sql.Blob
representing the value of the
specified parameter. The value
null
is returned if
the parameter in question is an SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
BIT
parameter as a boolean.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
boolean
representing the parameter value.
false
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
BIT
parameter as a
boolean
.
parameterName | the desired parameter's name. |
---|
boolean
representation of the value of the parameter.
false
is returned if the SQL value is
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
TINYINT
parameter as a Java
byte
.
parameterName | the desired parameter's name. |
---|
byte
representation of the value of the parameter.
0
is returned if the SQL value is
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
TINYINT
parameter as a
byte
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
byte
representation of the value of the parameter.
0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns a byte array representation of the indexed JDBC
BINARY
or
VARBINARY
parameter.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns a byte array representation of the named JDBC
BINARY
or
VARBINARY
parameter.
parameterName | the name of the parameter. |
---|
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns the value of the specified parameter as a
java.io.Reader
.
parameterName | the parameter name |
---|
SQLException | if a database error occurs |
---|
Returns the value of the specified parameter as a
java.io.Reader
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
CLOB
parameter as a
java.sql.Clob
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
java.sql.Clob
representing the value of the
parameter.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
CLOB
parameter as a
java.sql.Clob
.
parameterName | the name of the parameter. |
---|
java.sql.Clob
with the value of the parameter.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
, using the specified
Calendar
to construct the date.
The JDBC driver uses the calendar to create the Date using a particular timezone and locale. The default behavior of the driver is to use the VM defaults. See " Be wary of the default locale ".
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|---|
cal |
the
Calendar
to use to construct the date
|
java.sql.Date
giving the parameter's value.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
java.sql.Date
representing the parameter's value.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
, using the specified
Calendar
to construct the date.
The JDBC driver uses the calendar to create the date using a particular timezone and locale. The default behavior of the driver is to use the VM defaults. See " Be wary of the default locale ".
parameterName | the name of the desired parameter. |
---|---|
cal |
used for creating the returned
Date
.
|
java.sql.Date
giving the parameter's value.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
DATE
parameter as a
java.sql.Date
.
parameterName | the name of the desired parameter. |
---|
java.sql.Date
giving the parameter's value.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
DOUBLE
parameter as a
double
.
parameterName | the name of the desired parameter. |
---|
double
.
0.0
is returned if the value is SQL
NULL
.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of the specified JDBC
DOUBLE
parameter as a
double
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
double
.
0.0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
FLOAT
parameter as a
float
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
float
.
0.0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
FLOAT
parameter as a Java
float
.
parameterName | the name of the desired parameter. |
---|
float
.
0.0
is returned if the value is SQL
NULL
.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of the specified JDBC
INTEGER
parameter as an
int
.
parameterName | the name of the desired parameter. |
---|
int
giving the parameter's value.
0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
INTEGER
parameter as an
int
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
int
giving the parameter's value.
0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
BIGINT
parameter as a
long
.
parameterName | the name of the desired parameter. |
---|
long
giving the parameter's value.
0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of the specified JDBC
BIGINT
parameter as a
long
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
long
giving the parameter's value.
0
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter
as a
Reader
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter as a
java.io.Reader
.
parameterName | the parameter name |
---|
SQLException | if a database error occurs |
---|
Returns the value of the specified SQL NCLOB parameter as a
java.sql.NClob
.
parameterName | the parameter name |
---|
SQLException | if a database error occurs |
---|
Returns the value of the specified SQL NCLOB parameter as a
java.sql.NClob
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter as a
java.lang.String
.
parameterName | the parameter name |
---|
SQLException | if a database error occurs |
---|
Returns the value of the specified SQL NCHAR, NVARCHAR, or LONGNVARCHAR parameter as a
java.lang.String
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Gets the value of a specified parameter as an
Object
. The
actual return type is determined by the
Map
parameter which
gives the correspondence between SQL types and Java classes.
parameterName | the parameter name. |
---|---|
map |
the
Map
of SQL types to their Java counterparts
|
Object
holding the value of the parameter.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of the specified parameter as an
Object
. The
Map
gives the correspondence between SQL types and Java classes.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|---|
map |
the
Map
giving the correspondence between SQL
types and Java classes.
|
SQLException | if a database error occurs. |
---|
Gets the value of the specified parameter as an
Object
.
The object type returned is the JDBC type that was registered for
the parameter by an earlier call to
registerOutParameter(int, int)
.
If a parameter was registered as a
java.sql.Types.OTHER
then it may hold abstract types that are particular to the
connected database.
parameterName | the parameter name. |
---|
Object
representation of the value of the
parameter.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of the specified parameter as a Java
Object
.
The object type returned is the JDBC type registered for the parameter
with a
registerOutParameter
call. If a parameter was registered
as a
java.sql.Types.OTHER
then it may hold abstract types that
are particular to the connected database.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Gets the value of a specified SQL
REF(
parameter as a
java.sql.Ref
.
parameterName | the desired parameter's name. |
---|
java.sql.Ref
. A
null
reference is returned if the
parameter's value is SQL
NULL
.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of a specified SQL
REF(
parameter as a
java.sql.Ref
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
java.sql.Ref
with the parameter value.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns the value of the specified SQL ROWID parameter as a
java.sql.RowId
.
parameterName | the parameter name |
---|
SQLException | if a database error occurs |
---|
Gets the value of a specified
ROWID
parameter as a
java.sql.RowId
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Returns the value of the specified SQL XML parameter as a
java.sql.SQLXML
.
parameterName | the parameter name |
---|
SQLException | if a database error occurs |
---|
Returns the value of the specified SQL XML parameter as a
java.sql.SQLXML
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
SMALLINT
parameter as a
short
.
parameterName | the desired parameter's name. |
---|
short
. 0 is returned
if the parameter's value is SQL
NULL
.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of a specified JDBC
SMALLINT
parameter as a
short
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
short
. 0 is returned
if the parameter's value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns the indexed parameter's value as a
String
. The
parameter value must be one of the JDBC types
CHAR
,
VARCHAR
or
LONGVARCHAR
.
The
String
corresponding to a
CHAR
of fixed length
will be of identical length to the value in the database inclusive
of padding characters.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
String
.
null
is returned if the value is SQL
NULL
.
SQLException | if there is a problem accessing the database. |
---|
Returns the named parameter's value as a string. The parameter value must
be one of the JDBC types
CHAR
,
VARCHAR
or
LONGVARCHAR
.
The string corresponding to a
CHAR
of fixed length will be of
identical length to the value in the database inclusive of padding
characters.
parameterName | the desired parameter's name. |
---|
String
.
null
is returned if the value is SQL
NULL
.
SQLException | if there is a problem accessing the database. |
---|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
, using the supplied
Calendar
to construct
the time. The JDBC driver uses the calendar to handle specific
timezones and locales when creating
Time
.
parameterName | the name of the desired parameter. |
---|---|
cal |
used for creating the returned
Time
|
java.sql.Time
with the parameter's value. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
.
parameterName | the name of the desired parameter. |
---|
java.sql.Time
with the parameter's value. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
, using the supplied
Calendar
to construct the
time. The JDBC driver uses the calendar to handle specific timezones
and locales in order to determine
Time
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|---|
cal |
the calendar to use in constructing
Time
.
|
java.sql.Time
.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
TIME
parameter as a
java.sql.Time
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
java.sql.Time
.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns the indexed parameter's
TIMESTAMP
value as a
java.sql.Timestamp
. The JDBC driver uses the supplied
Calendar
to handle specific timezones and locales when creating the result.
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
cal |
used for creating the returned
Timestamp
|
java.sql.Timestamp
. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Returns the named parameter's
TIMESTAMP
value as a
java.sql.Timestamp
.
parameterName | the name of the desired parameter. |
---|
java.sql.Timestamp
. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Returns the indexed parameter's
TIMESTAMP
value as a
java.sql.Timestamp
. The JDBC driver uses the supplied
Calendar
to handle specific timezones and locales when creating the result.
parameterName | the name of the desired parameter. |
---|---|
cal |
used for creating the returned
Timestamp
|
java.sql.Timestamp
. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Returns the indexed parameter's
TIMESTAMP
value as a
java.sql.Timestamp
.
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|
java.sql.Timestamp
. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Gets the value of a specified JDBC
DATALINK
parameter as a
java.net.URL
.
parameterIndex | the parameter number index, where the first parameter has index 1. |
---|
URL
giving the parameter's value.
null
is returned if the value is SQL
NULL
.
SQLException | if a database error occurs. |
---|
Returns the named parameter's JDBC
DATALINK
value in a new Java
java.net.URL
.
parameterName | the name of the desired parameter. |
---|
java.net.URL
encapsulating the parameter value. A
null
reference is returned for an SQL value of
NULL
.
SQLException | if a database error occurs. |
---|
Defines the Type of a specified
OUT
parameter. All OUT parameters
must have their Type defined before a stored procedure is executed.
The type supplied in the
sqlType
parameter fixes the
type that will be returned by the getter methods of
CallableStatement
.
If a database-specific type is expected for a parameter, the Type
java.sql.Types.OTHER
should be used. Note that there is another variant
of this method for User Defined Types or a
REF
type.
parameterName | the parameter name. |
---|---|
sqlType |
a JDBC type expressed as a constant from
Types
. Types
NUMERIC
and
DECIMAL
should be defined using
the variant of this method that takes a
scale
parameter.
|
SQLException | if a database error occurs. |
---|
Defines the type of a specified
OUT
parameter. All
OUT
parameters must have their type defined before a stored procedure is
executed.
The type supplied in the
sqlType
parameter fixes the
type that will be returned by the getter methods of
CallableStatement
.
If a database specific type is expected for a parameter, the Type
java.sql.Types.OTHER
should be used. Note that there is another variant
of this method for User Defined Types or a
REF
type.
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
sqlType |
the JDBC type as defined by
java.sql.Types
. The JDBC
types
NUMERIC
and
DECIMAL
should be defined
using
registerOutParameter(int, int, int)
.
|
SQLException | if a database error occurs. |
---|
Defines the Type of a specified
OUT
parameter. This variant of
the method is designed for use with parameters that are
User Defined
Types
(UDT) or a
REF
type, although it can be used for any
type.
parameterName | the parameter name |
---|---|
sqlType |
a JDBC type expressed as a constant from
Types
|
typeName |
the fully qualified name of an SQL structured type. For a
REF
type, this name should be the fully qualified name
of the referenced type.
|
SQLException | if a database error occurs. |
---|
Defines the Type of a specified
OUT
parameter. All
OUT
parameters must have their Type defined before a stored procedure is
executed. This version of the
registerOutParameter
method, which
has a scale parameter, should be used for the JDBC types
NUMERIC
and
DECIMAL
, where there is a need to specify the number of
digits expected after the decimal point.
The type supplied in the
sqlType
parameter fixes the
type that will be returned by the getter methods of
CallableStatement
.
parameterName | the parameter name. |
---|---|
sqlType |
a JDBC type expressed as a constant from
Types
.
|
scale | the number of digits after the decimal point. Must be greater than or equal to 0. |
SQLException | if a database error occurs. |
---|
Defines the Type of a specified
OUT
parameter. All
OUT
parameters must have their type defined before a stored procedure is
executed. This version of the
registerOutParameter
method, which
has a scale parameter, should be used for the JDBC types
NUMERIC
and
DECIMAL
, where there is a need to specify the number of
digits expected after the decimal point.
The type supplied in the
sqlType
parameter fixes the
type that will be returned by the getter methods of
CallableStatement
.
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
sqlType |
the JDBC type as defined by
java.sql.Types
.
|
scale | the number of digits after the decimal point. Must be greater than or equal to 0. |
SQLException | if a database error occurs. |
---|
Defines the Type of a specified
OUT
parameter. This variant
of the method is designed for use with parameters that are
User Defined Types
(UDT) or a
REF
type, although it
can be used for any type.
paramIndex | the parameter number index, where the first parameter has index 1. |
---|---|
sqlType |
a JDBC type expressed as a constant from
Types
.
|
typeName |
an SQL type name. For a
REF
type, this name should be
the fully qualified name of the referenced type.
|
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to the content of a supplied
InputStream
, which has a specified number of bytes.
This is a good method for setting an SQL
LONGVARCHAR
parameter
where the length of the data is large. Data is read from the
InputStream
until end-of-file is reached or the specified number of
bytes is copied.
parameterName | the parameter name |
---|---|
theInputStream | the ASCII input stream carrying the data to update the parameter with. |
length |
the number of bytes in the
InputStream
to copy to the
parameter.
|
SQLException | if a database error occurs. |
---|
Sets the named parameter to the bytes from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the next
length
bytes from the given
inputStream
.
SQLException | if a database error occurs |
---|
Sets the value of a specified parameter to a supplied
java.math.BigDecimal
value.
parameterName | the name of the parameter. |
---|---|
theBigDecimal |
the
java.math.BigInteger
value to set.
|
SQLException | if a database error occurs. |
---|
Sets the named parameter to the bytes from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the next
length
bytes from the given
inputStream
.
SQLException | if a database error occurs |
---|
Sets the value of a specified parameter to the content of a supplied
binary
InputStream
, which has a specified number of bytes.
Use this method when a large amount of data needs to be set into a
LONGVARBINARY
parameter.
parameterName | the name of the parameter. |
---|---|
theInputStream |
the binary
InputStream
carrying the data to update the
parameter.
|
length |
the number of bytes in the
InputStream
to copy to the
parameter.
|
SQLException | if a database error occurs. |
---|
Sets the named parameter to the next
length
bytes from the given
inputStream
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the bytes from the given
inputStream
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the given
blob
.
SQLException | if a database error occurs |
---|
Sets the value of a specified parameter to a supplied
boolean
value.
parameterName | the parameter name. |
---|---|
theBoolean | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
byte
value.
parameterName | the parameter name. |
---|---|
theByte | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied array of bytes. The
array is mapped to
VARBINARY
or else
LONGVARBINARY
in the
connected database.
parameterName | the parameter name. |
---|---|
theBytes | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to the character content of a
Reader
object, with the specified length of character data.
parameterName | the parameter name. |
---|---|
reader | the new value with which to update the parameter. |
length |
a count of the characters contained in
reader
.
|
SQLException | if a database error occurs. |
---|
Sets the named parameter to the next
length
characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the next
length
characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the given
clob
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the value of a specified parameter to a supplied
java.sql.Date
value, using a supplied calendar to map the date. The
calendar allows the application to control the timezone used to compute
the SQL
DATE
in the database. In case that no calendar is
supplied, the driver uses the default timezone of the Java virtual
machine.
parameterName | the parameter name. |
---|---|
theDate | the new value with which to update the parameter. |
cal |
a
Calendar
to use to construct the SQL
DATE
value.
|
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
java.sql.Date
value.
parameterName | the parameter name. |
---|---|
theDate | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
double
value.
parameterName | the parameter name. |
---|---|
theDouble | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to to a supplied
float
value.
parameterName | the parameter name. |
---|---|
theFloat | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
int
value.
parameterName | the parameter name. |
---|---|
theInt | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
long
value.
parameterName | the parameter name. |
---|---|
theLong | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the named parameter to the characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the next
length
characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the given
nclob
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the characters from the given
reader
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the given
string
.
SQLException | if a database error occurs |
---|
Sets the value of a specified parameter to SQL
NULL
. Don't use
this version of
setNull
for
User Defined Types
(UDT) or
for
REF
type parameters.
parameterName | the parameter name. |
---|---|
sqlType |
a JDBC type expressed as a constant from
Types
.
|
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to be SQL
NULL
where the
parameter type is either
REF
or user defined (e.g.
STRUCT
,
JAVA_OBJECT
etc).
For reasons of portability, the caller is expected to supply both the SQL
type code and type name (which is just the parameter name if the type is
user defined, referred to as a
UDT
, or the name of the referenced
type in case of a
REF
type).
parameterName | the parameter name. |
---|---|
sqlType |
a JDBC type expressed as a constant from
Types
.
|
typeName |
if the target parameter is a user defined type then this
should contain the full type name. The fully qualified name of
a
UDT
or
REF
type is ignored if the parameter
is not a
UDT
.
|
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter using a supplied object. Prior to
issuing this request to the connected database
theObject
is
transformed to the corresponding SQL type according to the standard Java
to SQL mapping rules.
If the object's class implements the interface
SQLData
, the JDBC
driver calls
SQLData.writeSQL
to write it to the SQL data stream.
If
theObject
implements any of the following interfaces then the
driver is in charge of mapping the value to the appropriate SQL type.
parameterName | the parameter name |
---|---|
theObject | the new value with which to update the parameter |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter using a supplied object.
The parameter
theObject
is converted to the given
targetSqlType
before it is sent to the database. If the object has a
custom mapping (its class implements the interface
SQLData
), the
JDBC driver calls the method
SQLData.writeSQL
to write it to the
SQL data stream. If
theObject
is an instance of one of the
following types
parameterName | the parameter name. |
---|---|
theObject | the new value with which to update the parameter. |
targetSqlType |
a JDBC type expressed as a constant from
Types
.
|
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter using a supplied object.
The object is converted to the given
targetSqlType
before it is
sent to the database. If the object has a custom mapping (its class
implements the interface
SQLData
), the JDBC driver calls the
method
SQLData.writeSQL
to write it to the SQL data stream. If
theObject
implements any of the following interfaces
parameterName | the parameter name. |
---|---|
theObject | the new value with which to update the parameter. |
targetSqlType |
a JDBC type expressed as a constant from
Types
.
|
scale | where applicable, the number of digits after the decimal. point. |
SQLException | if a database error occurs. |
---|
Sets the named parameter to the given
rowId
.
SQLException | if a database error occurs |
---|
Sets the named parameter to the given
sqlXml
.
SQLException | if a database error occurs |
---|
Sets the value of a specified parameter to a supplied
short
value.
parameterName | the name of the parameter. |
---|---|
theShort | a short value to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
String
.
parameterName | the name of the parameter. |
---|---|
theString |
a
String
value to update the parameter.
|
SQLException | if a database error occurs. |
---|
Sets the value of the parameter named
parameterName
to the value
of the supplied
java.sql.Time
using the supplied calendar.
The driver uses the supplied
Calendar
to create the SQL
TIME
value, which allows it to use a custom timezone -
otherwise the driver uses the VM defaults.
See "
Be wary of the default locale
".
parameterName | the parameter name. |
---|---|
theTime | the new value with which to update the parameter. |
cal |
used for creating the new SQL
TIME
value.
|
SQLException | if a database error occurs. |
---|
Sets the value of the parameter named
parameterName
to the value
of the supplied
java.sql.Time
.
parameterName | the parameter name. |
---|---|
theTime | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
java.sql.Timestamp
value, using the supplied calendar.
The driver uses the supplied calendar to create the SQL
TIMESTAMP
value, which allows it to use a custom timezone - otherwise the driver
uses the VM defaults.
See "
Be wary of the default locale
".
parameterName | the parameter name. |
---|---|
theTimestamp | the new value with which to update the parameter. |
cal |
used for creating the new SQL
TIME
value.
|
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to a supplied
java.sql.Timestamp
value.
parameterName | the parameter name. |
---|---|
theTimestamp | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Sets the value of a specified parameter to the supplied
java.net.URL
.
parameterName | the parameter name. |
---|---|
theURL | the new value with which to update the parameter. |
SQLException | if a database error occurs. |
---|
Gets whether the value of the last
OUT
parameter read was SQL
NULL
.
NULL
,
false
otherwise.
SQLException | if a database error occurs. |
---|