package com.gordon.test;

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.utils.HibernateUtil;

import com.sun.org.apache.bcel.internal.generic.NEW;

/**

 * 条件查询

 * @author Administrator

 */

public class TestDemo4 {

	/**

	 * 条件查询

	 * 查询结果1：

		Hibernate:

		    select

		        book0_.id as id1_0_,

		        book0_.name as name2_0_,

		        book0_.price as price3_0_,

		        book0_.publisher_id as publishe4_0_

		    from

		        t_book book0_

		    where

		        book0_.price>?

		云计算技术及性能优化

		中国冰雪梦

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

	 */

	@Test

	public void run1() {

		Session session = HibernateUtil.getCurrentSession();

		Transaction transaction = session.beginTransaction();

		// 两种方式查询结果相同

		//1

//		String hql = "from Book b where b.price > ?";

//		Query query = session.createQuery(hql);

//		query.setParameter(0, new Double(44.00));

		//2

		String hql = "from Book b where b.price > :price";

		Query query = session.createQuery(hql);

		query.setParameter("price", new Double(44.00));

		List<Book> list = query.list();

		for (Book book : list) {

			System.err.println(book.getName());

		}

		transaction.commit();

	}

}