Use select count (*) or sum (filed_name) in hibernate )!

Use sqlquery in hibernate to query select count () or select sum (filed_name)

The returned result is of the biginteger type.

However, these cannotForced conversionIt is of the object or Integer type.

It's really troublesome!

However, biginteger contains the invalue () method.

You can convert it to the int type by yourself.

AllCode!

 

Long result = (integer%this.gethibernatetemplate(cmd.exe cute (New hibernatecallback () {public object doinhibernate (session) throws hibernateexception, sqlexception {sqlquery query = session. createsqlquery (hql); biginteger bigval = (biginteger) query. list (). get (0); int val = bigval. intvalue (); Return Val ;}});