如何使用Jpa.unsafe对postgresql中的json字段进行排序

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "your_table_name")
public class YourEntity {
    @Id
    private Long id;

    @Column(columnDefinition = "json")
    private String jsonField;

    // 其他属性和方法...
}

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

@Repository
public interface YourEntityRepository extends JpaRepository<YourEntity, Long> {
    @Query(value = "SELECT * FROM your_table_name ORDER BY jsonField->>'your_json_key' ASC", nativeQuery = true)
    List<YourEntity> findAllOrderByJsonField(@Param("your_json_key") String jsonKey);
}