resumedao.java

一个关于物流的管理系统

package com.shunshi.ssh.dao;
// default package

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.shunshi.ssh.entity.Goods;
import com.shunshi.ssh.entity.Resume;
import com.shunshi.ssh.exception.GoodsDaoException;


/**
 	* A data access object (DAO) providing persistence and search support for Resume entities.
 			* Transaction control of the save(), update() and delete() operations 
		can directly support Spring container-managed transactions or they can be augmented	to handle user-managed Spring transactions. 
		Each of these methods provides additional information for how to configure it for the desired type of transaction control. 	
	 * @see .Resume
  * @author MyEclipse Persistence Tools 
 */

public class ResumeDAO extends HibernateDaoSupport implements IResumeDao {
    private static final Log log = LogFactory.getLog(ResumeDAO.class);
	//property constants
    private static final int MAX_ROW_NUM=8;
	protected void initDao() {
		//do nothing
	}
    
    public void save(Resume transientInstance) {
        log.debug("saving Resume instance");
        try {
            getHibernateTemplate().save(transientInstance);
            log.debug("save successful");
        } catch (RuntimeException re) {
            log.error("save failed", re);
            throw re;
        }
    }
    
	public void delete(Resume persistentInstance) {
        log.debug("deleting Resume instance");
        try {
            getHibernateTemplate().delete(persistentInstance);
            log.debug("delete successful");
        } catch (RuntimeException re) {
            log.error("delete failed", re);
            throw re;
        }
    }
    
	public void update(Resume instance) {
        log.debug("updating Resume instance");
        try {
            getHibernateTemplate().update(instance);
            log.debug("update successful");
        } catch (RuntimeException re) {
            log.error("update failed", re);
            throw re;
        }
    }
    public Resume findById( java.lang.Long id) {
        log.debug("getting Resume instance with id: " + id);
        try {
            Resume instance = (Resume) getHibernateTemplate()
                    .get("com.shunshi.ssh.entity.Resume", id);
            return instance;
        } catch (RuntimeException re) {
            log.error("get failed", re);
            throw re;
        }
    }
    
	public List findAll() {
		log.debug("finding all Resume instances");
		try {
			String queryString = "from Resume";
		 	return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public List findByUserId(Long uid) {
		log.debug("finding Resume instances by userId");
		try {
			String queryString = "from Resume r where userId=?";
		 	return getHibernateTemplate().find(queryString,uid);
		} catch (RuntimeException re) {
			log.error("find failed", re);
			throw re;
		}
	}

	public List findByState(final int state,final int startRow,final int maxRowNum) {
		List resumesInfos=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("from Resume resumes where resumes.state=?");
				query.setInteger(0, state);
				query.setMaxResults(maxRowNum);
				query.setFirstResult(startRow);
				List resumesInfos=new ArrayList();
				List resumes=query.list();
				for(int i=0;i<resumes.size();i++){
					Resume resumesInfo=(Resume)resumes.get(i);
					Map resumesMap=new HashMap();
					resumesMap.put("name",resumesInfo.getName());
					resumesMap.put("publishDate", resumesInfo.getPublishDate());
					resumesMap.put("userId", resumesInfo.getUserId());
					resumesMap.put("state",resumesInfo.getState());
					resumesMap.put("id",resumesInfo.getId());
					resumesInfos.add(resumesMap);
				}
				return resumesInfos;
			}
		});
		return resumesInfos;
	}
	public Long getTotalRowsByState(int state) {
		log.debug("finding rows");
		try {
			String queryString = "select count(*) from Resume resume where resume.state=?";
			return (Long)getHibernateTemplate().find(queryString,state).get(0);
		} catch (RuntimeException re) {
			log.error("find  failed", re);
			throw re;
		}
	}

	public List findMorePublishInfo(final int startRow, final int maxRowNum) {
		List resumesInfos=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("from Resume resumes where resumes.state=?");
				query.setInteger(0, 2);
				query.setMaxResults(maxRowNum);
				query.setFirstResult(startRow);
				List resumesInfos=new ArrayList();
				List resumes=query.list();
				for(int i=0;i<resumes.size();i++){
					Resume resumesInfo=(Resume)resumes.get(i);
					Map resumesMap=new HashMap();
					resumesMap.put("name",resumesInfo.getName());
					resumesMap.put("publishDate", resumesInfo.getPublishDate());
					resumesMap.put("spec", resumesInfo.getSpec2()+","+resumesInfo.getSpec3()+","+resumesInfo.getSpec4());
					resumesMap.put("id",resumesInfo.getId());
					resumesInfos.add(resumesMap);
				}
				return resumesInfos;
			}
		});
		return resumesInfos;
	}

	public List findSomePublishInfo() {
		List resumesInfos=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("from Resume resumes where resumes.state=?");
				query.setInteger(0, 2);
				query.setMaxResults(MAX_ROW_NUM);
				query.setFirstResult(0);
				List resumesInfos=new ArrayList();
				List resumes=query.list();
				for(int i=0;i<resumes.size();i++){
					Resume resumesInfo=(Resume)resumes.get(i);
					Map resumesMap=new HashMap();
					resumesMap.put("name",resumesInfo.getName());
					resumesMap.put("publishDate", resumesInfo.getPublishDate());
					resumesMap.put("spec", resumesInfo.getSpec2()+","+resumesInfo.getSpec3()+","+resumesInfo.getSpec4());
					resumesMap.put("id",resumesInfo.getId());
					resumesInfos.add(resumesMap);
				}
				return resumesInfos;
			}
		});
		return resumesInfos;
	}

	public Resume findResumeByMaxId() {
		String hql="select Max(id) from Goods goods";
		Long id=(Long)getHibernateTemplate().find(hql).get(0);
		Resume resume=findById(id.longValue());
		
		return resume;
	}

}