productfactory.java

JSP+Struts+Hibernate进行网络开发的一个实例

package cn.com.zzb.eshopping.model;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import cn.com.zzb.eshopping.db.HibernateUtil;
import cn.com.zzb.eshopping.model.sql.SqlProduct;
public abstract class ProductFactory {

	/*****取出单个产品信息（包括产品类型）******/
	public List listProduct(int id) throws HibernateException
	{
		Product product = new SqlProduct();
		Session session = HibernateUtil.currentSession();
		Transaction tx = session.beginTransaction();
		Query query = session.createQuery("select p,p.kind.name from SqlProduct as p where p.id=:id");
		query.setInteger("id",id);
		List list = query.list();
		tx.commit();
		HibernateUtil.closeSession();
		return list;
	}
	/*****取出所有产品信息（包括产品类型）*****/
	public List listProducts() throws HibernateException
	{
		Session session = HibernateUtil.currentSession();
		Transaction tx = session.beginTransaction();
		Query query = session.createQuery("select p,p.kind.name from SqlProduct as p");
		List list = query.list();
		tx.commit();
		HibernateUtil.closeSession();
		return list;
	}	
}