Thursday, 6 September 2012

To execute a stored procedure “totalStock” in a database server, which of the following code snippet is used? | JDBC

A.     Statement stmt = connection.createStatement();stmt.execute("totalStock()");
B.     CallableStatement clbstmnt = con.prepareCall("{call totalStock}");cs.executeQuery();
C.     StoreProcedureStatement spstmt = connection.createStoreProcedure("totalStock()");spstmt.executeQuery();
D.     PrepareStatement pstmt = connection.prepareStatement("totalStock()");pstmt.execute();

Ans:  B

No comments: