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 the reason why we need a jdbcrowset like the wrapper around resultset?
What is difference between odbc and jdbc?
Is jdbc an api?
What is jdbc driver manager?
What are types of jdbc drivers?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
State the three different ways in which you can create a table?
Write an sql to find all records having all upper case alphanumeric characters in a field ?
How are jdbc statements used?
Explain about multiple implementations and drive manager?
What is jdbc driver in java?
What is use of connection pooling?
Can we have foreign key reference to a non primary key column ?
Does jpa use jdbc?
What do you mean by odbc?
