flightdaofordb.java

老师给的在线航班系统

package com.toa.abs.dao;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Calendar;
import java.util.Set;

import com.toa.abs.model.FlightScheduler;
import com.toa.abs.model.Order;
import com.toa.abs.server.DaoUtil;

public class FlightDaoForDB implements FlightDAO{
	
	
	public FlightDaoForDB(){
		
	}

	public boolean addFlightSchedular(FlightScheduler fs) {
		
		try {
			Connection conn=DaoUtil.createConnection();
			Statement sta=conn.createStatement();
			sta.execute("INSERT INTO "+DaoUtil.getFlightSchedulerTableName()+
					"(flight_number,start_date,end_date,from_city,to_city,departure_time,arrival_time,airplane,scheduler,sail_length,full_price) VALUES ("
					+fs.getFlightNumber()+","+new java.sql.Date());
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	public Set getAllFlights(String fromAddr, String toAddr, Calendar date) {
		// TODO Auto-generated method stub
		return null;
	}

	public Set getAllFlightSchedulars() {
		// TODO Auto-generated method stub
		return null;
	}

	public boolean order(Order ord) {
		// TODO Auto-generated method stub
		return false;
	}

	public boolean removeFlightSchedular(String flightNumber) {
		// TODO Auto-generated method stub
		return false;
	}

	public void updateFlights() {
		// TODO Auto-generated method stub
		
	}
	
	

}