Interested to Buy Any Domain ? << Click Here >> for more details...
Why is prepared Statement, Callable Statement used for? What
is the need of Batch updates?
- 1 Answers
- 13792 Views
- Logica CMG, I also Faced
- E-Mail Answers
Answer / chaitanya
The main feature of a PreparedStatement object is that,
unlike a Statement object, it is given an SQL statement
when it is created. The advantage to this is that in most
cases, this SQL statement is sent to the DBMS right away,
where it is compiled. As a result, the PreparedStatement
object contains not just an SQL statement, but an SQL
statement that has been precompiled. This means that when
the PreparedStatement is executed, the DBMS can just run
the PreparedStatement SQL statement without having to
compile it first.
Callable Statement:A CallableStatement object provides a
way to call stored procedures in a standard way for all
DBMSs. A stored procedure is stored in a database; the call
to the stored procedure is what a CallableStatement object
contains. This call is written in an escape syntax that may
take one of two forms: one form with a result parameter,
and the other without one. A result parameter, a kind of
OUT parameter, is the return value for the stored
procedure. Both forms may have a variable number of
parameters used for input (IN parameters), output (OUT
parameters), or both (INOUT parameters). A question mark
serves as a placeholder for a parameter
BatchUpdates:
A batch update is a set of multiple update statements that
is submitted to the database for processing as a batch.
Sending multiple update statements to the database together
as a unit can, in some situations, be much more efficient
than sending each update statement separately. This ability
to send updates as a unit, referred to as the batch update
facility, is one of the features provided with the JDBC 2.0
API.
| Is This Answer Correct ? | 36 Yes | 3 No |
Which java collection does not allow null?
Does java map allow duplicates?
What is final keyword?
Q) I have a ArrayList object, in that object i have added 5 integer values, 5 float values, 5 string values. Now question is how can delete particular type of data ( i.e all int values or all float values or string values) in that list object at a time?
Can private method static?
what is the difference between preemptive scheduling and time slicing? : Java thread
what is d difference between deep cloning and shallow cloning in core java?
I need some details about an employee. i have only the employee id in my presentation layer(JSP).I entered that ID and click "Show Details" Button. Question is how the JSP pass that id to Controller layer and DAO and what mechanism we are using to retrive data from DB and how the data passed to JSP as a Output. Please explain in detail.
What are the topics in advance java?
Which is the best way to use for String concatenation in Java?
Can a constructor be private and how are this() and super() method used with constructor?
0 Answers Flextronics, Hexaware,
I have a string like _a01_a02_a03_ and another string like _2_1.5_4_ as input.I want to extract a01,a02... to a string array and 2,1.5,etc to a double array with a01 corresponds to 2 and a02 to 1.5 etc. Need code in core java.. Can you do it?
Core Java 
