从Java调用存储过程

import java.sql.*;

public class CallStoredProcedure {
    public static void main(String[] args) {
        try {
            // 建立数据库连接
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");
            
            // 准备调用语句
            String sql = "{call my_stored_procedure(?, ?)}";
            CallableStatement stmt = conn.prepareCall(sql);
            
            // 设置参数
            stmt.setInt(1, 123);
            stmt.registerOutParameter(2, Types.VARCHAR);
            
            // 执行存储过程
            stmt.execute();
            
            // 处理结果
            String result = stmt.getString(2);
            System.out.println("Result: " + result);
            
            // 关闭连接
            stmt.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}