requisitiondaohibernateimpl.java

一个可以发表文章的程序.该程序框架是j2ee框架.

package com.jsfabc.jsh.model.dao.hibernateImpl;

import java.util.List;
import com.jsfabc.jsh.model.bo.RequisitionState;
import com.jsfabc.jsh.model.bo.Requisition;
import com.jsfabc.jsh.model.dao.RequisitionDao;
import org.hibernate.Hibernate;
import org.hibernate.HibernateException;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class RequisitionDaoHibernateImpl extends HibernateDaoSupport implements RequisitionDao{
	
	public Integer saveRequisition(Requisition requisition) throws DataAccessException{
		return (Integer)this.getHibernateTemplate().save(requisition);
	}
    
	public List findRequisitionsForRatify()throws DataAccessException{
		RequisitionState reqState=new RequisitionState();
		reqState.setRequisitionStateId("10");
		return (List)this.getHibernateTemplate().find("from Requisition where requisitionState=?",reqState);
		
	}
   
	public List findBuyArticles(final Integer requisitionId)throws DataAccessException{
		return (List)getHibernateTemplate().execute(
				new HibernateCallback(){
					public Object doInHibernate(Session session)throws HibernateException{
					   
						String sSql =" select bb.articleId  articleId,a.articleName articleName,a.unit unit,a.currentPrice currentPrice,bb.requisitionNumber requisitionNumber,bb.subtotalprice subtotalprice from buybill bb,article a where bb.articleId=a.articleId and bb.requisitionId=:id ";
						
						SQLQuery query = session.createSQLQuery(sSql);
						
						query.addScalar("articleId", Hibernate.INTEGER);
						query.addScalar("articleName",Hibernate.STRING);
						query.addScalar("unit",Hibernate.STRING);
						query.addScalar("currentPrice",Hibernate.DOUBLE);
						query.addScalar("requisitionNumber",Hibernate.INTEGER);
						query.addScalar("subTotalPrice", Hibernate.DOUBLE);
						
						
						
						query.setInteger("id", requisitionId);
						
						List result=(List)query.list();
						
						
	
											
						return result;
					}
				}
			,true);	
	}
 
	
	public void updateRequisitionRatify(Requisition requisition)throws DataAccessException{
		this.getHibernateTemplate().update(requisition);
	}
	
	public List findAllRequisitions()throws DataAccessException{
	
		return (List)this.getHibernateTemplate().find("from Requisition");
		
	}
	
}