如何使用jpa (hibernate)从表中仅选择postgres jsonb列

import org.hibernate.annotations.Type;
import com.vladmihalcea.hibernate.type.json.JsonBinaryType;

@Entity
@Table(name = "your_table")
public class YourEntity {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Type(type = "jsonb")
    @Column(columnDefinition = "jsonb")
    private String jsonbColumn;

    // Getters and setters
}

<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_2.xsd"
             version="2.2">

    <persistence-unit name="yourPersistenceUnit" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
        <class>com.example.YourEntity</class>
        <properties>
            <property name="javax.persistence.jdbc.url" value="jdbc:postgresql://your_host:your_port/your_database"/>
            <property name="javax.persistence.jdbc.user" value="your_username"/>
            <property name="javax.persistence.jdbc.password" value="your_password"/>
            <property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver"/>
            <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
        </properties>
    </persistence-unit>

</persistence>

import javax.persistence.EntityManager;
import javax.persistence.Persistence;
import javax.persistence.Query;
import com.example.YourEntity;

public class Main {

    public static void main(String[] args) {
        EntityManager entityManager = Persistence.createEntityManagerFactory("yourPersistenceUnit")
                .createEntityManager();

        // 使用JPQL查询
        Query query = entityManager.createQuery("SELECT e.jsonbColumn FROM YourEntity e");
        List<String> jsonbColumns = query.getResultList();

        // 使用原生SQL查询
        Query nativeQuery = entityManager.createNativeQuery("SELECT jsonb_column FROM your_table");
        List<String> jsonbColumnsNative = nativeQuery.getResultList();

        // 打印结果
        for (String jsonbColumn : jsonbColumns) {
            System.out.println(jsonbColumn);
        }
    }
}