hql.append("SELECT NEW com.coscon.cbs.domain.result.settlement.SettlementCommissionSumDetailResult(companys.companyNameCn,commCntr.containerSizeType,");
hql.append(" companyChargeCode.settlementChargeCodeDescription,");
hql.append(" commCntr.commissionCurrencyCode,");
hql.append(" COUNT(*),SUM(commCntr.commissionAmount))");
hql.append(" FROM com.coscon.cbs.domain.model.settlement.SettlementHead settlementHead,");
注意这里的 COUNT 的类型要写成.Long 或 int ,因为数据库自动生成的number字段,对应的是 BigDecimal,所以我在定制结果集
的时候也写成了.BigDecimal 不应该啊,
List<Object[]> list = querys.list();
for (Object[] objects : list) {
String name1 = (String)objects[0];
String name2 = (String)objects[1];
String name3 = (String)objects[2];
String name4 = (String)objects[3];
Long name5 = (Long)objects[4];
BigDecimal name6 = (BigDecimal)objects[5];
}
// return querys.list();
return list;
后来通过遍历结果集的时候,才发现类型转换异常.. 这次写下来是为了加深一下印象.
public SettlementCommissionSumDetailResult(String companyNameCn,
String containerSizeType, String settlementChargeCodeDescription,
String commissionCurrencyCode, Long containerNumbers,
BigDecimal commissionAmounts) {
this.companyNameCn = companyNameCn;
this.containerSizeType = containerSizeType;
this.settlementChargeCodeDescription = settlementChargeCodeDescription;
this.commissionCurrencyCode = commissionCurrencyCode;
this.containerNumbers = containerNumbers;
this.commissionAmounts = commissionAmounts;
}
以后不要再犯类似的错误了..
org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.coscon.cbs.domain.result.settlement.SettlementCommissionSumDetailResult
出现这种错误在定制结果集的时候 无非就这么几种情况..
1.在写New后面的字段()里边的字段的个数和他们对应的类型,要和结果集的字段相对应.(不多不少)
2.注意","号不漏了..注意好细节..
只要认真检查一下. 问题是可以很快的解决的..
在开发的过程中我看到了一篇关于 hibernate HQL的总结 好帖子
http://kuangbaoxu.iteye.com/blog/193076 总结的很不错哦~~~