Question

Hibernate Dao查询出个问题

public String[] getBillMess(long shopid,String startdate,String enddate){
String[] bill = null;
try {
Session session = null;
session = this.getSession();
String hql = "select sum(c.consmoney),sum(c.reward) " +
"from Consume c " +
"where c.shopid in (select s.shopid " +
"from Shop s " +
"where s.parentshopid = ?) and " +
"c.paytype = '1' and c.consdate between ? and ? and returncode='0000'";
Query query = session.createQuery(hql);
query.setLong(0, shopid);
query.setString(1, startdate);
query.setString(2, enddate);
List<String[]> list = query.list();
System.out.println(list.size());
if(list.size()!=0){
bill = list.get(0);
}
} catch (Exception e) {
e.printStackTrace();
}
return bill;
}

bill = list.get(0);
这句居然会抛异常，后面跟前面都是String[]类型阿，郁闷阿。怎么解决?

Answer 1

首先我认为，你查询出来的两个字段应该封装成一个对象，然后再取出来，这样比较保守，但不容易出错，我感觉，查出来的虽然是个集合，而你也让集合里放了String[]，不知道你出的错是不是类型转换异常

Answer 2

Query query = session.createNativeQuery(hql);

Answer 3

那句有异常？最可能是你的HQL有问题

Answer 4

我支持一楼的看法 是应该把结果封装到POJO里面去 这样就不会出现类型转换问题