stockpiledao.java

这是一个物流管理系统

package dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import bean.Stockpile;
import bean.Goodssort;

import util.HibernateSessionFactory;

public class StockpileDAO {
	private Session session;
	private Transaction tr;
	public StockpileDAO(){
		session = HibernateSessionFactory.getSession();
	}
	public List<Stockpile> select(){
	tr=session.beginTransaction();
    List<Stockpile> l=(List<Stockpile>)session.createQuery
    ("from Stockpile st  where goodssortid=1000").list();
	tr.commit();
	session.close();
    if(l.isEmpty()){
		 System.out.println("goodssort kong");
		 return null;
	 }
    for(int i=0;i<l.size();i++){
    	Stockpile s=l.get(i);
    	System.out.println(s.getGoodsname());
    }
    return l;
	}
	public void updateOutamount(Long indentid, Long goodsamount) {
		tr=session.beginTransaction();
		IndentInfoDAO in_dao=new IndentInfoDAO();
		Long goodsid=in_dao.getStockpileGoodsid(indentid);
		Stockpile sto=new Stockpile();
		session.load(sto, goodsid);
		sto.setOutamount(sto.getOutamount()+goodsamount);
		session.update(sto);
		tr.commit();
	}
	public List getAllStockpile() {
		List list=null;
		String hql="FROM Stockpile";
		Query q=session.createQuery(hql);
		list=q.list();
		return list;
	}
	public void close() {
		session.close();
	}

	public List selectBySortid(String s){
		tr=session.beginTransaction();
		Long goodssortid=Long.parseLong(s);
		if(goodssortid>1005)
			return null;
		System.out.println("selectbysortidli"+goodssortid);
		List list=session.createQuery("select s.goodsid,s.goodssort.goodssortname,s.goodsname,s.goodsamount,s.units.unitname from Stockpile s where s.goodssort.goodssortid=:id")
		.setLong("id", goodssortid).list();
	    if(list.isEmpty()){
	    	System.out.println("stock null");
	    	return null;
	    }
	    System.out.println("stockdao执行了");
	    tr.commit();
	    session.close();
		return list;
	}
}