goodshomedao.java

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

package com.shunshi.ssh.home.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.Goods;


public class GoodsHomeDao extends HibernateDaoSupport {
	public Goods findById(Long id){
		Goods g=null;
		List l=getHibernateTemplate().find("from Goods g where g.id=?",id);
		if(l!=null){
			g=(Goods)l.get(0);
		}
		return g;
		
	}

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

			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query q=session.createQuery("from Goods g where g.state=:state order by g.publishTime desc");
				q.setInteger("state", 2);
				q.setFirstResult(0);
				q.setMaxResults(5);
				List<Goods> 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 Goods g where g.state=:state");
				q.setInteger("state", state);
				q.setFirstResult(start);
				q.setMaxResults(max);
				List<Goods> all=q.list();
				return all;
			}
			
		});
		
		return all;
	}
	public Long getTotalRowsByState(int state){
		return (Long)getHibernateTemplate().find("select count(*) from Goods g where g.state=?",state).get(0);
		
	}
}