jdbc

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:                  

jdbc

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:                  

jdbc

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:                  

jdbc

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:              

java-logo

Get table records using JDBC PreparedStatement API

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

 Output:

 In Database:              

java-logo

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:              

java-logo

Update table data using JDBC PreparedStatement API

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

 Output:

 In Database:                

java-logo

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: