userfactory.java

来自「JSP＋Struts＋Hibernate实现的用户登录系统。」· Java 代码 · 共 55 行

package cn.com.zzb.eshopping.model;

import java.util.Iterator;
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;;
public abstract class UserFactory {
    /******取出所有用户信息*****/
	public Iterator ListUsers() throws HibernateException{

		Session session = HibernateUtil.currentSession();
		Transaction tx = session.beginTransaction();
		Query query = session.createQuery("from SqlUser");
		List list = query.list();
        tx.commit();
		HibernateUtil.closeSession();
		return list.iterator();
	}
	/*****根据用户名取出对应的一名用户信息*****/
	public User ListUser(String userid){
		User user = null;
		Session session = HibernateUtil.currentSession();
		Transaction tx = session.beginTransaction();
		Query query = session.createQuery("from SqlUser as u where u.userid=:userid");
		query.setParameter("userid",userid);
		List list = query.list();
        if(!list.isEmpty())
			user = (User)list.get(0);
		tx.commit();
		HibernateUtil.closeSession();
		return user;
	}
	/*****根据用户名取出对应的一名用户信息*****/
	public User ListUser(Session session,String userid){
		User user = null;
		Transaction tx = session.beginTransaction();
		Query query = session.createQuery("from SqlUser as u where u.userid=:userid");
		query.setParameter("userid",userid);
		List list = query.list();
        if(!list.isEmpty())
			user = (User)list.get(0);
		tx.commit();
		return user;
	}	
	
	public abstract String ChkUser(String userid,String password);
	public abstract List listMyProducts(int id);
	public abstract int countProduct(int user_id,int p_id);
	public abstract void buyProduct(User user,Product product);
	public abstract void delProduct(User user,Product product);
}