hql 一对多判断子表是否为空_HQL之多表查询（一对多和多对多）

/**

* 1.一对多

* sql:select c.*,s.* from classes c,student s where c.cid=s.cid;

* hql:from Classes c,Student s where c.cid=s.classes.cid，注意与上句的区别；

* 得到的list是object[]，数组中的元素是Classes和Student对象；

*

*/

@Test

public void testOneToMany_EQ(){

Session   session = sessionFactory.openSession();

Query query = session.createQuery( "from Classes c,Student s where c.cid=s.classes.cid");

List list = query.list();

System. out.println(query.list().size());

session.close();

}

/**

* 2.带属性的查询；

* list中装的是object[];

*/

@Test

public void testOneToMany_EQ_Property(){

Session   session = sessionFactory.openSession();

Query query = session.createQuery( "select c.cname,s.sname from Classes c,Student s where c.cid=s.classes.cid");

query.list();

session.close();

}

/**

* 3.带属性查询，将查询结果封装成一个bean；

* 得到的list中装的是classView对象；

*/

@Test

public void testOneToMany_EQ_Property_Constructor(){

Session   session = sessionFactory.openSession();

Query query = session.createQuery( "select new cn.itheima03.hibernate.domain.ClassesView(c.cname,s.sname) " +

"from Classes c,Student s where c.cid=s.classes.cid");

List list = query.list();

session.close();

}

/**

* 4.内连接

* 结果与例子1一样；

*/

@Test

public void testOneToMany_InnerJoin_Query(){

Session   session = sessionFactory.openSession();

StringBuffer buffer = new StringBuffer();

buffer.append( "from Classes c inner join c.students s");

Query query = session.createQuery(buffer.toString());

query.list();

session.close();

}

/**

* 5.迫切内连接1：获取所有有学生的班级及班级下的学生；

* 要想得到的集合中装的Classes对象，对象中set集合中装student，可以使用迫切内链接。

*

*/

@Test

public void testOneToMany_InnerJoin_Fetch_Query_1(){

Session   session = sessionFactory.openSession();

StringBuffer buffer = new StringBuffer();

buffer.append( "from Classes c inner join fetch c.students s");

Query query = session.createQuery(buffer.toString());

List list = query.list();

session.close();

}

/**

* 6.迫切内连接2

* 从学生端出发；

*/

@Test

public void testOneToMany_InnerJoin_Fetch_Query_2(){

Session   session = sessionFactory.openSession();

StringBuffer buffer = new StringBuffer();

buffer.append( "from Student s inner join fetch s.classes c");

Query query = session.createQuery(buffer.toString());

query.list();

session.close();

}

/**

* 7.迫切内连接3：获取属性，封装结果；

* select new cn.itheima03.hibernate.domain.ClassView(c.cname,s.sname)

*   from Student s inner join fetch s.classes c；

* 上述的 hql语句会报错，因为from后面想要的结构和select想要的结构是冲突的，所以

如果在from后面加fetch,不能写select语句，如果加select，不能写fetch,两者只能选择其一

*

*/

@Test

public void testOneToMany_InnerJoin_Fetch_Query_Property(){

Session   session = sessionFactory.openSession();

StringBuffer buffer = new StringBuffer();

//下面的写法不对；

//        buffer.append("select new cn.itheima03.hibernate.domain.ClassView(c.cname,s.sname) " +

//                 " from Student s inner join fetch s.classes c");

//不要fetch;

buffer.append( "select new cn.itheima03.hibernate.domain.ClassesView(c.cname,s.sname)  " +

"  from Student s inner join  s.classes c " );

Query query = session.createQuery(buffer.toString());

List list = query.list();

session.close();

}

/**

* 8.迫切左外连接

* 从班级出发，得到班级对应的学生

*/

@Test

public void testOneToMany_LeftJoin_Fetch(){

Session   session = sessionFactory.openSession();

StringBuffer buffer = new StringBuffer();

buffer.append( "from Classes c left outer join fetch c.students s");

Query query = session.createQuery(buffer.toString());

List list = query.list();

for (Classes classes : list) {

System. out.println("classes:" +classes.getCname());

Set students = classes.getStudents();

for (Student student : students) {

System. out.println("     student:" +student.getSname());

}

}

session.close();

}

/**

* 9.迫切左外连接2

* 从学生出发，得到对应的班级

*/

@Test

public void testOneToMany_RightJoin_Fetch(){

Session   session = sessionFactory.openSession();

StringBuffer buffer = new StringBuffer();

buffer.append( "from Student s left outer join fetch s.classes ");

Query query = session.createQuery(buffer.toString());

List list = query.list();

for (Student student : list) {

System. out.println("student:" +student.getSname());

if (student.getClasses()!=null) {

System. out.println("     " +student.getClasses().getCname());

}

}

session.close();

}