messedao.java

一个关于物流的管理系统

package com.shunshi.ssh.home.dao;

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


/**
 * A data access object (DAO) providing persistence and search support for Messe
 * 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 com.shunshi.ssh.entity.Messe
 * @author MyEclipse Persistence Tools
 */

public class MesseDAO extends HibernateDaoSupport implements IMesseDao{
	private static final Log log = LogFactory.getLog(MesseDAO.class);
    private static final int MAX_ROW_NUM=3;
	protected void initDao() {
		// do nothing
	}


	public Messe findById(java.lang.Long id) {
		log.debug("getting Messe instance with id: " + id);
		try {
			Messe instance = (Messe) getHibernateTemplate().get(
					"com.shunshi.ssh.entity.Messe", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}


	public List findAll() {
		log.debug("finding all Messe instances");
		try {
			String queryString = "from Messe";
			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 Messe messe where messe.state=? ";
			return (Long)getHibernateTemplate().find(queryString,state).get(0);
		} catch (RuntimeException re) {
			log.error("find  failed", re);
			throw re;
		}
	}

	public List findSomePublishInfo() {
		List messesInfos=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("select messes from Messe messes where messes.state=:state order by messes.publishDate desc");
				query.setInteger("state",2);
				query.setMaxResults(MAX_ROW_NUM);
				query.setFirstResult(0);
				List messesInfos=new ArrayList();
				List messes=query.list();
				DateFormat df=DateFormat.getDateInstance(DateFormat.MEDIUM);
				for(int i=0;i<messes.size();i++){
					Messe messesInfo=(Messe)messes.get(i);
					Map messesMap=new HashMap();
					messesMap.put("id", messesInfo.getId());
					messesMap.put("name",messesInfo.getName());
					messesMap.put("publishDate", df.format(messesInfo.getPublishDate()));
					messesInfos.add(messesMap);
				}
				return messesInfos;
			}
		});
		return messesInfos;
	}

	public List findMorePublishInfo(final int startRow, final int maxRowNum) {
		List messesInfos=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("select messes from Messe messes where messes.state=:state");
				query.setInteger("state",2);
				query.setMaxResults(maxRowNum);
				query.setFirstResult(startRow);
				List messesInfos=new ArrayList();
				DateFormat df=DateFormat.getDateInstance(DateFormat.MEDIUM);

				List messes=query.list();
				for(int i=0;i<messes.size();i++){
					Messe messesInfo=(Messe)messes.get(i);
					Map messesMap=new HashMap();
					messesMap.put("name",messesInfo.getName());
					messesMap.put("starttime", messesInfo.getStarttime());
					messesMap.put("publishDate", df.format(messesInfo.getPublishDate()));
					messesMap.put("id",messesInfo.getId());
					messesInfos.add(messesMap);
				}
				return messesInfos;
			}
		});
		return messesInfos;
	}

}