java - 查询新的对象列表

Question

我需要一些查询来获取新对象。我的结果对象是:

@Getter
@Setter
@NoArgsConstructor
public class MegrendelesNap {

    int year;
    int ora;

    public MegrendelesNap(int year, int ora) {
        this.year = year;
        this.ora = ora;
    }
}

所以我需要在构造函数中获取两个整数。在界面中我创建了一个查询:

 @Query("select new hu.langos.domain.MegrendelesNap(" +
            "FUNCTION('YEAR',d.datum), sum(d.ora) " +
            ") from Dolgozoora  d where d.megrendeles.id =:myid group by function('YEAR',d.datum)")
    List<MegrendelesNap>getMegredelesNapok(Long myid);

但是，当我运行程序时，出现此错误:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [hu.langos.domain.MegrendelesNap]. Expected arguments are: int, long

我该如何解决这个问题？谢谢。

Answer 1

整数的和不是整数!整数之和返回 LONG!!