Hibernate HQL查询

1package cn.sasa.test;
2
3import org.hibernate.Session;
4import org.hibernate.Transaction;
5
6import cn.sasa.domain.account;
7import cn.sasa.utils.HibernateUtils;
8
9public class TestHQL {
10    @org.junit.Test
11    public void test() {
12        Session session = HibernateUtils.getCurrentSession();
13        Transaction tran = session.beginTransaction();
14        
15        String hql = "from account";//查询所有记录
16        var query = session.createQuery(hql);
17        var list = query.list();//返回多个记录
18        //var list = query.uniqueResult();//返回一条记录
19        System.out.println(list);
20        
21        String hql1 = "from account where id=:id";//查找一条记录
22        var query1 = session.createQuery(hql1);
23        query1.setParameter("id", 1);
24        var acObj = (account)query1.uniqueResult();
25        System.out.println(acObj);
26        
27        String hql2 = "from account where id=?0";//查找一条记录
28        var query2 = session.createQuery(hql2);
29        query2.setParameter(0, 1);
30        var acObj2 = (account)query2.uniqueResult();
31        System.out.println(acObj2);
32        
33        //分页
34        String hql3 = "from account ";
35        var query3 = session.createQuery(hql3);
36        //limit ?,?
37        query3.setFirstResult(0);
38        query3.setMaxResults(3);
39        var list3 = query3.list();
40        System.out.println(list3);
41        
42        
43        tran.commit();
44        session.close();
45    }
46    
47    
48}