Breaking News: Grepper is joining You.com. Read the official announcement!

ava program to use Callable Statement in Java to call Stored Procedure

Anjali Sharma answered on January 3, 2023 Popularity 1/10 Helpfulness 1/10

answer ava program to use Callable Statement in Java to call Stored Procedure

ava program to use Callable Statement in Java to call Stored Procedure

Comment

// Java program  to use Callable Statement
// in Java to call Stored Procedure
 
package javaapplication1;
 
import java.sql.*;
 
public class JavaApplication1 {
 
    public static void main(String[] args) throws Exception
    {
        Class.forName("com.mysql.jdbc.Driver");
       
        // Getting the connection
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/root", "acm", "acm");
       
        String sql_string = "insert into students values(?,?,?)";
       
        // Preparing a CallableStateement
        CallableStatement cs = con.prepareCall(sql_string);
       
        cs.setString(1, "geek1");
        cs.setString(2, "python");
        cs.setString(3, "beginner");
        cs.execute();
        System.out.print("uploaded successfully\n");
    }
}

Popularity 1/10 Helpfulness 1/10 Language java

Source: www.geeksforgeeks.org

Tags: ava call callable-statement java procedure

Link to this answer
Share Copy Link