Hibernate hql,qbc,sql检索方式

 public class RetrievalTest {
    public static void main(String[] args) {
        RetrievalTest rt = new RetrievalTest();
        rt.hql();
        rt.qbc();
        rt.sql();
    }
 private void hql(){
        Session session = HibernateUtil.currentSession();
        Transaction tx = session.beginTransaction();
        Query query = session.createQuery("from Student as s where s.name =:studentName");
        query.setString("studentName", "westbrook");
        List list = query.list();
        System.out.println("list size: " + list.size());

        tx.commit();
        HibernateUtil.closeSession();

    }

    private void qbc(){
        Session session = HibernateUtil.currentSession();
        Transaction tx = session.beginTransaction();
        Criteria criteria = session.createCriteria(Student.class);
        Criterion ct = Expression.like("name","westbrook");
        criteria.add(ct);
        List list = criteria.list();
        System.out.println("list size: " + list.size());

        tx.commit();
        HibernateUtil.closeSession();

    }

    private void sql(){
        Session session = HibernateUtil.currentSession();
        Transaction tx = session.beginTransaction();
        Query query = session.createSQLQuery("select s.id,s.name from student_table s where s.name like:studentName");
        query.setString("studentName", "westbrook");
        List list = query.list();
        System.out.println("list size: " + list.size());

        tx.commit();
        HibernateUtil.closeSession();

    }
}