Call a Stored Procedure using Java JDBC CallableStatement Example


Java JDBC CallableStatement to call Stored Procedure Example
MySQL Stored Procedure:
DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `my_stored_proc`()
BEGIN
   Select count(*) from my_table;
END$$
DELIMITER ;

Java Code:
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JdbcStoredProcedureExample {
    
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
    
        String url ="jdbc:mysql://localhost:3306/my_uat";
        String userName="root";
        String password ="root123";

        Connection connection = DriverManager.getConnection(url,userName,password);
        //Create the stored procedure call as a String
        String call="call my_stored_proc()";
        
        //Prepare CallableStatement
        CallableStatement callableStatement = connection.prepareCall(call);
    
        //Execute and fetch resultSet
        ResultSet resultSet = callableStatement.executeQuery();
        
        //Converting resultSet to ArrayList
        while(resultSet.next()) {
            System.out.println(resultSet.getInt(1));
        }
    
    }
}
Output: 3
-

Facing issues? Have Questions? Post them here! I am happy to answer!


Author Info:

Rakesh (He/Him) is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap