Question

hibernate sql 语句查询 sum() ,count,max,min 怎么用

 Query query = super.getSession().createSQLQuery(" select count(*) from Rrplenish ");      System.out.println(query.list().size());或者，  sum(pid)查询不出来，写的ssh项目 ，这个写在hibernate dao 里面的 怎么不能查询哎，  select * from 表 就可以查询  ，

Answer 1

session.createQuery("select max(m.id), min(m.id), avg(m.id), sum(m.id) from Msg m
session.createQuery("select t.title, count(*) from Topic t group by t.title having count(*) >= 1");

Answer 2

你要把实体加进去吧
Query query = super.getSession().createSQLQuery(" select count(*) from Rrplenish ");

query.addEntity(实体.class)