String sql ="select SUM(nf.fee) from CFee as nf where nf.adminAccount='testaccount' "; publiclong getListSqlCountsLong(String sql) { beginTransaction(); List li = getSession().createQuery(sql).list(); if (li ==null|| li.isEmpty()) { return0; }else{ return ((Integer) li.get(0)).longValue(); } }
String sql ="select SUM(nf.fee) from CFee as nf where nf.adminAccount='testaccount' "; publiclong getListSqlCountsLong(String sql) { beginTransaction(); List li = getSession().createQuery(sql).list(); if (li ==null|| li.isEmpty()) { return0; }else{ if (li.get(0) ==null) { return0; } return ((Integer) li.get(0)).longValue(); } }