How to call a Stored Procedure from JDBC?
Submitted by: AdministratorThe first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure;
E.g.
CallableStatement cs = con.prepareCall(”{call SHOW_SUPPLIERS}”);
ResultSet rs = cs.executeQuery();
Submitted by: Administrator
E.g.
CallableStatement cs = con.prepareCall(”{call SHOW_SUPPLIERS}”);
ResultSet rs = cs.executeQuery();
Submitted by: Administrator
Read Online JDBC Job Interview Questions And Answers
Top JDBC Questions
| ☺ | How can you load the drivers in JDBC? |
| ☺ | What are the two major components of JDBC? |
| ☺ | How can you create JDBC statements? |
| ☺ | How to Make Updates to Updatable Result Sets in JDBC? |
| ☺ | What are the different types of Statements in JDBC? |
Top Java Programming Language Categories
| ☺ | Core Java Interview Questions. |
| ☺ | Hibernate Interview Questions. |
| ☺ | Advanced Java Interview Questions. |
| ☺ | IBM WebSphere Interview Questions. |
| ☺ | Spring Framework Interview Questions. |
