createorderdao.java

jsp+struct网上订票系统

package dao;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import orm.Order;
import orm.OrderItem;
import orm.Us;
import java.util.Date;
import java.util.Calendar;
import java.util.Date;
import orm.buyList;
import orm.ShopItem;
public class CreateOrderDao extends HibernateDaoSupport{
	private static final Log log = LogFactory.getLog(CreateOrderDao .class);
	public  Long createorder(Long uid)
	{
		Long id;
		int i=0;
		Calendar   c   =   Calendar.getInstance();//可以对每个时间域单独修改   
		  int   year   =   c.get(Calendar.YEAR);   
		  int   month   =   c.get(Calendar.MONTH)+1;   
		  int   date   =   c.get(Calendar.DATE);   
		  Date dt=new Date(year-1900,month-1,date);
		Order order = new Order();
		Us user = (Us)this.getHibernateTemplate().load(Us.class,uid);
		
		order.setstate(i);
		order.setCreatedate(dt);
		order.setUser(user);
		try
		{
			this.getHibernateTemplate().save(order);
			
		}
		catch(Exception e)
		{
			log.error(e.getMessage());
			return null;
		}
		try
		{
			id=order.getId();
		 	
		}
		catch(Exception e){
			log.error(e.getMessage());
			return null;
		}
		
	  return id;
	}

	public OrderItem getOrderItem(String flightno ,Date dt)
	{
		  OrderItem or=new OrderItem();
		  
		  String hql="from OrderItem item where item.flight.flight_no=? and item.date=?  ";
		  Object []flightlist=new Object [2];
		  flightlist[0]=flightno;
	      flightlist[1]=dt;
		   try 
		   {
			  or=(OrderItem)this.getHibernateTemplate().find(hql,flightlist);
			   
		   }
		   catch(Exception e)
		   {
			   log.error(e.getMessage());
			   return null;
		   }
		   return or;
	}
	public  boolean saveshopitem(buyList buylist,int linenum,Long id)
	{
		Order order = (Order)this.getHibernateTemplate().load(Order.class,id);
		OrderItem item = (OrderItem)this.getHibernateTemplate().load(OrderItem.class,buylist.itemid);
		ShopItem shopitem=new ShopItem();
		
		 long j=1;
		//Long h=new Long(j);
		//OrderItem or=new OrderItem();
		//or=getOrderItem(buylist.getFlightname(),buylist.getFlightdate());
		shopitem.setOrder(order);
		
		shopitem.setPrice(buylist.price);
		shopitem.setShopcount(buylist.number);
		shopitem.setItem(item);
	//	shopitem.setItemid(buylist.itemid);
		shopitem.setLinenum(linenum);
		OrderItem or = (OrderItem)this.getHibernateTemplate().load(OrderItem.class,buylist.itemid);
		shopitem.setRealcount(buylist.number);
	     int newfcount;
		newfcount=or.getFcount()-buylist.number;
		if(or.getFcount()==0)
			shopitem.setRealcount(0);
		else if(or.getFcount()>=buylist.number)
			shopitem.setRealcount(buylist.number);
		else 
		     shopitem.setRealcount(or.getFcount());
		   
		
		try{
			this.getHibernateTemplate().save(shopitem);
		}
		catch(Exception e)
		{
			log.error(e.getMessage());
			return false;
		} 
		try
		{    if(newfcount<0)
			  newfcount=0;
		    or.setFcount(newfcount);			
			this.getHibernateTemplate().update(or);
		}
		catch(Exception e){
	        log.error(e.getMessage());
	        return false;
		}
	
		return true;
		
	}
	
}