如何在jpa仓库中使用jsonb_set来传递动态字符串？

// 实体类
@Entity
@Table(name = "your_table")
public class YourEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(columnDefinition = "jsonb")
    private String yourJsonbColumn;

    // 省略其他属性和方法
}

// JPA仓库接口
@Repository
public interface YourRepository extends JpaRepository<YourEntity, Long> {
    @Query(value = "UPDATE your_table SET your_jsonb_column = jsonb_set(your_jsonb_column, :path, :value) WHERE id = :id", nativeQuery = true)
    void updateJsonbColumn(@Param("id") Long id, @Param("path") String path, @Param("value") String value);
}

// 使用示例
@Service
public class YourService {
    @Autowired
    private YourRepository yourRepository;

    public void updateJsonbColumn(Long id, String path, String value) {
        yourRepository.updateJsonbColumn(id, path, value);
    }
}