如何使用java sql将数组传递给IN参数并从OUT参数中检索数组

CREATE PROCEDURE retrieveArray(IN inputArray VARCHAR(255), OUT outputArray VARCHAR(255))
BEGIN
  -- 解析输入的数组字符串
  DECLARE arrayValues VARCHAR(255);
  SET arrayValues = REPLACE(inputArray, ',', "','");
  
  -- 查询并将结果存储在OUT参数中
  SET @query = CONCAT('SELECT column_name FROM table_name WHERE column_name IN (''', arrayValues, ''')');
  PREPARE stmt FROM @query;
  EXECUTE stmt INTO outputArray;
  DEALLOCATE PREPARE stmt;
END

import java.sql.*;

public class ArrayParameterExample {
  public static void main(String[] args) {
    try {
      // 连接数据库
      Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/database_name", "username", "password");
      
      // 准备调用存储过程的SQL语句
      String sql = "{CALL retrieveArray(?, ?)}";
      
      // 创建CallableStatement对象
      CallableStatement stmt = conn.prepareCall(sql);
      
      // 创建输入参数数组
      String[] inputArray = {"value1", "value2", "value3"};
      String inputArrayStr = String.join(",", inputArray);
      
      // 设置输入参数
      stmt.setString(1, inputArrayStr);
      
      // 注册输出参数
      stmt.registerOutParameter(2, Types.VARCHAR);
      
      // 执行存储过程
      stmt.execute();
      
      // 获取输出参数
      String outputArrayStr = stmt.getString(2);
      String[] outputArray = outputArrayStr.split(",");
      
      // 输出结果
      for (String value : outputArray) {
        System.out.println(value);
      }
      
      // 关闭连接
      stmt.close();
      conn.close();
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
}