jpademo.java

随书光盘：精通Sping 2.0 的随书源代码

package test;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import test.entityjpa.Owners;

/**
 * 
 * @author worldheart
 * 
 */
public class JpaDemo {

	protected static final Log log = LogFactory.getLog(JpaDemo.class);

	public static void main(String[] args) {
		EntityManagerFactory emf = Persistence
				.createEntityManagerFactory("jpademo");
		EntityManager em = emf.createEntityManager();
		EntityTransaction et = em.getTransaction();
		et.begin();

		Owners own = em.find(Owners.class, 1);
		printResult(own);

		List list1 = em.createQuery(
				"from Owners own where own.lastName like 'E%'").getResultList();
		printResult(list1);

		List list2 = em.createQuery(
				"from Owners own where own.lastName like ?1").setParameter(1,
				"E%").getResultList();
		printResult(list2);

		List list3 = em.createQuery(
				"from Owners own where own.lastName like :lastName")
				.setParameter("lastName", "E%").getResultList();
		printResult(list3);

		List list4 = em.createNamedQuery("findOwnersByLastName").setParameter(
				"lastName", "E%").getResultList();
		printResult(list4);

		List list5 = em.createNativeQuery(
				"select * from Owners own where own.last_name like ?1",
				"getOwners").setParameter(1, "E%").getResultList();
		printResult(list5);

		List list6 = em.createNativeQuery(
				"select * from Owners own where own.last_name like ?1",
				Owners.class).setParameter(1, "E%").getResultList();
		printResult(list6);

		et.commit();
		em.close();
		emf.close();
	}

	public static void printResult(Object obj) {
		if (obj instanceof List) {
			for (Object owners : (List) obj) {
				Owners own = (Owners) owners;
				printOwners(own);
			}
		} else {
			Owners own = (Owners) obj;
			printOwners(own);
		}
	}

	public static void printOwners(Owners own) {
		log.info("id:" + own.getId() + ",address:" + own.getAddress()
				+ ",first_name:" + own.getFirstName() + ",last_name:"
				+ own.getLastName() + ",telephone:" + own.getTelephone()
				+ ",city:" + own.getCity() + ",pets:" + own.getPetses());
	}

}