dao.java

这是一个物流管理系统

package dao;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.sql.Date;
import java.util.List;

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

import bean.Indentinfo;
import bean.Orderinfo;
import bean.State;
import bean.Stockpile;

import bean.Userinfo;

import util.HibernateSessionFactory;
public class Dao {
	Session s = null;
	Transaction tr = null;
    public List<Stockpile> getGoods(int type){
    	s = HibernateSessionFactory.getSession();
    	tr = s.beginTransaction();
    	
    	String hql = "from Stockpile s where s.goodssort.goodssortid =?";
    	Query q =s.createQuery(hql);
    	q.setInteger(0, type);
    	List<Stockpile> sps =q.list();
    	tr.commit();
    	return sps;
    }
    public  List<Stockpile> getGoods(String type){
    	s = HibernateSessionFactory.getSession();
    	tr = s.beginTransaction();
    	
    	String hql = "from Stockpile s where s.goodssort.goodssortname =?";
    	Query q =s.createQuery(hql);
    	q.setString(0, type);
    	List<Stockpile> sps =q.list();
    	tr.commit();    	
    	return sps;
    }
    public List<Stockpile> slectStockpile(long goodid){
    	s = HibernateSessionFactory.getSession();
    	tr = s.beginTransaction();
    	String hql = "from Stockpile s where s.goodsid =?";
    	Query q =s.createQuery(hql);
    	q.setLong(0, goodid);
    	List<Stockpile> sps =q.list();
    	tr.commit();
		return  sps;  
    }
    public List<Userinfo> selectUser(String name){
    	s = HibernateSessionFactory.getSession();
    	tr = s.beginTransaction();
    	String hql = "from Userinfo u where u.username =?";
    	Query q =s.createQuery(hql);
    	q.setString(0, name);
    	List<Userinfo> users =q.list();
    	tr.commit();
		return users;    	
    }
    public List<State> selectState(String statename){
    	Session s1 = HibernateSessionFactory.getSession();
    	Transaction tr1 = s.beginTransaction();
    	String hql = "from State t where t.statename =?";
    	Query q =s1.createQuery(hql);
    	q.setString(0, statename);
    	List<State> states =q.list();
    	tr1.commit();
		return states;    	
    }
    public void addOrder(Userinfo user,List<Stockpile> stockpiles,java.util.Date date){
    	s = HibernateSessionFactory.getSession();
    	tr = s.beginTransaction();
    	//生成瞬时的Orderinfo对象    	
    	Date ordertime = new Date(System.currentTimeMillis());
    	Orderinfo orderinfo = new Orderinfo();
    	orderinfo.setUserinfo(user);
    	String hql = "from State t where t.statename =?";
    	Query q =s.createQuery(hql);
    	q.setString(0, "未审核");
    	List<State> states =q.list();
    	orderinfo.setState(states.get(0));
    	orderinfo.setDelivertime(date);
    	orderinfo.setOrdertime(ordertime);
    	//持久化orderinfo
    	s.save(orderinfo);
    	
    	//循环持久化indentifo    	
    	
    	for(Stockpile sp:stockpiles){
    		Indentinfo indentinfo = new Indentinfo();
    		indentinfo.setStockpile(sp);    		       
        	indentinfo.setUnits(sp.getUnits());
        	indentinfo.setGoodsamount(Long.parseLong(sp.getIsbuynum()));
        	indentinfo.setOrderinfo(orderinfo);
        	s.save(indentinfo);
    	}     	
    	tr.commit();
    	
    	
    }
   
   
}