由于Hibernate3.2.5版本的(select count(*))查询返回的结果是个Long 不能强制转换:
- publicintgetAllUserNum(){
- Sessionsession=HiberSF.getSession();
- try{
- session.getTransaction().begin();
- Longlo=(Long)session.createQuery("selectcount(*)fromUser").uniqueResult();
- //解决办法把long型拆分字符串进行转换
- Integersum=newInteger(String.valueOf(lo));
- session.getTransaction().commit();
- returnsum;
- }catch(RuntimeExceptione){
- session.getTransaction().rollback();
- throwe;
- //TODO:handleexception
- }finally{
- session.close();
- }
- }
public int getAllUserNum(){
Session session = HiberSF.getSession();
try {
session.getTransaction().begin();
//解决办法直接调用:HashCode();
//count(*)也可以理解为返回一个Object的对象,然后直接
//调用 hashCode();
Integer lo = (Integer)session.createQuery("select count(*) from User").uniqueResult().hashCode();
session.getTransaction().commit();
return sum;
} catch (RuntimeException e) {
session.getTransaction().rollback();
throw e;
// TODO: handle exception
} finally {
session.close();
}
}