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
- 14204 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sudha
Prepared statement is precompiled statement it is used when
we want one query to be executed n no. of times.
whereas callablestatement is used to call stored procedures
| Is This Answer Correct ? | 41 Yes | 3 No |
Is a class subclass of itself?
What does || mean in code?
What is the difference(or similarity if there are some) between object and a variable?
How variables are stored in memory?
How to do a true java ping from windows?
Difference between static and dynamic class loading.
How can we use primitive data types as objects?
public class Test { public static void main(String[] args) { int countA = 0; int countB = 0; int countC = 0; int countD = 0; int countE = 0; int countF = 0; int countG = 0; int countH = 0; int countI = 0; int countJ = 0; int countK = 0; int countL = 0; int countM = 0; int countN = 0; int countO = 0; int countP = 0; int countQ = 0; int countR = 0; int countS = 0; int countT = 0; int countU = 0; int countV = 0; int countW = 0; int countX = 0; int countY = 0; int countZ = 0; } } Can anybody tell me any alternate solution(like loop or something) to automate this initialization process. Ex:- for(char chr='A';chr<='Z'; chr++) { (int) String "count"+chr = 0; }
What is the best way to findout the time/memory consuming process?
Can a string be null?
Is 0 true or is 1 true?
Is main a keyword in java?
Core Java 
