nativequery.java

《基于Eclipse的开源框架技术与实战》[第8章]随书源码

package com.free.hibernate.select;

import java.util.Iterator;
import java.util.List;

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 NativeQuery {
	public static void main(String[] args) {
		HibernateUtil.buildSessionFactory();
		Session session = HibernateUtil.currentSession();
		//查询Contact表，并转换成Contact对象
		List insurance = session.createSQLQuery("select  con.id as {c.id},"+
				"con.firstName as {c.firstName},"+
				"con.lastName as {c.lastName},"+
				"con.email as {c.email} from Contact con")
			.addEntity("c",Contact.class).list();
		//遍历所有的Contact对象
		for (Iterator it = insurance.iterator(); it.hasNext();) {
			Contact contact = (Contact) it.next();
			System.out.println("ID: " + contact.getId());
			System.out.println("Name: " + contact.getFirstName() + " "
					+ contact.getLastName());

		}

		session.close();

	}
}