Scala将数组作为参数传递给Postgres jdbc sql语句

import java.sql.{Connection, DriverManager, PreparedStatement}

// 加载PostgreSQL的JDBC驱动程序
Class.forName("org.postgresql.Driver")

// 建立数据库连接
val url = "jdbc:postgresql://localhost:5432/mydatabase"
val username = "myusername"
val password = "mypassword"
val connection: Connection = DriverManager.getConnection(url, username, password)

// 定义SQL语句和占位符
val sql = "SELECT * FROM mytable WHERE column = ANY (?)"
val statement: PreparedStatement = connection.prepareStatement(sql)

// 将数组作为参数传递给SQL语句
val arrayParam: Array[String] = Array("value1", "value2", "value3")
statement.setArray(1, connection.createArrayOf("text", arrayParam))

// 执行SQL查询
val resultSet = statement.executeQuery()

// 处理查询结果
while (resultSet.next()) {
  // 处理每一行的数据
}

// 关闭连接和资源
resultSet.close()
statement.close()
connection.close()