@Test
public void test() {
    SessionFactory sf = null;
    Session session = null;
    Transaction ts = null;
    try {
        sf = HibernateUtil.getSessionFactory();
        session = sf.getCurrentSession();
        ts = session.beginTransaction();    // 開始事務
        // Query query = session.createQuery("from User as u where (u.age > (select avg(u.age) from User as u)) ");
        // Query query = session.createQuery("from User as u order by u.birthday,u.name desc");
        // Query query = session.createQuery("select u.gender, avg(u.age), count(*) from User as u group by u.gender having avg(u.age) > 21 ");
        // Query query = session.createQuery("from User as u where u.name like ?1 and u.age > ?2");
        //query.setParameter(1, "%張%");
        //query.setParameter(2, 10);
        
        Query query = session.createQuery("from User");
        
        int n1 = 3, n2 = 10;    // 每頁十條記錄，查詢第三頁
        /*
        * setFirstResult下標從0開始計算，第n1頁前，共n2*(n1-1)條記錄
        * 當前記錄id應該為n2*(n1-1)+1
        * 下標從零開始計算，所以傳參應該為：n2*(n1-1)+1-1=n2*(n1-1)
        */ 
        query.setFirstResult(n2 * (n1 - 1)).setMaxResults(n2); 
        
        List<User> list = query.list();
        for (int i = 0; i < list.size(); ++i) 
            System.out.println(list.get(i));
        ts.commit();    // 提交事務
    } catch (Exception e) {
        e.printStackTrace();
        if (ts != null) {
            ts.rollback();  // 回滾
        }
    } 
}