hibernate Ö´ÐÐsql ²éѯ³ö×ÜÊý

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class GetCountForPage extends HibernateDaoSupport{
public List getCountForPage(final String sql){
  List list = getHibernateTemplate().executeFind(new HibernateCallback() {
    public Object doInHibernate(Session session)
    throws HibernateException, SQLException {
     Connection CurConn   =session.connection();
     PreparedStatement ps = CurConn.prepareStatement(sql);
     ResultSet result=ps.executeQuery();
                 result.next();
                  int sum=result.getInt(1);
                  List list=new ArrayList();
                  list.add(sum);
                  result.close();
                  ps.close();
                  CurConn.close();
              return list;
    }
   });
   return list;
}
}
Ö´ÐÐsql £ºselect count(1) from yourtable; ²éѯ³ö×ÜÊý¿