package com.gordon.test;

import java.util.Arrays;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.Transaction;

import org.junit.Test;

import com.gordon.domain.Book;

import com.gordon.domain.Publisher;

import com.gordon.utils.HibernateUtil;

/**

 * 连接查询

 * @author Administrator

 */

public class TestDemo5 {

	/**

	 * 连接查询-右外连接

	 * 查询结果

		Hibernate:

		    select

		        book0_.id as id1_0_0_,

		        publisher1_.id as id1_1_1_,

		        book0_.name as name2_0_0_,

		        book0_.price as price3_0_0_,

		        book0_.publisher_id as publishe4_0_0_,

		        publisher1_.name as name2_1_1_

		    from

		        t_book book0_

		    left outer join

		        t_publisher publisher1_

		            on book0_.publisher_id=publisher1_.id

		云计算技术及性能优化

		---电子工业出版社

		C语言程序设计

		---电子工业出版社

		中国冰雪梦

		---电子工业出版社

		Photoshop图形图像处理

		---北京大学出版社

		VisualBasic2015实践教程

		---北京大学出版社

		生产微服务

		---人民邮电出版社

		架构探险：轻量级微服务架构（下册）

		---人民邮电出版社

	 */

	@Test

	public void run4() {

		Session session = HibernateUtil.getCurrentSession();

		Transaction transaction = session.beginTransaction();

		String hql = "from Book b right join b.publisher p";

		Query query = session.createQuery(hql);

		Book b = null;

		Publisher p = null;

		List<Object[]> list = query.list();

		for (Object[] book : list) {

			b = (Book) book[0];

			p = (Publisher) book[1];

			System.out.println(b.getName());

			System.out.println("---" + p.getName());

		}

		transaction.commit();

	}

	/**

	 * 连接查询-左外连接

	 * 查询结果

		Hibernate:

		    select

		        book0_.id as id1_0_0_,

		        publisher1_.id as id1_1_1_,

		        book0_.name as name2_0_0_,

		        book0_.price as price3_0_0_,

		        book0_.publisher_id as publishe4_0_0_,

		        publisher1_.name as name2_1_1_

		    from

		        t_book book0_

		    left outer join

		        t_publisher publisher1_

		            on book0_.publisher_id=publisher1_.id

		云计算技术及性能优化

		---电子工业出版社

		C语言程序设计

		---电子工业出版社

		中国冰雪梦

		---电子工业出版社

		Photoshop图形图像处理

		---北京大学出版社

		VisualBasic2015实践教程

		---北京大学出版社

		生产微服务

		---人民邮电出版社

		架构探险：轻量级微服务架构（下册）

		---人民邮电出版社

	 */

	@Test

	public void run3() {

		Session session = HibernateUtil.getCurrentSession();

		Transaction transaction = session.beginTransaction();

		String hql = "from Book b left join b.publisher p";

		Query query = session.createQuery(hql);

		Book b = null;

		Publisher p = null;

		List<Object[]> list = query.list();

		for (Object[] book : list) {

			b = (Book) book[0];

			p = (Publisher) book[1];

			System.out.println(b.getName());

			System.out.println("---" + p.getName());

		}

		transaction.commit();

	}

	/**

	 * 连接查询-隐式内连接

	 * 查询结果

		Hibernate:

		    select

		        book0_.id as id1_0_0_,

		        publisher1_.id as id1_1_1_,

		        book0_.name as name2_0_0_,

		        book0_.price as price3_0_0_,

		        book0_.publisher_id as publishe4_0_0_,

		        publisher1_.name as name2_1_1_

		    from

		        t_book book0_ cross

		    join

		        t_publisher publisher1_

		    where

		        book0_.publisher_id=publisher1_.id

		云计算技术及性能优化

		---电子工业出版社

		C语言程序设计

		---电子工业出版社

		中国冰雪梦

		---电子工业出版社

		Photoshop图形图像处理

		---北京大学出版社

		VisualBasic2015实践教程

		---北京大学出版社

		生产微服务

		---人民邮电出版社

		架构探险：轻量级微服务架构（下册）

		---人民邮电出版社

	 */

	@Test

	public void run2() {

		Session session = HibernateUtil.getCurrentSession();

		Transaction transaction = session.beginTransaction();

		String hql = "from Book b, Publisher p where b.publisher = p";

		Query query = session.createQuery(hql);

		Book b = null;

		Publisher p = null;

		List<Object[]> list = query.list();

		for (Object[] book : list) {

			b = (Book) book[0];

			p = (Publisher) book[1];

			System.out.println(b.getName());

			System.out.println("---" + p.getName());

		}

		transaction.commit();

	}

	/**

	 * 连接查询-显示内连接

	 * 查询结果

		Hibernate:

		    select

		        book0_.id as id1_0_0_,

		        publisher1_.id as id1_1_1_,

		        book0_.name as name2_0_0_,

		        book0_.price as price3_0_0_,

		        book0_.publisher_id as publishe4_0_0_,

		        publisher1_.name as name2_1_1_

		    from

		        t_book book0_

		    inner join

		        t_publisher publisher1_

		            on book0_.publisher_id=publisher1_.id

		云计算技术及性能优化

		---电子工业出版社

		C语言程序设计

		---电子工业出版社

		中国冰雪梦

		---电子工业出版社

		Photoshop图形图像处理

		---北京大学出版社

		VisualBasic2015实践教程

		---北京大学出版社

		生产微服务

		---人民邮电出版社

		架构探险：轻量级微服务架构（下册）

		---人民邮电出版社

	 */

	@Test

	public void run1() {

		Session session = HibernateUtil.getCurrentSession();

		Transaction transaction = session.beginTransaction();

		String hql = "from Book b inner join b.publisher";

		Query query = session.createQuery(hql);

		Book b = null;

		Publisher p = null;

		List<Object[]> list = query.list();

		for (Object[] book : list) {

			b = (Book) book[0];

			p = (Publisher) book[1];

			System.out.println(b.getName());

			System.out.println("---" + p.getName());

		}

		transaction.commit();

	}

}