memberdao.java

struts1 hibernate3 电子购物商城源码 加上了ANT编译.

package dream.ourshopping.persistence;

import java.util.List;
import org.apache.log4j.Logger;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.criterion.Example;

import dream.ourshopping.domain.Member;

/**
 * Data access object (DAO) for domain model class Member.
 * @see com.study.hibernate.Member
 * @author MyEclipse - Hibernate Tools
 */
public class MemberDAO extends BaseHibernateDAO {

	private static Logger log=Logger.getLogger(MemberDAO.class.getName());

	//property constants
	public static final String USERNAME = "username";
	public static final String PASSWORD = "password";
	public static final String REALNAME = "realname";
	public static final String TEL = "tel";
	public static final String ADDRESS = "address";
	public static final String ZIP = "zip";
	public static final String EMAIL = "email";

    
    public void save(Member transientInstance) {
        log.debug("saving Member instance");
        try {
            getSession().save(transientInstance);
            log.debug("save successful");
        } catch (RuntimeException re) {
            log.error("save failed", re);
            throw re;
        }
    }
    
	public void delete(Member persistentInstance) {
        log.debug("deleting Member instance");
        try {
            getSession().delete(persistentInstance);
            log.debug("delete successful");
        } catch (RuntimeException re) {
            log.error("delete failed", re);
            throw re;
        }
    }
    
    public Member findById( java.lang.Integer id) {
        log.debug("getting Member instance with id: " + id);
        try {
            Member instance = (Member) getSession()
                    .get("dream.ourshopping.domain.Member", id);
            return instance;
        } catch (RuntimeException re) {
            log.error("get failed", re);
            throw re;
        }
    }
    
    public List findMemberCountLikeByName(java.lang.String name) {
		log.debug("管理员对用户名" + name +"进行数量模糊查询");
		try {
			name = "'%" + name + "%'";
			Query q = getSession().createQuery(
					"select count(*) from Member p where p.username like " + name);
			List instance = q.list();
			return instance;
		} catch (RuntimeException re) {
			log.error("管理员对用户名进行数量模糊查询失败", re);
			throw re;
		}
	}
    
    public List findMemberLikeByName(java.lang.String name,int page) {
		log.debug("管理员对用户名" + name +"进行模糊查询");
		try {
			name = "'%" + name + "%'";
			Query q = getSession().createQuery(
					"from Member p where p.username like " + name);
			q.setFirstResult(page);
			q.setMaxResults(10);
			List instance = q.list();
			return instance;
		} catch (RuntimeException re) {
			log.error("管理员对用户名进行模糊查询失败", re);
			throw re;
		}
	}
    
    public List findByExample(Member instance) {
        log.debug("finding Member instance by example");
        try {
            List results = getSession()
                    .createCriteria("dream.ourshopping.domain.Member")
                    .add(Example.create(instance))
            .list();
            log.debug("find by example successful, result size: " + results.size());
            return results;
        } catch (RuntimeException re) {
            log.error("find by example failed", re);
            throw re;
        }
    }    
    
    public List findByProperty(String propertyName, Object value) {
      log.debug("finding Member instance with property: " + propertyName
            + ", value: " + value);
      try {
         String queryString = "from Member as model where model." 
         						+ propertyName + "= ?";
         Query queryObject = getSession().createQuery(queryString);
		 queryObject.setParameter(0, value);
		 return queryObject.list();
      } catch (RuntimeException re) {
         log.error("find by property name failed", re);
         throw re;
      }
	}
    
    public List findMaxId() {
		log.debug("getting Member instance MaxId: ");
		try {

			Query q = getSession().createQuery("select max(p.id)from Member p");
			
			List instance = q.list();
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}
    
    

	public List findByUsername(Object username) {
		return findByProperty(USERNAME, username);
	}
	
	public List findByPassword(Object password) {
		return findByProperty(PASSWORD, password);
	}
	
	public List findByRealname(Object realname) {
		return findByProperty(REALNAME, realname);
	}
	
	public List findByTel(Object tel) {
		return findByProperty(TEL, tel);
	}
	
	public List findByAddress(Object address) {
		return findByProperty(ADDRESS, address);
	}
	
	public List findByZip(Object zip) {
		return findByProperty(ZIP, zip);
	}
	
	public List findByEmail(Object email) {
		return findByProperty(EMAIL, email);
	}
	
    public Member merge(Member detachedInstance) {
        log.debug("merging Member instance");
        try {
            Member result = (Member) getSession()
                    .merge(detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            throw re;
        }
    }

    public void attachDirty(Member instance) {
        log.debug("attaching dirty Member instance");
        try {
            getSession().saveOrUpdate(instance);
            log.debug("attach successful");
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            throw re;
        }
    }
    
    public void attachClean(Member instance) {
        log.debug("attaching clean Member instance");
        try {
            getSession().lock(instance, LockMode.NONE);
            log.debug("attach successful");
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            throw re;
        }
    }
}