agenthomedao.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.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.shunshi.ssh.entity.Agent;






public class AgentHomeDao extends HibernateDaoSupport{

	public Agent findById(int id) {
		Agent a = null;
		List l=getHibernateTemplate().find("from Agent a where a.id=?",id);
		if (l != null) {
			a = (Agent) l.get(0);
		}
		return a;

	}

	
	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 Agent a where a.state=:state");
				q.setInteger("state", state);
				q.setFirstResult(start);
				q.setMaxResults(max);
				List all=q.list();
				return all;
			}
			
		});
		
		return all;
	}

	public Long getTotalRowsByState(int i) {
		
		return (Long)getHibernateTemplate().find("select count(*) from Agent a where a.state=?",i).get(0);
	}

	




	
}