HIbernate多表操作（连接）

多表操作测试类

public class HQLJoinTest {
	//显示内连接
	@Test
	public void test1() {
		Session session = HibernateUtils.openSession();
		session.beginTransaction();
		
		String hql = "from Customer c inner join c.orders with c.id = 1";
		Query query = session.createQuery(hql);
		//结果得到一个list集合，集合里面的每一个元素是Object数组，每一个数组里面有一个Customer对象与一个Order对象
		List<Object[]> list = query.list();
		for (Object[] objects : list) {
			for (Object object : objects) {
				System.out.print(object+"\t");
			}
		}
		
		session.getTransaction().commit();
		session.close();
	}

	
	//隐式内连接
	@Test
	public void test2() {
		Session session = HibernateUtils.openSession();
		session.beginTransaction();
		
		//一个Order只有一个c
		String hql = "from Order o where o.c.id = 1 ";
		//一个c有好多个Order，所以c.orders.cCustomerId行不通？
		//String hql = "from Customer c where c.orders.cCustomerId = 1 ";
		Query createQuery = session.createQuery(hql);
		List list = createQuery.list();
		System.out.println(list);
		
		session.getTransaction().commit();
		session.close();
	}
	
	//迫切内连接
	//迫切内连接得到的结果是直接封装到PO类中，而内连接得到的是Object[]数组，数组中封装的是PO类对象。
	@Test
	public void test3() {
		Session session = HibernateUtils.openSession();
		session.beginTransaction();
		
		//使用distinct去重
		//注意:fetch不可以与单独条件的with一起使用
		String hql = "select distinct c from Customer c inner join fetch c.orders where c.id = 1 ";
		//String hql = "select distinct o from Order o inner join fetch o.c ";
		Query createQuery = session.createQuery(hql);
		List<Customer> list = createQuery.list();//集合中是from后面的对象
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		session.getTransaction().commit();
		session.close();
	}
	
	//测试外连接
	@Test
	public void test4() {
		Session session = HibernateUtils.openSession();
		session.beginTransaction();
		
		String hql = "from Customer c left outer join c.orders";
		Query createQuery = session.createQuery(hql);
		List<Object[]> list = createQuery.list();
		for (Object[] objects : list) {
			for (Object object : objects) {
				System.out.println(object+"\t");
			}
		}
		
		session.getTransaction().commit();
		session.close();
	}
	
	//迫切左外连接
	@Test
	public void test5() {
		Session session = HibernateUtils.openSession();		
		session.beginTransaction();
		
		// 注意:fetch不可以与单独条件的with一起使用
		String hql = "select distinct c from Customer c left outer join fetch c.orders where c.id = 1";
		Query createQuery = session.createQuery(hql);
		List<Customer> list = createQuery.list();
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		session.getTransaction().commit();
		session.close();
	}
	
	
}