searchdao.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.OrderItem;
import orm.Flight;
import java.util.Iterator;
import java.text.ParseException; 
import java.text.SimpleDateFormat; 
import java.text.*;
import java.util.Date;
import java.util.Calendar;

public class SearchDao extends HibernateDaoSupport {
   private static final Log log=LogFactory.getLog(SearchDao.class);
   private String hql="from Flight flight where flight.start_place=? and flight.end_place=? ";
   private String hql1="from OrderItem item where item.flight=?";
   private String hql2="from OrderItem item";
   private String hql3="from OrderItem item where item.flight.start_place=? and item.flight.end_place=? and item.date=?";
   private String hql4="from OrderItem item where item.date=? ";
   private String hql5="from OrderItem item where item.date between ? and ? ";
   
      protected  void initDaO()
   {
	   
   }
 /* public static long getQuot(String time1, String time2){ 
	   long quot = 0; 
	   SimpleDateFormat ft = new SimpleDateFormat("yyyy/MM/dd"); 
	   try { 
	   Date date1 = ft.parse( time1 ); 
	   Date date2 = ft.parse( time2 ); 
	   quot = date1.getTime() - date2.getTime(); 
	   quot = quot / 1000 / 60 / 60 / 24; 
	   } catch (ParseException e) { 
	   e.printStackTrace(); 
	   } 
	   return quot; 
	   } 
*/
   public List getFlight(String stap,String endp,Date dt)
   {
	   List list=null;
	   Object []flightlist=new Object [3];
	   flightlist[0]=stap;
	   flightlist[1]=endp;
	   flightlist[2]=dt;
	   try {
		   list=this.getHibernateTemplate().find(hql3,flightlist);
		   
	   }
	   catch(Exception e)
	   {
		   log.error(e.getMessage());
		   return null;
	   }
	   return list;
	
   }
   public List getOrderit(Date dt)
   {
	   
	   List list=null;
	  // String []flightlist=new String [3];
	  // flightlist[0]=dt.toString();
	   //flightlist[1]=stap;
	 //  flightlist[2]=endp;
	   try {
		   list=this.getHibernateTemplate().find(hql4,dt);
		   
	   }
	   catch(Exception e)
	   {
		   log.error(e.getMessage());
		   return null;
	   }
	   return list;
	
   }
   public List getOrderit2(Date dt,Date dd)
   
   {
	   
	   List list=null;
	 // String []flightlist=new String [2];
	  //flightlist[0]=dt.toString();
	  //flightlist[1]=dd.toString();
	   
	   String hql7="from OrderItem item where item.date between '"+dt+"' and '"+dd+"'";
	   try {
		   list=this.getHibernateTemplate().find(hql7,dt);
		   
	   }
	   catch(Exception e)
	   {
		   log.error(e.getMessage());
		   return null;
	   }
	   return list;
	
   }
  public List getOrderit1(int i,String stap, String endp)
   {   
	  List list=null;
	   try {
		   Object []flightlist=new Object[4];
		   flightlist[0]=stap;
			flightlist[1]=endp;
			Calendar   c   =   Calendar.getInstance();//可以对每个时间域单独修改   
			 int   year   =   c.get(Calendar.YEAR);   
			 int   month   =   c.get(Calendar.MONTH)+1;   
			  int   dat  =   c.get(Calendar.DATE);   
			  Date dt=new Date(year-1900,month-1,dat);
				  
		// Date dt=new Date();
			  flightlist[2]=dt;
			  SimpleDateFormat format1 = new SimpleDateFormat("yyyy-MM-dd"); 
		     Date dd=new Date();
		   long  myTime=(dt.getTime()/1000)+60*60*24*i; 
			dd.setTime(myTime*1000); 
			String  mDate=format1.format(dd); 
			Date date = format1.parse(mDate); 
			flightlist[3]=date;
			String hql6="from OrderItem item where item.flight.start_place=? and item.flight.end_place=? and item.date>=? and item.date<=?";
			list=this.getHibernateTemplate().find(hql6,flightlist);
		   
	   }
	   catch(Exception e)
	   {
		   log.error(e.getMessage());
		   return null;
	   }
	   return list;
	
   }
   /*public List getresults(String stapl, String endpl)
   {   
	   OrderItem item=null;
	   List list=null;
	   list=this.getHibernateTemplate().find(hql2);
	   Iterator it=list.iterator();
	   while(it.hasNext())
	   {
		   item=(OrderItem)it.next();
		   
	   }
   }
   */
   public List getAllOrderitem(Long id)
   
   {
	   List li=null;
	   try{
		   Flight fli=(Flight)this.getHibernateTemplate().load(Flight.class,id);
		   li=this.getHibernateTemplate().find(hql1,fli);
	   }
	   catch(Exception e)
	   {
		   log.error(e.getMessage());
		   return null;
	   }
	   return li;
   }
   
}