Interested to Buy Any Domain ? << Click Here >> for more details...
What is actual difference between statement,prepared
statement and callable statement and when we have to use it?
pls post a answer with code and clear explanation. thanks
- 2 Answers
- 14296 Views
- I also Faced
- E-Mail Answers
Answer Posted / aravind
Statement:
When you use normal statements compilation of statement or
parsing of statement will happen everytime. This is time
cosuming when u have mutliple queries to execute.
Statemtn s = conn.createStatement();
s.executeQuery();
Prepared Statement:
In prepared statement SQL query will be compiled or parsed
for the very first time and kept in some kind of pool. When
u execute one more time the same statement with different
values it saves the parsing time.
SQL select * from employee where employeeID=?,empName=?;
PreparedStatement ps = conn.PreparedStatement();
ps.execute(1,aru);
ps.execute(2,arya);
Callable Statement:
Callable statements are used to execute stored procedures
similar to java functions.
| Is This Answer Correct ? | 44 Yes | 5 No |
Post New Answer View All Answers
What is multi-catch block in java?
What do you mean by hashing?
What are the advantages of exception handling in java?
how to handle exceptions in ejb?
What is the difference between array list and vector in java?
Does importing a package imports its sub-packages as well in java?
What is jee6?
Explain wrapper classes in java?
What is the difference between class & structure?
What are the ways in which a thread can enter the waiting state?
How can we create an immutable class in java?
What is a void in java?
What is the difference between double and float variables in java?
What is toarray method in java?
Which is better 64 bit or 32 bit?
