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 jdbc faster than hibernate?

999

---

explain about special characters?

976

---

What is jdbc driver?

906

---

What are the different types of statements? How we can you use preparedstatement.

965

---

Is jdbc secure?

981

---

Why do you use a data source object for a connection?

1030

---

What is the use of dialect?

1014

---

What is isolation level? How to set it?

2214

---

What is executequery in java?

894

---

What is sqlwarning?

1015

---

How the JDBC application works?

951

---

Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?

900

---

Does sql allow null values ?

973

---

What is the difference between setmaxrows(int) and setfetchsize(int)?

1059

---

Which interface is responsible for transaction management in jdbc?

1023

---