使用Eclipse链接从存储过程获取输出参数

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

public class StoredProcedureExample {
    public static void main(String[] args) {
        try {
            // 1. 连接到数据库
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 2. 创建CallableStatement对象
            CallableStatement callableStatement = connection.prepareCall("{call my_stored_procedure(?, ?)}");

            // 3. 设置输入参数的值（如果有）
            callableStatement.setString(1, "input_value");

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

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

            // 6. 获取输出参数的值
            String outputValue = callableStatement.getString(2);

            // 7. 处理输出参数的值
            System.out.println("Output value: " + outputValue);

            // 8. 关闭连接和Statement对象
            callableStatement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}