package org.teiid.quickstart.hibernate.service;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import org.teiid.quickstart.hibernate.model.ProductInfo;
public class ProductInfoService {
public static void main(String[] args) {
EntityManagerFactory factory = Persistence.createEntityManagerFactory("org.teiid.quickstart");
EntityManager em = factory.createEntityManager();
// insert(em);
List list = em.createQuery("SELECT product FROM ProductInfo product ").getResultList();
// List list = em.createNativeQuery("SELECT COUNT(*) FROM ProductInfo").getResultList();
System.out.println("Query Result:");
for(Object obj : list) {
System.out.println(" " + obj);
}
em.close();
factory.close();
}
private static void insert(EntityManager em) {
em.getTransaction().begin();
for(int i = 0 ; i < 10 ; i ++) {
em.persist(new ProductInfo(3000 + i, "KS", "ksoong.org"));
}
em.getTransaction().commit();
}
}