package com.free.hibernate.select;

import java.util.Iterator;

import org.hibernate.Query;
import org.hibernate.Session;

import com.free.hibernate.bo.Contact;
import com.free.hibernate.util.HibernateUtil;

/**
 * <p>Title: Eclipse Plugin Development</p>
 * <p>Description: Free download</p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: Free</p>
 * @author gan.shu.man
 * @version 1.0
 */

public class SelectAndWhereClause {
	public static void main(String[] args) {
		//創建SessionFactory
		HibernateUtil.buildSessionFactory();
		//取得Session
		Session session = HibernateUtil.currentSession();
		System.out.println("*******************************");
		System.out.println("Query using Hibernate Query Language");
		//查詢Contact對象，并遍歷所有的Contact對象
		String SQL_QUERY = " from Contact as contact where contact.id='1'";
		Query query = session.createQuery(SQL_QUERY);
		for (Iterator it = query.iterate(); it.hasNext();) {
			Contact contact = (Contact) it.next();
			System.out.println("ID: " + contact.getId());
			System.out.println("Name: " + contact.getFirstName()+contact.getLastName());

		}
		System.out.println("*******************************");
		System.out.println("Where Clause With Select Clause");
		//通過條件選擇出符合條件的對象屬性
		SQL_QUERY = "Select contact.id,contact.firstName,contact.lastName"
				+ " from Contact contact "
				+ " where contact.id='1'";
		query = session.createQuery(SQL_QUERY);
		//遍歷所有的屬性
		for (Iterator it = query.iterate(); it.hasNext();) {
			Object[] row = (Object[]) it.next();
			System.out.println("ID: " + row[0]);
			System.out.println("Name: " + row[1]+row[2]);
			

		}
		System.out.println("*******************************");

		session.close();
	}
}