在java中映射postgresql text[]

import java.sql.*;

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

        try (Connection conn = DriverManager.getConnection(url, username, password)) {
            String[] textArray = {"text1", "text2", "text3"};

            // 创建PreparedStatement
            PreparedStatement pstmt = conn.prepareStatement("INSERT INTO mytable (text_array_column) VALUES (?)");

            // 设置text[]参数
            Array array = conn.createArrayOf("text", textArray);
            pstmt.setArray(1, array);

            // 执行SQL语句
            pstmt.executeUpdate();

            System.out.println("插入成功");

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}