String sql="select Meeting_Room_Guid, Meeting_Room_Name,"+
"CONCAT('aaaa',cast(sum(case when Begin_Time between 1437408000000 and 1537408000000 and meeting_type=10 then 1 else 0 end) as CHAR),'个',"+
"'bbbb',cast(sum(case when Begin_Time between 1437408000000 and 1537408000000 and meeting_type=20 then 1 else 0 end) as CHAR),'个') as A "+
"from cccc group by Meeting_Room_Guid";
SQLQuery query = getSession().createSQLQuery(sql.toString());
List<Object[]> list= query.list();
如上面的语句,如果 concat中有 字符串和数字,hibernate中 查询返回值 就有问题
需要将其中的数字 cast一下,然后concat就ok了。