resumedao.java

一个关于物流的管理系统

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

import java.sql.SQLException;
import java.text.DateFormat;
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.Resume;


/**
 	* 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 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 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);
				DateFormat df=DateFormat.getDateInstance(DateFormat.MEDIUM);
				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("sex", resumesInfo.getSex());
					java.sql.Date now=java.sql.Date.valueOf(df.format(new Date()));
					resumesMap.put("age", now.getYear()-resumesInfo.getBirthdate().getYear());
					resumesMap.put("publishDate", df.format(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);
				DateFormat df=DateFormat.getDateInstance(DateFormat.MEDIUM);

				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", df.format(resumesInfo.getPublishDate()));
					resumesMap.put("id",resumesInfo.getId());
					resumesInfos.add(resumesMap);
				}
				return resumesInfos;
			}
		});
		return resumesInfos;
	}

}