Hibernate的批量查询——HQL

public static void testSel() {
            Session session = HibernateUtils.openSession();
            Transaction transaction = session.beginTransaction();
            String hql="from pers.zhb.domain.Student";
            Query query= session.createQuery(hql);
            List<Student>list=query.list();
            System.out.println(list);
            transaction.commit();
            session.close();//游离状态
        }

public static void testSel() {
            Session session = HibernateUtils.openSession();
            Transaction transaction = session.beginTransaction();
            String hql="from pers.zhb.domain.Student where sex=‘女‘";
            Query query= session.createQuery(hql);
            List<Student>list=query.list();
            System.out.println(list);
            transaction.commit();
            session.close();//游离状态
        }

public static void testSel() {
            Session session = HibernateUtils.openSession();
            Transaction transaction = session.beginTransaction();
            String hql="from pers.zhb.domain.Student where studentno=?";
            Query query= session.createQuery(hql);
            query.setInteger(0,937221524);
            Student student= (Student) query.uniqueResult();//获取唯一值
            System.out.println(student);
            transaction.commit();
            session.close();
        }

 public static void testSel() {
            Session session = HibernateUtils.openSession();
            Transaction transaction = session.beginTransaction();
            String hql="from pers.zhb.domain.Student where sex=?";
            Query query= session.createQuery(hql);
            //query.setFetchSize(0,"女");
            query.setParameter(0,"女");//通用
            List<Student> list=query.getResultList();
            System.out.println(list);
            transaction.commit();
            session.close();
        }

public static void testSel() {
            Session session = HibernateUtils.openSession();
            Transaction transaction = session.beginTransaction();
            String hql="from pers.zhb.domain.Student where sex=:sex";
            Query query= session.createQuery(hql);
            query.setParameter("sex","女");//通用
            List<Student> list=query.getResultList();
            System.out.println(list);
            transaction.commit();
            session.close();
        }

  public static void testSel() {
            Session session = HibernateUtils.openSession();
            Transaction transaction = session.beginTransaction();
            String hql="from pers.zhb.domain.Student where sex=:sex";
            Query query= session.createQuery(hql);
            query.setFirstResult(0);//从0开始
            query.setMaxResults(2);//抓取两条数据
            query.setParameter("sex","女");//通用
            List<Student> list=query.getResultList();
            System.out.println(list);
            transaction.commit();
            session.close();
        }