daoutil.java

老师给的在线航班系统

package com.toa.abs.server;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import com.toa.abs.dao.BranchDAO;
import com.toa.abs.dao.FlightDAO;
import com.toa.abs.dao.FlightDaoForDB;
import com.toa.abs.dao.OrderDAO;
import com.toa.abs.dao.PlaneModelDAO;
import com.toa.abs.dao.SaleDAO;

public class DaoUtil {
	public static FlightDAO flightDao;
	public static OrderDAO orderDao;
	public static PlaneModelDAO planeModelDao;
	public static SaleDAO saleDao;
	public static BranchDAO branchDao;

	public static Properties pro;
	public static String configFileName="dao_config.ini";
	

	
	public void init(){
		pro=new Properties();
		try {
			FileInputStream fis=new FileInputStream(configFileName);
			pro.load(fis);
			String drivers=pro.getProperty("DriverClass");
			if(drivers!=null){
				System.setProperty("jdbc.drivers",drivers);
			}
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
		flightDao=new FlightDaoForDB();
		
		
	}
	
	public static Connection createConnection(){
		Connection conn=null;
		try {
			conn=DriverManager.getConnection(pro.getProperty("URL"),pro.getProperty("UserName"),pro.getProperty("Password"));
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	public static void closeConnection(Connection conn){
		try {
			conn.commit();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static String getFlightTableName(){
		return pro.getProperty("FlightTableName").trim();
	}
	
	public static String getFlightSchedulerTableName(){
		return pro.getProperty("FlightSchedulerTableName").trim();
	}
	
	public static String getAirportTableName(){
		return pro.getProperty("AirportTableName").trim();
	}
	
	public static String getSalesTableName(){
		return pro.getProperty("SalesTableName").trim();
	}
	
	public static String getBranchTableName(){
		return pro.getProperty("BranchTableName").trim();
	}
	
	public static String getTicketTableName(){
		return pro.getProperty("TicketTableName").trim();
	}
	
	public static String getAirplaneModelTableName(){
		return pro.getProperty("AirplaneModelTableName").trim();
	}
	

}