Hibernate Framework Learning Data Query (HQL) HelloWorld

 Packagecn.itcast.h3.hql;Importjava.util.List;ImportOrg.hibernate.Query;Importorg.hibernate.Session;ImportCn.itcast.h3.hql.vo.StudentModel;ImportCn.itcast.h3.hql.vo.TeacherModel;ImportCn.itcast.h3.util.HibernateUtil; Public classHqlapp {//test a simple query    voidtestsimple () {Session s=hibernateutil.getsession (); //1.HQLString hql = "from Teachermodel"; //2.QueryQuery q =s.createquery (HQL); //3. Get query ResultsList<teachermodel> querylist =q.list ();  for(Teachermodel tm:querylist) {SYSTEM.OUT.PRINTLN (tm);    } s.close (); }    //chained format    voidtestlinked () {Session s=hibernateutil.getsession (); //3. Get query Resultslist<teachermodel> querylist = S.createquery ("From Teachermodel where UUID <=:uuid"). Setfirstresult (1). Setmaxresults (3). Setlong ("uuid", 3L). List ();  for(Teachermodel tm:querylist) {SYSTEM.OUT.PRINTLN (tm);    } s.close (); }    //alias Format    voidTestalias () {Session s=hibernateutil.getsession (); //1.HQLString hql = "Select Um.nick from Teachermodel um"; //2.QueryQuery q =s.createquery (HQL); //3. Get query ResultsList<string> querylist =q.list ();  for(String tm:querylist) {SYSTEM.OUT.PRINTLN (tm);    } s.close (); }    //Aggregation Functions    voidTestfunctoin () {Session s=hibernateutil.getsession (); //1.HQLString hql = "Select sum (age) from Studentmodel"; //2.QueryQuery q =s.createquery (HQL); Long Avgage=(Long) Q.uniqueresult ();        System.out.println (Avgage);    S.close (); }    //Query by Criteria    voidTestentityquery () {Session s=hibernateutil.getsession (); //1.HQL//Who is the teacher with number 4?//String hql = "from Studentmodel where teacher.uuid=: UUID";//        //2.Query//Query q = s.createquery (HQL);//Q.setlong ("uuid", 4L);String hql= "from Studentmodel where teacher =: Teacher"; Query Q=s.createquery (HQL); Teachermodel TM=NewTeachermodel (); Tm.setuuid (4L);//tm.setteachername ("Li Joliang"); //Assigning object parameters to HqlQ.setentity ("Teacher", TM); List<StudentModel> querylist =q.list ();  for(Studentmodel sm:querylist) {System.out.println (SM); }    }    //Unconditional Query    voidTestnocondquery () {Session s=hibernateutil.getsession (); String hql= "from Teachermodel where teachername = Nick"; Query Q=s.createquery (HQL); List<TeacherModel> querylist =q.list ();  for(Teachermodel sm:querylist) {System.out.println (SM); }    }    //projection Query    voidTestotherquery () {Session s=hibernateutil.getsession (); String hql= "Select New Teachermodel (Teachername,nick) from Teachermodel"; Query Q=s.createquery (HQL); List<TeacherModel> querylist =q.list ();  for(Teachermodel sm:querylist) {System.out.println (SM); }    }    //projection Query List    voidTestOtherQuery2 () {Session s=hibernateutil.getsession (); String hql= "Select New List (Teachername,nick) from Teachermodel"; Query Q=s.createquery (HQL); List<List<String>> querylist =q.list ();  for(list<string>sm:querylist) {             for(String sa:sm) {System.out.println (SA); }        }    }    //Query Grouping    voidTestgroupquery () {Session s=hibernateutil.getsession (); String hql= "Select Skill,count (skill) from Studentmodel group by skill"; Query Q=s.createquery (HQL); List<Object[]> querylist =q.list ();  for(object[] objs:querylist) { for(Object obj:objs) {System.out.print (obj+ "\ T");        } System.out.println (); }    }    //Query Grouping    voidtestobejcts () {Session s=hibernateutil.getsession (); String hql= "From Java.lang.Object"; Query Q=s.createquery (HQL); List<Object> querylist =q.list ();  for(Object obj:querylist) {System.out.println (obj); }    }    //configuration-formatted queries    voidTestconfquery () {Session s=hibernateutil.getsession (); Query Q= S.getnamedquery ("GetAll"); Q.setstring ("Name", "Li Joliang"); List<Object> querylist =q.list ();  for(Object obj:querylist) {System.out.println (obj); }    }         Public Static voidMain (string[] args) {NewHqlapp (). Testconfquery (); }}

Hibernate Framework Learning Data Query (HQL) HelloWorld