JDBC Tutorial #12 : Passing Paramaters to Stored Procedures

This video explains how to invoke Stored Procedures having IN paramameters using CallableStatement. A stored procedure is a subroutine available to applications that access a relational database management system . Such procedures are stored in the database data dictionary. Callable statements allows to invoke these stored procedures. CallableStatements created using prepareCall(String call) from . The parameter is of the following form = {call function_name(?)} = This tutorial series covers following topics ■ Connecting Java Program to MySQL Database ■ Inserting data into database ■ Fetching data from database ■ Updating an entry in database ■ Deleting an entry from database ■ Creating a table programmatically ■ Using PreparedStatements ■ Display database contents in JTable ■ Calling stored procedures ■ JDBC Batch operations