Hibernate 13.HQL (ii)

Native SQL query:

@Testpublic void Querysqltest () {Session session=null;try{session=hibernateutil.opensession (); String sql= "SELECT * from T_student   where student_name like?"; SQLQuery query=session.createsqlquery (SQL); query.addentity (student.class);//starting from the first few records Query.setfirstresult (0);// Query.setmaxresults per page size: query.setstring (0, "% wang"); List<student> list=query.list (); for (Student stu:list) {System.out.println (Stu);}} Finally{session.close ();}}

Object navigation Query (inner JOIN):

@Testpublic void Querynavigationtest () {Session session=null;try{session=hibernateutil.opensession (); String hql= "from Student Stu where stu.user.userid=?"; Query query=session.createquery (HQL); Query.setinteger (0, 21); Student stu= (Student) Query.uniqueresult (); System.out.println (stu);} Finally{session.close ();}}

Connection query:

@Testpublic void Queryjointest () {Session session=null;try{session=hibernateutil.opensession (); String hql= "Select Stu from Student stu join Stu.user u  where u.userid=?"; Query query=session.createquery (HQL); Query.setinteger (0, 21); Student stu= (Student) Query.uniqueresult (); System.out.println (stu);} Finally{session.close ();}}

Left Join answer query:

@Testpublic void Queryleftjointest () {Session session=null;try{session=hibernateutil.opensession (); String hql= "Select Stu from Student Stu the left join Stu.user u where u.username are not NULL"; Query query=session.createquery (HQL); List<student> list=query.list (); for (Student stu:list) {System.out.println (Stu);}} Finally{session.close ();}}

Hibernate 13.HQL (ii)