JDBC Tutorial for Beginners #11 : Calling Stored Procedures with CallableStatements
15 هزار بار بازدید -
8 سال پیش
-
This video explains how to
This video explains how to invoke Stored Procedures using the interface java.sql.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 java.sql.Connection. 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
- Genuine Coder
http://www.genuinecoder.com/
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 java.sql.Connection. 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
- Genuine Coder
http://www.genuinecoder.com/
8 سال پیش
در تاریخ 1395/12/06 منتشر شده
است.
15,036
بـار بازدید شده