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
- 14241 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 a consumer in java?
What is Java Package and which package is imported by default?
Explain the reason behind ending a program with a system.exit(0)?
Write a method to check if input string is palindrome?
Can we create more than one object singleton class?
Where are variables stored?
What is parsing and its types?
What is the use of using enum to declare a constant?
What is pojo class in java?
What is dot operator?
what is difference between equals and ==?
Can finally block be used without a catch?
When is the arraystoreexception thrown?
What is a boolean expression in java?
What is an abstract class and what is it’s purpose?
