Hibernate将Postgres数据库中现有的Integer[]转换为String[] (bytea)

@Entity
@Table(name = "your_table_name")
public class YourEntity {
    // Other properties
    
    @Column(columnDefinition = "integer[]")
    private Integer[] yourArray;
    
    // Getters and setters
}

<hibernate-configuration>
    <session-factory>
        <!-- Other configurations -->
        
        <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
        <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
        <property name="hibernate.connection.url">jdbc:postgresql://your_database_url</property>
        <property name="hibernate.connection.username">your_username</property>
        <property name="hibernate.connection.password">your_password</property>
        
        <!-- Other configurations -->
    </session-factory>
</hibernate-configuration>

// Create a new entity object
YourEntity entity = new YourEntity();
entity.setYourArray(new Integer[]{1, 2, 3});

// Save the entity to the database
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
session.save(entity);
transaction.commit();
session.close();

// Retrieve the entity from the database
session = sessionFactory.openSession();
YourEntity retrievedEntity = session.get(YourEntity.class, entityId);
session.close();

// Convert the Integer[] to String[] (bytea)
String[] yourArrayAsString = Arrays.stream(retrievedEntity.getYourArray())
        .map(String::valueOf)
        .toArray(String[]::new);