CallableStatement

CallableStatement cs = con.prepareCall("{call procedure_name(?, ?)}");
cs.setInt(1, value);
cs.setString(2, value);
cs.execute();

import java.sql.*;

public class Main {

  public static void main(String[] args) {

    try {

      Connection con = DriverManager.getConnection(
        "jdbc:mysql://localhost:3306/college",
        "root",
        "password"
      );

      // Calling stored procedure
      CallableStatement cs = con.prepareCall("{call getStudentById(?)}");

      cs.setInt(1, 1);

      ResultSet rs = cs.executeQuery();

      while (rs.next()) {
        System.out.println(rs.getInt("id") + " " + rs.getString("name"));
      }

      con.close();

    } catch (Exception e) {
      e.printStackTrace();
    }

  }
}

// Output:
// 1 John

• 1 Used to execute stored procedures.
• 2 Part of java.sql package.
• 3 Extends PreparedStatement.
• 4 Used for database-side logic execution.

• 1 Improves performance with stored procedures.
• 2 Enhances security.
• 3 Reduces SQL complexity in Java code.
• 4 Centralizes business logic in DB.

• 1 Stored procedures.
• 2 Functions returning values.
• 3 Procedures with input/output parameters.
• 4 Batch database operations.

• 1 CallableStatement calls stored procedures.
• 2 PreparedStatement executes SQL queries.
• 3 CallableStatement is used for DB logic.
• 4 PreparedStatement is used for CRUD operations.