messedao.java

一个关于物流的管理系统

package com.shunshi.ssh.dao;

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

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.shunshi.ssh.entity.Messe;

public class MesseDao extends HibernateDaoSupport implements IMesseDao {

	public List findMesseInfoByState(final byte state,final int startRow,final int maxRowNum) {
		List messeInfos=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("select messe from Messe messe where messe.state=:state");
				query.setByte("state",state);
				query.setMaxResults(maxRowNum);
				query.setFirstResult(startRow);
				List messeInfos=new ArrayList();
				List messes=query.list();
				for(int i=0;i<messes.size();i++){
					Messe messe=(Messe)messes.get(i);
					Map messeMap=new HashMap();
					messeMap.put("name",messe.getName());
					messeMap.put("starttime",messe.getStarttime());
					messeMap.put("locazone",messe.getLocazone());
					messeMap.put("sponsor",messe.getSponsor());
					messeMap.put("organizer",messe.getOrganizer());
					messeMap.put("contact",messe.getContact());
					messeMap.put("telephone",messe.getTelephone());
					messeMap.put("focus",messe.getFocus());
					messeMap.put("intro",messe.getIntro());
					messeMap.put("publishDate",messe.getPublishDate());
					messeMap.put("userId",messe.getUserId());
					messeMap.put("state",messe.getState());
					messeMap.put("id",messe.getId());
					messeInfos.add(messeMap);
				}
				return messeInfos;
			}
		});
		return messeInfos;
	}

	public int getTotalRowsByState(int state) {
		String hql="select count(*) from Messe messe where messe.state=:state";
		return ((Long)super.getHibernateTemplate().findByNamedParam(hql, "state", new Integer(state)).get(0)).intValue();
	}

	public void updateMesseInfo(Messe messe) {
		getHibernateTemplate().update(messe);
		
	}

	public void addMesseInfo(Messe messe) {
		getHibernateTemplate().saveOrUpdate(messe);
		
	}

	public Messe findMesseById(long id) {
		String hql="from Messe messe where messe.id=:id";
		return (Messe)getHibernateTemplate().findByNamedParam(hql, "id", Long.valueOf(id)).get(0);
	}

	public void deleteMesse(Messe messe) {
		getHibernateTemplate().delete(messe);
		
	}

	public Messe findMesseByMaxId(){
		String hql="select Max(id) from Messe messe";
		Long id=(Long)getHibernateTemplate().find(hql).get(0);
		return findMesseById(id.longValue());
		
	}
	

}