将数组传递给JDBC中的postgres

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

public class ArrayExample {
    public static void main(String[] args) {
        String url = "jdbc:postgresql://localhost:5432/mydatabase";
        String user = "myuser";
        String password = "mypassword";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String sql = "INSERT INTO mytable (id, values) VALUES (?, ?)";
            try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
                pstmt.setInt(1, 1);

                // 创建一个Java数组
                String[] javaArray = {"value1", "value2", "value3"};

                // 将Java数组转换为PostgreSQL数组
                Array postgresArray = conn.createArrayOf("text", javaArray);

                // 设置参数
                pstmt.setArray(2, postgresArray);

                // 执行SQL语句
                pstmt.executeUpdate();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}