Stored procedure Cursor example using JDBC CallableStatement API

Program to call database stored procedure using JDBC’s java.sql.CallableStatement API and get OUT Parameter as CURSOR. Stored Procedure in Oracle database:

Java class:

Output:

 In Database:                  

Stored procedure OUT parameter example using JDBC CallableStatement API

Program to call database stored procedure using JDBC’s java.sql.CallableStatement API and pass IN and OUT parameters to stored procedure. Stored Procedure in Oracle database:

Java class:

 Output:

In Database:                  

Stored procedure IN Parameter example using JDBC CallableStatement API

Program to call database stored procedure using JDBC’s java.sql.CallableStatement API and pass IN parameters to stored procedure. Stored Procedure in Oracle database:

 Java class:

 Output:

 In Database:                  

Batch update example using JDBC PreparedStatement API

Program to insert many records in a table using JDBC’s java.sql.PreparedStatement API

 Output:

 In Database:              

Get table records using JDBC PreparedStatement API

Program to get table records using JDBC’s java.sql.PreparedStatement API.

 Output:

 In Database:              

Delete a record in a table using JDBC PreparedStatement API

Program to delete a record in a table using JDBC’s java.sql.PreparedStatement API.

 Output:

 In Database:              

Update table data using JDBC PreparedStatement API

Program to update table data using JDBC’s java.sql.PreparedStatement API.

 Output:

 In Database:                

Insert rows into a table using JDBC PreparedStatement API

Program to insert rows into a table using JDBC’s java.sql.PreparedStatement API.

 Output:

In Database: