transitinfohomedao.java

来自「一个关于物流的管理系统」· Java 代码 · 共 64 行

package com.shunshi.ssh.dao;

import java.sql.SQLException;
import java.util.List;

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


import com.shunshi.ssh.entity.Transitinfo;

public class TransitinfoHomeDao extends HibernateDaoSupport{
	public Transitinfo findById(int id){
		Transitinfo t=null;
		List l=getHibernateTemplate().find("from Transitinfo t where t.id=?",new Integer(id));
		if(l!=null){
			t=(Transitinfo)l.get(0);
		}
		return t;
		
	}

	public List preList() {
		List all=(List) getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query q=session.createQuery("from Transitinfo t where t.state=:state order by t.publishDate desc");
				q.setInteger("state", 2);
				q.setFirstResult(0);
				q.setMaxResults(5);
				List all=q.list();
				return all;
			}
			
		});
		return all;
	}
	public List listAll(final int state,final int start,final int max){
		List all=(List) getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query q=session.createQuery("from Transitinfo t where t.state=:state");
				q.setInteger("state", state);
				q.setFirstResult(start);
				q.setMaxResults(max);
				List<Transitinfo> all=q.list();
				return all;
			}
			
		});
		
		return all;
	}
	public Long getTotalRowsByState(int state){
		return (Long)getHibernateTemplate().find("select count(*) from Transitinfo t where t.state=?",state).get(0);
		
	}
}