Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



Why is prepared Statement, Callable Statement used for? What is the need of Batch updates?..

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

Post New Answer

More Core Java Interview Questions

What is variable explain with example?

0 Answers  


What is a line separator in java?

0 Answers  


what ide u r using and wat version, how wil u build the project etc ?

2 Answers  


we know that every java prog must follows OOPS Principles. Anybody can answer, HOW THE FOLLOWING PROGRAM FOLLOWS OOPS CONCEPTS i.e, Inheritance,Polymarphism,Encapsulation? class a{ public static void main(String args[]){ System.out.println("Hello World"); } }

3 Answers  


Why java is secure? Explain.

0 Answers  


What is string value?

0 Answers  


Whats the difference between notify() and notifyall()?

0 Answers  


What is difference between arraylist and list in java?

0 Answers  


in a console we r giving java <class name> if r pressing enter where it'll goes

2 Answers   CSC,


Why do we need strings in java?

0 Answers  


Name the method that used to clear the buffer ?

2 Answers  


Is there any difference between synchronized methods and synchronized statements?

0 Answers  


Categories