在带有Hibernates @Formula注释的查询中使用实体的值

@Entity
@Table(name = "my_table")
public class MyEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "name")
    private String name;

    @Column(name = "age")
    private int age;

    @Formula("age * 2")
    private int doubleAge;

    // Getters and setters
}

// 在查询中使用实体的值
String queryString = "SELECT e.name, e.doubleAge FROM MyEntity e WHERE e.name = :name";
Query query = entityManager.createQuery(queryString);
query.setParameter("name", "John");
List<Object[]> results = query.getResultList();

for (Object[] result : results) {
    String name = (String) result[0];
    int doubleAge = (int) result[1];
    System.out.println("Name: " + name + ", Double Age: " + doubleAge);
}