purchasedao.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;

public class PurchaseDao extends HibernateDaoSupport{
	private static final Log log = LogFactory.getLog(PurchaseDao.class);
	private String hql = "from OrderItem item where item.date>=?";
		
	protected void initDao() {	
	}
	
	public List getAllFlights(){
		List list = null;
		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);
		try{
			list = this.getHibernateTemplate().find(hql,dt);
		}catch(Exception e){
			log.error(e.getMessage());
			return null;
		}
		
		return list;
	}
	
	public boolean PurchaseFlight(Long uid, Long oid){
		int i=0,fcount;
		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();
		try
		{   
			
			Us user = (Us)this.getHibernateTemplate().load(Us.class,uid);
			OrderItem item = (OrderItem)this.getHibernateTemplate().load(OrderItem.class,oid);
			fcount=item.getFcount();
			fcount=fcount-1;
			order.setUser(user);
		
			order.setstate(i);
			order.setCreatedate(dt);
		    item.setFcount(fcount);			
			this.getHibernateTemplate().update(item);
		}
		catch(Exception e){
	        log.error(e.getMessage());
	        return false;
		}
		try{
			this.getHibernateTemplate().save(order);
		}catch(Exception e){
			log.error(e.getMessage());
			return false;
		}
		return true;
	}
	public OrderItem getOrderitembyid(Long oid)
	{    OrderItem item=null;
		try{
			 item = (OrderItem)this.getHibernateTemplate().load(OrderItem.class,oid);
		}
		catch(Exception e)
		{
	        log.error(e.getMessage());
	        return null;
		}
		return item;
	}
}