"HQL" paging query, object navigation query, external named query, connection query, query filter, statistical query

Paging Query

List students = Session.createquery ("from Student")                        . Setfirstresult (1)                        . Setmaxresults (2 )                        . List ();              for (Iterator iter=students.iterator (); Iter.hasnext ();) {                = (Student) Iter.next ();                System.out.println (Student.getname ());            }

Object Navigation Query

Session = hibernateutils.getsession ();            Session.begintransaction ();             = Session.createquery ("From Student s where s.classes.name like '%2% '")                        . List ();              for (Iterator iter=students.iterator (); Iter.hasnext ();) {                = (Student) Iter.next ();                System.out.println (Student.getname ());            }

External named queries

List students = Session.getnamedquery ("querystudent")                                    . Setparameter (0, ten)                                    . List ();              for (Iterator iter=students.iterator (); Iter.hasnext ();) {                = (Student) Iter.next ();                System.out.println (Student.getname ());            }

Connection Query

 List students = session.createquery ("Select C.name, s.name from Student s join s.classes C" ). List ();  for  (Iterator iter=students.iterator (); Iter.hasnext ();)                {object[] obj  = (object[]) iter.next ();            System.out.println (obj[ 0] + "," + Obj[1

 List students = session.createquery ("Select C.name, s.name from Student s left join s.classes C" ). List ();  for  (Iterator iter=students.iterator (); Iter.hasnext ();)                {object[] obj  = (object[]) iter.next ();            System.out.println (obj[ 0] + "," + Obj[1

List students = Session.createquery ("Select C.name, s.name from Student s right join s.classes C")                        . List ();              for (Iterator iter=students.iterator (); Iter.hasnext ();) {                = (object[]) iter.next ();                System.out.println (obj[0] + "," + obj[1]);            }

Query filter

Session.enablefilter ("Testfilter")                    . Setparameter ("myID", "ten");             = Session.createquery ("from Student"). List ();              for (Iterator iter=students.iterator (); Iter.hasnext ();) {                = (Student) Iter.next ();                System.out.println (Student.getname ());            }

Statistics Query

 List List = Session.createquery ("SELECT count (*) from Student"  //  Long Count = (long) list.get (0);   Long Count  = (Long) session.createquery ("SELECT count (*) from S Tudent "). Uniqueresult ();  //  Long Count = (long) session.createquery ("SELECT count (*) from Student")  
    
     //
      //  System.out.println ("count=" + count); 

String hql = "Select C.name, Count (s) from Classes C joins c.students s GROUP by c.name Order by C.name";             = Session.createquery (hql). List ();              for (int i=0; i<students.size (); i++) {                = (object[]) students.get (i);                System.out.println (obj[0] + "," + obj[1]);            }

"HQL" paging query, object navigation query, external named query, connection query, query filter, statistical query