flightdaofromhbn.java

航空售票系统的代码

package com.tarena.abs.dao;

import com.tarena.abs.model.*;

import java.sql.*;
import java.util.*;
import java.util.Date;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
/**
 * 	int string string string number
 * id name passwd,email score
 * @author zhoukai
 *
 */
public class FlightDaoFromHbn implements FlightDAO {

	@Override
	public boolean addFlight(Flight fl) {
		Session s = null;
		Transaction t = null;
		boolean b = false;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 
			 s.save(fl);
			t.commit();
			b = true;
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		return b;
	}

	@Override
	public boolean addFlightSchedular(FlightSchedular fs) {
		Session s = null;
		Transaction t = null;
		boolean b = false;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 s.save(fs);
			t.commit();
			b = true;
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		return b;
	}

	@Override
	public Set getAllFlights(String fromAddr, String toAddr, Calendar calendar) {
		Session s = null;
		Transaction t = null;
		HashSet hs = new HashSet();
		List l = null;

		//Date d = date.getDate();
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			/* String hql="from Flight f where f.sch.fromAddress=? and  f.sch.toAddress=? and f.calendar=?";
			  l = s.createQuery(hql)
			  		.setString(0, fromAddr)
			  		.setString(1, toAddr)
			  		.setCalendar(2,calendar)
			  		.list();*/
			 //String hql = "from Flight";
			 //l = s.createQuery(hql).list();
			 //hs.addAll(l);
			 String hql="from Flight f where f.sch.fromAddress=? and f.sch.toAddress=?";
			 l = s.createQuery(hql)
		  		.setString(0, fromAddr)
		  		.setString(1, toAddr)
		  		.list();
			 for(Flight f:(List<Flight>)l){
				 if(f.getCalendar().equals(calendar)){
					 hs.add(f);
					 System.out.println("equals");
				 }
				 if(f.getCalendar().get(Calendar.YEAR)==calendar.get(Calendar.YEAR)
						 && f.getCalendar().get(Calendar.MONTH)==calendar.get(Calendar.MONTH)
						 && f.getCalendar().get(Calendar.DATE)==calendar.get(Calendar.DATE)){
					 
					 hs.add(f);
					 System.out.println("=,=,=");
				 }
			 }
			 
			  System.out.println("DAO查到的符合条件的航班集合"+hs);
			t.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
       return hs;
		
	}

	@Override
	public Set getAllFlightSchedulars() {
		Session s = null;
		Transaction t = null;
		HashSet hs = new HashSet();
		List l = null;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 String hql="from FlightSchedular";
			  l = s.createQuery(hql)
			  		.list();
			  System.out.println("DAO查到的所有航班计划是："+l);
			  hs.addAll(l);
			t.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		
       return hs;
	}

	@Override
	public boolean order(Order ord) {
		return false;
	}

	@Override
	public boolean removeFlightSchedular(String flightNumber) {
		Session s = null;
		Transaction t = null;
		List l = null;
		boolean b = false;
		try {
			 s = HbnUtil.getSession();
			 t = s.beginTransaction();
			 String hql="from FlightSchedulars where flightNumber=?";
			 FlightSchedular fs = (FlightSchedular)s.createQuery(hql)
			  		.setString(0, flightNumber)
			  		.uniqueResult();
			 s.delete(fs);
			t.commit();
			b = true;
		} catch (HibernateException e) {
			e.printStackTrace();
			t.rollback();
		} finally{
			if(s!=null)try{s.close();}catch(Exception e){e.printStackTrace();}
		}
		
       return b;
	}

	@Override
	public void removeOverDateFlights() {
		// TODO Auto-generated method stub
		
	}
	
}