hibernate in List查询条件 sum求和使用参考
@Overridepublic Integer getSumZongShuByidList(List<String>idList){
Integer zongshu= 0;
String hql="SELECT sum(zongshu) from Tab where id in (:idList)";
Query query=this.getSession().createQuery(hql);
query.setParameterList("idList", idList);
Long queryZongShu=(Long)query.uniqueResult();if(queryZongShu!=null){
zongshu=Integer.parseInt(queryZongShu.toString());
}returnzongshu;
}