Stored procedure OUT parameter example using CallableStatement

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 CallableStatement

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:                

Create table using JDBC PreparedStatement API

Program to create a table in oracle database using JDBC’s java.sql.PreparedStatement API.

 Output:

 In Database: Log-in to SQL-PLUS with user name/password and see whether the EMPLOYEE table is created or not.                  

Batch update example using JDBC Statement API

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

 Output:

 In Database:                  

Get table records using JDBC Statement API

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

 Output:

 In Database: