what r callable statement and give their proper use
Answer Posted / prajal
Callable statement (java.sql.CallableStatement) are used for
calling a Stored Procedure.
Syntax is as below-
//prepare a procedure call
String procedureCall="call testProcedure(:1,:2,:3)";
//prepare a callable statement
CallableStatement
cStmt=connectionObject.prepareCall(procedureCall);
// Set the Input Parameters to the procedure
cStmt.setInt(1, testID);
cStmt.setInt(2, testNumber);
// Register Output Parameters
cStmt.registerOutParameter(3, Types.VARCHAR);
// Execute the Callable Statement
cStmt.execute();
// Resulting Values from the Callable Statement is assigned
to the Message variable
String message = cStmt.getString(3);
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of lambda expressions?
What is the default value of local and global variables?
what is the difference between the methods sleep() and wait()? : Java thread
what do you understand by synchronization? : Java thread
What is the difference between comparison done by equals method and == operator?
What is an empirical question?
When does an object becomes eligible for garbage collection in java?
Are global variables initialized to zero?
What does this () mean in constructor chaining concept?
Explain the difference between an Interface and an Abstract class?
What is qms certification?
Why java does not support pointers?
Can you add null to a list java?
What is the use of generics? When was it added to the Java development Kit?
What is the same as procedures?