hibernate的一个分页的写法

直接上代码：

// 按条件分页查询投票集合
    public List<Subject> getSubjectList(String title, Integer pageNumber,
            Integer pageSize) {
        if(pageNumber==null){
            pageNumber = 1;
        }
        if(pageSize==null){
            pageSize =5;
        }
        Session session = null;
        List<Subject> list = null;
        try {
            session = HibernateUtil.currentSession();
            StringBuffer hql = new StringBuffer("select s.sid,s.title," +
                    "(select count(*) from Option o where o.subject.sid=s.sid)," +
                    "(select count(distinct user.uid) from Item i where i.subject.sid=s.sid)" +
                    "from Subject s where 1=1");
            if (title != null) {
                hql.append(" and s.title like '%"+title+"%'");
            }
            hql.append(" order by s.sid desc");
            Query query = session.createQuery(hql.toString());
            query.setFirstResult((pageNumber-1) * pageSize);
            query.setMaxResults(pageSize);      
            list = query.list();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }

别的不说了。