Java-MySQL:如何创建存储过程

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/database_name";
        String username = "username";
        String password = "password";

        try {
            Connection connection = DriverManager.getConnection(url, username, password);
            // 连接成功，可以执行后续操作
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

String createProcedureSql = "CREATE PROCEDURE my_procedure_name (IN param1 INT, OUT param2 VARCHAR(255)) " +
        "BEGIN " +
        "   -- 存储过程的具体逻辑 " +
        "   -- 可以包含各种SQL语句和控制结构 " +
        "   -- 使用param1和param2进行操作 " +
        "END";

try {
    Connection connection = DriverManager.getConnection(url, username, password);
    Statement statement = connection.createStatement();
    statement.executeUpdate(createProcedureSql);
    // 存储过程创建成功
} catch (SQLException e) {
    e.printStackTrace();
}

String callProcedureSql = "CALL my_procedure_name(?, ?)";
try {
    Connection connection = DriverManager.getConnection(url, username, password);
    CallableStatement callableStatement = connection.prepareCall(callProcedureSql);
    callableStatement.setInt(1, 123); // 设置输入参数的值
    callableStatement.registerOutParameter(2, Types.VARCHAR); // 注册输出参数的类型
    callableStatement.execute(); // 执行存储过程

    String outputValue = callableStatement.getString(2); // 获取输出参数的值
    // 处理输出参数的值
} catch (SQLException e) {
    e.printStackTrace();
}