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 retrieve data from the ResultSet using JDBC? |
| ☺ | How to Make Updates to Updatable Result Sets in JDBC? |
| ☺ | What are the common tasks of JDBC? |
| ☺ | What are the steps involved in establishing a connection using JDBC in JAVA? |
| ☺ | How can you make the connection using 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. |
