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
- 14321 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
How can we make sure main() is the last thread to finish in java program?
Is null keyword in java?
Which package is imported by default?
When can you say a graph to be a tree?
What is boolean law?
How do you use wildcards?
Does A Class Inherit The Constructors Of Its Superclass?
What is the difference between double and float variables in java?
What is abstract class? Explain
What are 5 boolean operators?
Explain the difference between abstract class and interface in java?
What does the @override annotation do?
Explain parallel processing in java8?
how to know the total memory occupied by the objects in the ArrayList(Array list may contain duplicate objects)
What is the difference between throw and throws keywords?
