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
- 14209 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
Write a program to calculate factorial in java?
How can the checkbox class be used to create a radio button?
What is a super method?
What is the difference between length and length () in java?
What are the advantages of packages in java?
What is == and === in javascript?
What about main thread in java?
What is static synchronization?
Describe how to implement singleton design pattern in struts.
What are the methods to rectify ambiguities in the interfaces in JAVA?
Which graphs are functions?
What does this mean java?
Discuss 2D arrays.
Which java version is latest?
What does serializing data mean?
