Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kuldeep raaj sharma
The Statement is an interface and its subclasses are
PreparedStatement and CallableStatement.
The Statement interface defines methods for executing SQL
statements that do not contain parameter markers. The
PreparedStatement interface adds methods for setting input
parameters, and the CallableStatement interface adds
methods for retrieving output parameter values returned
from stored procedures.
The CallableStatement interface extends PreparedStatement
with methods for executing and retrieving results from
stored procedures.
Creating a CallableStatement Object
As with Statement and PreparedStatement objects,
CallableStatement objects are created by Connection
objects. CODE EXAMPLE 13-18 shows the creation of a
CallableStatement object for calling the stored
procedure ‘validate’, which has a return parameter and two
other parameters.
CallableStatement cstmt = conn.prepareCall(
“{? = call validate(?, ?)}”);
Setting Parameters
CallableStatement objects may take three types of
parameters: IN, OUT, and
INOUT. The parameter can be specified as either an ordinal
parameter or a named
parameter. A value must be set for each parameter marker in
the statement.
The number, type, and attributes of parameters to a stored
procedure can be
determined using the DatabaseMetaData method
getProcedureColumns.
Parameter ordinals, which are integers passed to the
approriate setter method, refer to the parameter markers
("?") in the statement, starting at one. Literal parameter
values in the statement do not increment the ordinal value
of the parameter markers.
In CODE EXAMPLE the two parameter markers have the ordinal
values 1 and 2.
CallableStatement cstmt = con.prepareCall(
"{CALL PROC(?, "Literal_Value", ?)}");
cstmt.setString(1, "First");
cstmt.setString(2, "Third");
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is JDBC Savepoint? How to use it?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What is createstatement method in java?
What is CLOB and BLOB datatypes in JDBC?
What are the common jdbc exceptions?
How do we call a stored procedure from jdbc?
How many types of JDBC Drivers are present and what are they?
explain about special characters?
I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?
Describe how the jdbc application works.
What does adapter class provide?
What is jdbc in java?
What is executequery in java?
How to connect html page to database using jdbc?
What is drivermanager in jdbc?
