如何将 JPQL 查询分配给简单的 Java 对象？

Question

我需要将 jpql 结果的结果分配给一个简单的类 java 对象

我有这样的东西

class myObject() {
@id
private Long id;
private String Name;
private String description;
...
//getters and setters
}

我需要以某种方式存储此 SQL 查询的结果，例如

// 可以是 anytable SELECT DISTINCT c.table_id, c.name, NULL AS description FROM anyTable

如何在 JPQL 中执行此操作，然后将结果分配给我的对象？

Answer 1

这个问题非常不清楚。所以这是一个模糊的答案：

EntityManagerFactory emf = Persistence.createEntityManagerFactory("MyPu");
EntityManager em = emf.createEntityManager();    
Query q = em.createQuery("select f.id, f.name from Foo f");
List<Object[]> foos = (List<Object([]>)q.getResultList();

MyObject o = new MyObject();
o.setFoos(foos);

Answer 2

我想，这就是答案！

SELECT NEW entities.PersonWell(c.peopleId, c.name, c.age, c.height, c.weight)
FROM 
  People AS c;

它是Entity.PersonWell类的构造函数：

public PersonWell(Integer peopleId, String name, short age, short height, short weight, short speechspeed) {
        this.peopleId = peopleId;
        this.name = name;
        this.age = age;
        this.height = height;
        this.weight = weight;
        this.speechspeed = speechspeed;
    }

有一些用于提取结果的代码：

List<PersonWell> resultList = query.getResultList();

我希望，它会对您有所帮助！ :)