打印我的 HQL：@Query("SELECT count(a.age) as age, count(w.weight) as weight from animals a inner join weight_table w on a.id = w.id")我想將其返回為： List<MyObject>而不是List<Object[]>我有這門課：public class MyObject { private int age; private int weight; // getters setters all args constructor}是否可以使用如下方式在我的 HQL 中進行轉(zhuǎn)換：SELECT new.com.cs.MyObject(age, weight) count(a.age) as age, count(w.weight) as weight from animals a inner join weight_table w on a.id = w.id
2 回答
紅顏莎娜
TA貢獻1842條經(jīng)驗 獲得超13個贊
您可以使用投影：
@Query("SELECT count(a.age) as age, count(w.weight) as weight from animals a inner join weight_table w on a.id = w.id")
public List<MyObject> myMethodNameDescribingFunctionality();
其中MyObject可能是一個接口：
public interface MyObject {
? ? @Value("#{target.age}")
? ? int age();
? ? @Value("#{target.weight}")
? ? int weight;
}
守著一只汪
TA貢獻1872條經(jīng)驗 獲得超4個贊
為了使用自定義類，我首先使用為這些屬性創(chuàng)建一個構(gòu)造函數(shù)
public class MyObject {
private int age;
private int weight;
public MyObject(int age , int weight) {
this.age=age;
this.weight = weight;
}
}
之后，在 hql 中你可以按照相同的值順序調(diào)用這個構(gòu)造函數(shù)
@Query("SELECT new com.packagename.MyObject(count(a.age), count(w.weight)) from animals a inner join weight_table w on a.id = w.id")
您將從 MyObject 對象返回一個列表
添加回答
舉報
0/150
提交
取消