您的查询返回的是一个
Object[]而不是
GraphDtoObject 的数组,您可以通过多种方式解决此问题:
解决方案1
创建持有一个构造函数
daydate,
value1,
value2
@Entitypublic class GraphDto{ private Date daydate; private Long value1; private Long value2; public GraphDto(Date daydate, Long value1, Long value2){ //... } //..getters and setters}那么您的查询应如下所示:
SELECt NEW com.packagename.GraphDto(cast(creationDate AS date), SUM(paymentValue), fxRate)FROM paymentGROUP BY cast(creationDate AS date)
解决方案2
将返回类型更改为:
List<Object[]> findPaymentValuePerDay ();
然后在服务中遍历此对象并提取值:
List<Object[]> listObject = rep.findPaymentValuePerDay();for(Object[] obj : listObject){ Date date = (Date) obj[0]; Long value1 = (Long) obj[1]; Long value2 = (Long) obj[2];}


