import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Types;

public class OceanBaseCallableStatementExample {

    public static void main(String[] args) {
        try {
            // 连接到 OceanBase 数据库
            Connection connection = getConnection();

            // 调用存储过程
            callStoredProcedure(connection);

            // 关闭连接
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static Connection getConnection() throws Exception {
        // 假设 OceanBase 的 JDBC URL 为 jdbc:oracle:thin:@localhost:1521:orcl
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        String user = "your_username";
        String password = "your_password";
        return DriverManager.getConnection(url, user, password);
    }

    private static void callStoredProcedure(Connection connection) throws Exception {
        // 存储过程的调用语句
        String storedProcedureCall = "{call your_stored_procedure(?, ?, ?)}";

        try (CallableStatement callableStatement = connection.prepareCall(storedProcedureCall)) {
            // 设置输入参数
            callableStatement.setInt(1, 123);

            // 注册输出参数
            callableStatement.registerOutParameter(2, Types.VARCHAR);
            callableStatement.registerOutParameter(3, Types.INTEGER);

            // 执行存储过程
            callableStatement.execute();

            // 获取输出参数的值
            String outputParameter1 = callableStatement.getString(2);
            int outputParameter2 = callableStatement.getInt(3);

            // 处理输出参数
            System.out.println("Output Parameter 1: " + outputParameter1);
            System.out.println("Output Parameter 2: " + outputParameter2);
        }
    }
}