由于Hibernate3.2.5版本的(select count(*))查询返回的结果是个Long 不能强制转换:
- public int getAllUserNum(){
- Session session = HiberSF.getSession();
- try {
- session.getTransaction().begin();
- Long lo = (Long)session.createQuery("select count(*) from User").uniqueResult();
- //解决办法把long型拆分字符串进行转换
- Integer sum = new Integer(String.valueOf(lo));
- session.getTransaction().commit();
- return sum;
- } catch (RuntimeException e) {
- session.getTransaction().rollback();
- throw e;
- // TODO: handle exception
- } finally {
- session.close();
- }
- }